How Can i insert an image in this form whose button submit code is as follows.
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();
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
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
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
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
INSERT INTO dbo.DEF_BRACKET_ACCESSORIES_MST (
[BracketSuspensionType]
,[Status]
,[CreatedBy]
,[CreatedOn]
,[PoleTypeID]
,[ImagePath]
) VALUES(
@BracketSuspensionType
,@Status
,@CreatedBy
,@CreatedOn
,@PoleTypeID
,@ImagePath
)
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]
END TRY
BEGIN CATCH
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