protected void ntnAddCategory_Click(object sender, EventArgs e)
{
try
{
ClassDate s = new ClassDate();
string datee = s.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
con.Open();
SqlCommand cmd = new SqlCommand("insert into tblbanner(heading1,heading2,heading3,image) values(@heading1,@heading2,@heading3,@image)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@heading1", txtheading1.Text);
cmd.Parameters.AddWithValue("@heading2", txtheading2.Text);
cmd.Parameters.AddWithValue("@heading3", txtheading3.Text);
cmd.Parameters.AddWithValue("@image", strfile1);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Successfully Submited');location.href='banner.aspx'", true);
}
}
catch { }
finally { con.Close(); }
}
public void image()
{
ClassDate s = new ClassDate();
string datee = s.date();
if (FileUpload1.HasFile)
{
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = Image1.ImageUrl;
}
SqlCommand cmd = new SqlCommand("proc_tblallpages", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@typee", "headerlogo");
cmd.Parameters.AddWithValue("@content", strfile1);
cmd.ExecuteNonQuery();
Image1.ImageUrl = all.showpagecontent("headerlogo");
}
protected void Button1x_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(str))
{
try
{
string datee = s.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
con.Open();
SqlCommand cmd = new SqlCommand("insert into tblPortfolio(catcode,catname,plan_name,heading,image)values(@catcode,@catname,@plan_name,@heading,@image)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@catcode", ddlcat.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@catname", ddlcat.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@plan_name", txtplanName.Text.Trim());
cmd.Parameters.AddWithValue("@heading", Textplanheading.Text);
cmd.Parameters.AddWithValue("@image", strfile1);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('Successfully Submitted')", true);
}
}
catch { }
finally { con.Close(); }
}
}
protected void btnupdate_Click(object sender, EventArgs e)
{
try
{
if (FileUpload1.HasFile)
{
ClassDate s = new ClassDate();
string datee = s.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = imgbanner.ImageUrl;
}
if (FileUpload2.HasFile)
{
ClassDate ss = new ClassDate();
string dateee = ss.date();
//==== Get file name without its extension.
string fileNameWithoutExtension2 = Path.GetFileNameWithoutExtension(FileUpload2.FileName);
string fileExtension2 = Path.GetExtension(FileUpload2.FileName);
fileNameWithoutExtension2 = dateee + fileNameWithoutExtension2;
FileUpload2.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension2 + fileExtension2));
strfile2 = "~/productimg/" + fileNameWithoutExtension2 + fileExtension2;
}
else
{
strfile2 = imgservice.ImageUrl;
}
con.Open();
SqlCommand cmd = new SqlCommand("update tblservice_details set service_banner=@service_banner,banner_heading1=@banner_heading1,banner_heading2=@banner_heading2,service_content=@service_content,service_image=@service_image where service_name=@service_name", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@service_name", ddlservice.SelectedItem.Text);
cmd.Parameters.AddWithValue("@service_banner", strfile1);
cmd.Parameters.AddWithValue("@banner_heading1", txtbannerheading1.Text);
cmd.Parameters.AddWithValue("@banner_heading2", txtbannerheading2.Text);
cmd.Parameters.AddWithValue("@service_content", Editor1.Content);
cmd.Parameters.AddWithValue("@service_image", strfile2);
//cmd.Parameters.AddWithValue("@var", "ins");
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true);
}
}
catch { }
finally { con.Close(); }
}
protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int userid = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString());
// string username = gvDetails.DataKeys[e.RowIndex].Values["UserName"].ToString();
TextBox txtheading = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txteditheading");
TextBox txtdesig = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txteditdegisnation");
TextBox txtcity = (TextBox)gvDetails.Rows[e.RowIndex].FindControl("txtcity");
Label lblimg1 = (Label)gvDetails.Rows[e.RowIndex].FindControl("lblimg");
FileUpload FileUpload1 = (FileUpload)gvDetails.Rows[e.RowIndex].FindControl("fileuploadedit");
ClassDate s = new ClassDate();
string datee = s.date();
if (FileUpload1.HasFile == true)
{
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = lblimg1.Text;
}
con.Open();
SqlCommand cmd = new SqlCommand("proc_tbltesti", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", txtheading.Text);
cmd.Parameters.AddWithValue("@degisnation", txtdesig.Text);
cmd.Parameters.AddWithValue("@desc_", txtcity.Text);
cmd.Parameters.AddWithValue("@img", strfile1);
cmd.Parameters.AddWithValue("@id", userid);
cmd.Parameters.AddWithValue("@var", "upda");
cmd.ExecuteNonQuery();
con.Close();
lblresult.ForeColor = Color.Green;
lblresult.Text = userid + " Details Updated successfully";
gvDetails.EditIndex = -1;
BindEmployeeDetails();
}
//public void Show_Feature(string topic)
//{
// con.Open();
// SqlCommand cmd = new SqlCommand("select * from tblservice_details where service_name=@service_name", con);
// cmd.CommandType = CommandType.Text;
// cmd.Parameters.AddWithValue("@topic", topic);
// SqlDataReader drr = cmd.ExecuteReader();
// if (drr.Read())
// {
// Txticon.Text = drr["icon"].ToString();
// txtheading.Text = drr["heading"].ToString();
// Editor1.Content = drr["content"].ToString();
// }
// con.Close();
//}
//public void service_name()
//{
// con.Open();
// SqlDataAdapter da = new SqlDataAdapter("select id,heading1 from tblhome_services", con);
// DataTable dt = new DataTable();
// da.Fill(dt);
// ddlservice.DataSource = dt;
// ddlservice.DataTextField = "heading1";
// ddlservice.DataValueField = "id";
// ddlservice.DataBind();
// ddlservice.Items.Insert(0, "----Pls. Choose Service Here----");
//}
protected void btnsubmit_Click1(object sender, EventArgs e)
{
try
{
ClassDate s = new ClassDate();
string datee = s.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
ClassDate ss = new ClassDate();
string dateee = ss.date();
//==== Get file name without its extension.
string fileNameWithoutExtension2 = Path.GetFileNameWithoutExtension(FileUpload2.FileName);
string fileExtension2 = Path.GetExtension(FileUpload2.FileName);
fileNameWithoutExtension2 = dateee + fileNameWithoutExtension2;
FileUpload2.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension2 + fileExtension2));
strfile2 = "~/productimg/" + fileNameWithoutExtension2 + fileExtension2;
con.Open();
SqlCommand cmd = new SqlCommand("insert into tblservice_details(service_banner,banner_heading1,banner_heading2,service_name,service_content,service_image)values(@service_banner,@banner_heading1,@banner_heading2,@service_name,@service_content,@service_image)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@service_banner", strfile1);
cmd.Parameters.AddWithValue("@banner_heading1", txtbannerheading1.Text);
cmd.Parameters.AddWithValue("@banner_heading2", txtbannerheading2.Text);
cmd.Parameters.AddWithValue("@service_name", txtservice.Text);
cmd.Parameters.AddWithValue("@service_content", Editor1.Content);
cmd.Parameters.AddWithValue("@service_image", strfile2);
//cmd.Parameters.AddWithValue("@var", "ins");
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Service Details Submited Successfully');location.href='service-details.aspx'", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Some Error Occurred!!!');", true);
}
txtbannerheading1.Text = "";
txtbannerheading2.Text = "";
txtservice.Text = "";
//ddlservice.SelectedItem.Text= "";
Editor1.Content = "";
}
catch { }
finally { con.Close(); }
}
protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("AddNew"))
{
TextBox txtUsrname = (TextBox)gvDetails.FooterRow.FindControl("txtftrusrname");
TextBox txtdesig = (TextBox)gvDetails.FooterRow.FindControl("txtftdegisnation");
TextBox txtCity = (TextBox)gvDetails.FooterRow.FindControl("txtftrcity");
FileUpload FileUpload1 = (FileUpload)gvDetails.FooterRow.FindControl("fileuploadfooter");
ClassDate s = new ClassDate();
string datee = s.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
con.Open();
SqlCommand cmd = new SqlCommand("proc_tbltesti", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", txtUsrname.Text);
cmd.Parameters.AddWithValue("@degisnation", txtdesig.Text);
cmd.Parameters.AddWithValue("@desc_", txtCity.Text);
cmd.Parameters.AddWithValue("@img", strfile1);
cmd.Parameters.AddWithValue("@var", "ins");
int result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
BindEmployeeDetails();
lblresult.ForeColor = Color.Green;
lblresult.Text = txtUsrname.Text + " Details inserted successfully";
}
else
{
lblresult.ForeColor = Color.Red;
lblresult.Text = txtUsrname.Text + " Details not inserted";
}
}
}
protected void Button1x_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(str))
{
try
{
string datee = s.date();
if (FileUpload1.HasFile == true)
{
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = Image1.ImageUrl;
}
con.Open();
SqlCommand cmd = new SqlCommand("update tblPortfolio set catcode=@catcode,catname=@catname,plan_name=@plan_name,heading=@heading,image=@image where id=@id", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@catcode", ddlcat.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@catname", ddlcat.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@plan_name", txtplan.Text.Trim());
cmd.Parameters.AddWithValue("@heading", Textheading.Text);
cmd.Parameters.AddWithValue("@image", strfile1);
cmd.Parameters.AddWithValue("@id", Request.QueryString["id_x"].ToString());
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('Successfully Updated')", true);
show(Request.QueryString["id_x"].ToString());
}
}
catch { }
finally { con.Close(); }
}
}
protected void Button1x_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
ClassDate clsdat = new ClassDate();
string datee = clsdat.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = lblfilePath.Text;
}
try
{
con.Open();
SqlCommand cmd = new SqlCommand("proc_tblService_Plan", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@var", "Update");
cmd.Parameters.AddWithValue("@service_id", ddlChooseInsuranceCategory.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@service_heading", ddlChooseInsuranceCategory.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@plan_name", txtplan.Text);
cmd.Parameters.AddWithValue("@plan_detail", Editor1.Content);
cmd.Parameters.AddWithValue("@download_plan", strfile1);
cmd.Parameters.AddWithValue("@id", Request.QueryString["id_x"].ToString());
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true);
}
}
catch { }
finally { con.Close(); }
}
protected void ntnAddCategory_Click(object sender, EventArgs e)
{
try
{
ClassDate s = new ClassDate();
string datee = s.date();
if (FileUpload1.HasFile)
{
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = Image1.ImageUrl;
}
con.Open();
SqlCommand cmd = new SqlCommand("update tblbanner set heading1=@heading1,heading2=@heading2,heading3=@heading3,image=@image where id=@id", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@heading1", txtheading1.Text);
cmd.Parameters.AddWithValue("@heading2", txtheading2.Text);
cmd.Parameters.AddWithValue("@heading3", txtheading3.Text);
cmd.Parameters.AddWithValue("@image", strfile1);
cmd.Parameters.AddWithValue("@id", Request.QueryString["id_x"].ToString());
cmd.Parameters.AddWithValue("@var", 4);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Successfully Updated');location.href='edit-banner.aspx?id_x=" + Request.QueryString["id_x"].ToString() + "'", true);
}
}
catch { }
finally { con.Close(); }
}
protected void Button1x_Click(object sender, EventArgs e)
{
try
{
con.Open();
ClassDate s = new ClassDate();
string datee = s.date();
if (FileUpload1.HasFile)
{
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = Image1.ImageUrl;
}
SqlCommand cmd = new SqlCommand("proc_tblallpages", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@typee", "headerlogo");
cmd.Parameters.AddWithValue("@content", strfile1);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true);
}
Image1.ImageUrl = all.showpagecontent("headerlogo");
}
catch { }
finally { con.Close(); }
}
protected void Button1x_Click(object sender, EventArgs e)
{
try
{
ClassDate s = new ClassDate();
string datee = s.date();
if (FileUpload1.HasFile)
{
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = Image1.ImageUrl;
}
con.Open();
SqlCommand cmd = new SqlCommand("proc_tblservices", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@var", "Update");
cmd.Parameters.AddWithValue("@content", Editor1.Content);
cmd.Parameters.AddWithValue("@img", strfile1);
cmd.Parameters.AddWithValue("@heading", ddlChooseInsuranceCategory.SelectedItem.ToString());
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Message", "alert('Successfully Updated');", true);
}
}
catch { }
finally { con.Close(); }
}
protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("AddNew"))
{
FileUpload FileUpload1 = (FileUpload)gvDetails.FooterRow.FindControl("fileuploadfooter");
ClassDate s = new ClassDate();
string datee = s.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
con.Open();
SqlCommand cmd = new SqlCommand("proc_tblclientlogos", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@img", strfile1);
cmd.Parameters.AddWithValue("@var", "ins");
int result = cmd.ExecuteNonQuery();
con.Close();
if (result == 1)
{
BindEmployeeDetails();
lblresult.ForeColor = Color.Green;
lblresult.Text = "Client Logo Inserted Successfully";
}
else
{
lblresult.ForeColor = Color.Red;
lblresult.Text = "Some Error Occurred!!!";
}
}
}
protected void btnsubmit_Click1(object sender, EventArgs e)
{
try
{
if (FileUpload1.HasFile)
{
ClassDate s = new ClassDate();
string datee = s.date();
//==== Get file name without its extension.
string fileNameWithoutExtension1 = Path.GetFileNameWithoutExtension(FileUpload1.FileName);
string fileExtension1 = Path.GetExtension(FileUpload1.FileName);
fileNameWithoutExtension1 = datee + fileNameWithoutExtension1;
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension1 + fileExtension1));
strfile1 = "~/productimg/" + fileNameWithoutExtension1 + fileExtension1;
}
else
{
strfile1 = imgplanbanner.ImageUrl;
}
if (FileUpload2.HasFile)
{
ClassDate ss = new ClassDate();
string dateee = ss.date();
//==== Get file name without its extension.
string fileNameWithoutExtension2 = Path.GetFileNameWithoutExtension(FileUpload2.FileName);
string fileExtension2 = Path.GetExtension(FileUpload2.FileName);
fileNameWithoutExtension2 = dateee + fileNameWithoutExtension2;
FileUpload2.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension2 + fileExtension2));
strfile2 = "~/productimg/" + fileNameWithoutExtension2 + fileExtension2;
}
else
{
strfile2 = imgplan.ImageUrl;
}
if (FileUpload3.HasFile)
{
ClassDate sss = new ClassDate();
string dateeee = sss.date();
//==== Get file name without its extension.
string fileNameWithoutExtension3 = Path.GetFileNameWithoutExtension(FileUpload3.FileName);
string fileExtension3 = Path.GetExtension(FileUpload3.FileName);
fileNameWithoutExtension3 = dateeee + fileNameWithoutExtension3;
FileUpload3.PostedFile.SaveAs(Server.MapPath("~/productimg/" + fileNameWithoutExtension3 + fileExtension3));
strfile3 = "~/productimg/" + fileNameWithoutExtension3 + fileExtension3;
}
else
{
strfile3 = imageshortimg.ImageUrl;
}
con.Open();
SqlCommand cmd = new SqlCommand("update tblplan_details set banner_heading1=@banner_heading1,banner_heading2=@banner_heading2,service_name=@service_name,plan_name=@plan_name,plan_content=@plan_content,plan_image=@plan_image,short_content=@short_content,short_image=@short_image,banner_image=@banner_image where plan_name=@plan_name", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@banner_image", strfile1);
cmd.Parameters.AddWithValue("@banner_heading1", txtbannerheading1.Text);
cmd.Parameters.AddWithValue("@banner_heading2", txtbannerheading2.Text);
cmd.Parameters.AddWithValue("@plan_name", ddlplanname.SelectedItem.Text);
cmd.Parameters.AddWithValue("@service_name", ddlservice.SelectedItem.Text);
cmd.Parameters.AddWithValue("@plan_content", Editor1.Content);
cmd.Parameters.AddWithValue("@short_content", Editor2.Content);
cmd.Parameters.AddWithValue("@plan_image", strfile2);
cmd.Parameters.AddWithValue("@short_image", strfile3);
//cmd.Parameters.AddWithValue("@var", "ins");
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Plan Details Updated Successfully');location.href='edit-plan-details.aspx'", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Some Error Occurred!!!');", true);
}
txtbannerheading1.Text = "";
txtbannerheading2.Text = "";
//ddlservice.SelectedItem.Text= "";
Editor1.Content = "";
Editor2.Content = "";
}
catch { }
finally { con.Close(); }
}
