public int InsertInformation(BannerObject BannerObj)
{
SqlConnection con = GetConnection();
con.Open();
SqlCommand cmd = new SqlCommand("Insert_Banner", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PhotoPath", BannerObj.PhotoPath);
cmd.Parameters.AddWithValue("@BannerInformation", BannerObj.BannerInformation);
cmd.Parameters.AddWithValue("@UserId", BannerObj.UserId);
cmd.Parameters.AddWithValue("@Status", BannerObj.Status);
try
{
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
cmd.Dispose();
con.Close();
con.Dispose();
}
}
protected void btn_update_Click(object sender, EventArgs e)
{
BannerObject bannerObj = new BannerObject();
bannerObj.BannerId = int.Parse(Session["Banner_id"].ToString());
DataTable dt = dal.SelectInformationById(bannerObj.BannerId);
bannerObj.BannerInformation = tbxBannerInfo.Text;
bannerObj.UserId = Int32.Parse(Session["user_id"].ToString());
if (ddlBannerStatus.SelectedValue == "1")
{
bannerObj.Status = true;
}
else if (ddlBannerStatus.SelectedValue == "0")
{
bannerObj.Status = false;
}
if (PhotoUpload.HasFile)
{
string extension = Path.GetExtension(PhotoUpload.FileName);
string photopath = Guid.NewGuid().ToString() + extension;
string uploadFolder = "~/Banner_Photos/";
PhotoUpload.SaveAs(Server.MapPath(uploadFolder + photopath));
bannerObj.PhotoPath = photopath;
}
else
{
bannerObj.PhotoPath = dt.Rows[0]["PhotoPath"].ToString();
}
try
{
int result = dal.UpdateInformation(bannerObj);
if (result == 1)
{
getBannerById();
SuccessPanel.Visible = true;
}
else
{
DangerPanel.Visible = true;
}
}
catch
{
throw;
}
}
