Click here to Skip to main content
15,895,781 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How Can i insert an image in this form whose button submit code is as follows.

C#
protected void btn_add_Click(object sender, EventArgs e)
   {

       if (btn_add.Text == "Submit")
       {
           BracketAccessoriesEntity.BracketSuspensionType = Convert.ToString(txt_BracketSuspensionType.Text.Trim());
           BracketAccessoriesEntity.PoleTypeID = Convert.ToInt64(dd_PoleTypeID.SelectedValue.Trim());

           BracketAccessoriesEntity.Status = chk_Active.Checked;
           System.Collections.Hashtable ht = (System.Collections.Hashtable)Session["UserDetails"];
           Int64 UsrId = (Int64)ht["UserID"];
           BracketAccessoriesEntity.CreatedBy = UsrId; Convert.ToInt32(Convert.ToString(Session["UserID"]).Trim());
           BracketAccessoriesEntity.CreatedOn = (DateTime.Now);


           try
           {
               string result = logic.InsertData(BracketAccessoriesEntity);
               if (result == "SUCCESS")
               {
                   string jScript = "<script>alert ('" + "Record Inserted Successfully" + "')</script>";
                   ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "starScript", jScript, false);
                   clear();

                   //after insert is successful bind the grid again to show all data
                   BindGrid();
               }
               else
               {
                   string jScript = "<script>alert ('" + "Error in insertion. " + result.Replace("'", " ") + "')</script>";
                   ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "starScript", jScript, false);
               }
           }
           catch (Exception ex)
           {
               string jScript = "<script>alert ('" + ex.Message.Replace("'", " ") + "')</script>";
               ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "starScript", jScript, false);
           }
       }


This is the entities

C#
 public class BracketAccessoriesEntities
    {
        public long AccessoryID;
        public string BracketSuspensionType;
        public bool Status;
        public long CreatedBy;
        public DateTime CreatedOn;
        public long UpdatedBy;
        public DateTime UpdatedOn;
        public long PoleTypeID;
        public long ImagePath;


    }
}


And this is the bussiness logic

C#
public string InsertData(BracketAccessoriesEntities BracketAccessoriesEntity)
       {

           ISingleResult<SP_INSERT_INTO_BRACKET_ACCESSORIES_MSTResult> ds = context.SP_INSERT_INTO_BRACKET_ACCESSORIES_MST(BracketAccessoriesEntity.BracketSuspensionType, BracketAccessoriesEntity.Status, BracketAccessoriesEntity.CreatedBy, BracketAccessoriesEntity.CreatedOn, BracketAccessoriesEntity.PoleTypeID);

           string strResult = "ERROR";

           foreach (SP_INSERT_INTO_BRACKET_ACCESSORIES_MSTResult row in ds)
           {
               strResult = row.STATUS;
               if (strResult == "ERROR")
               {
                   strResult = row.ERROR_MESSAGE;
               }

           }

           return strResult;
       }


I have created an imagepath field in the table named "ImagePath". I want to store image path in database and image in a folder. But I don't know how to do it using entity framework.

Below is the stored procedure

SQL
ALTER PROCEDURE [dbo].[SP_INSERT_INTO_BRACKET_ACCESSORIES_MST]
	@BracketSuspensionType varchar(45) ,
	@Status bit ,
	@CreatedBy bigint ,
	@CreatedOn datetime ,
	@PoleTypeID bigint,
	@ImagePath image
AS
BEGIN
	SET NOCOUNT ON;
    BEGIN TRY
     --BEGIN TRANSACTION TransInsertBracketAccessories
		INSERT INTO dbo.DEF_BRACKET_ACCESSORIES_MST (/*Insert Statement*/
		[BracketSuspensionType]
      ,[Status]
      ,[CreatedBy]
      ,[CreatedOn]
      ,[PoleTypeID]
	  ,[ImagePath]
		) VALUES(
			@BracketSuspensionType
			,@Status
			,@CreatedBy
			,@CreatedOn
			,@PoleTypeID
			,@ImagePath
		)
	 /*Returns Success as result*/
	 SELECT 'SUCCESS' AS [STATUS],ERROR_LINE() [ERROR_LINE],ERROR_MESSAGE() [ERROR_MESSAGE],ERROR_NUMBER() [ERROR_NUMBER],ERROR_PROCEDURE() [ERROR_PROCEDURE],ERROR_SEVERITY() [ERROR_SEVERITY],ERROR_STATE() [ERROR_STATE],@@TRANCOUNT [TRANCOUNT],@@ROWCOUNT [ROWCOUNT]
     --COMMIT TRANSACTION TransInsertBracketAccessories
    END TRY
    BEGIN CATCH
	 --ROLLBACK TRANSACTION TransInsertBracketAccessories 
	 /*Returns Error*/
     SELECT  'ERROR' AS [STATUS],ERROR_LINE() [ERROR_LINE],ERROR_MESSAGE() [ERROR_MESSAGE],ERROR_NUMBER() [ERROR_NUMBER],ERROR_PROCEDURE() [ERROR_PROCEDURE],ERROR_SEVERITY() [ERROR_SEVERITY],ERROR_STATE() [ERROR_STATE],@@TRANCOUNT [TRANCOUNT],@@ROWCOUNT [ROWCOUNT]
    END CATCH
	SET NOCOUNT OFF;
END
Posted
Updated 17-Aug-15 19:43pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900