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");
}
public async Task <IHttpActionResult> PutClassDate(int id, ClassDate classDate)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != classDate.Id)
{
return(BadRequest());
}
db.Entry(classDate).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ClassDateExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
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(); }
}
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 async Task <IHttpActionResult> GetClassDate(int id)
{
ClassDate classDate = await db.ClassDates.FindAsync(id);
if (classDate == null)
{
return(NotFound());
}
return(Ok(classDate));
}
public ActionResult Edit([Bind(Include = "ClassDateID,StoreClassID,DateTime,ClassLimit")] ClassDate classDate)
{
if (ModelState.IsValid)
{
db.Entry(classDate).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StoreClassID = new SelectList(db.StoreClasses, "StoreClassID", "ClassName", classDate.StoreClassID);
return(View(classDate));
}
//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(); }
}
public async Task <IHttpActionResult> PostClassDate(ClassDate classDate)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ClassDates.Add(classDate);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = classDate.Id }, classDate));
}
public ActionResult Create([Bind(Include = "ClassDateID,StoreClassID,DateTime,ClassLimit")] ClassDate classDate)
{
if (ModelState.IsValid)
{
db.ClassDates.Add(classDate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StoreClassID = new SelectList(db.StoreClasses, "StoreClassID", "ClassName", classDate.StoreClassID);
return(View(classDate));
}
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";
}
}
}
public async Task <IHttpActionResult> DeleteClassDate(int id)
{
ClassDate classDate = await db.ClassDates.FindAsync(id);
if (classDate == null)
{
return(NotFound());
}
db.ClassDates.Remove(classDate);
await db.SaveChangesAsync();
return(Ok(classDate));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClassDate classDate = db.ClassDates.Find(id);
if (classDate == null)
{
return(HttpNotFound());
}
return(View(classDate));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ClassDate classDate = db.ClassDates.Find(id);
if (classDate == null)
{
return(HttpNotFound());
}
ViewBag.StoreClassID = new SelectList(db.StoreClasses, "StoreClassID", "ClassName", classDate.StoreClassID);
return(View(classDate));
}
public ActionResult DeleteConfirmed(int id)
{
ClassDate classDate = db.ClassDates.Find(id);
var hasSignUps = db.ClassSignUps.FirstOrDefault(x => x.ClassDateID == id);
string classDateName = db.ClassDates.FirstOrDefault(x => x.ClassDateID == id).NameDate;
if (hasSignUps != null)
{
ViewBag.ErrorMessageDelete = classDateName + "currently has lesson views and you cannot remove it.";
return(View(classDate));
}
db.ClassDates.Remove(classDate);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool SetDidClassMeet(int ClassID, DateTime ClassDate, string DidClassMeet)
{
ClassDate meet = dbConn.ClassDates.FirstOrDefault(m => m.ClassID == ClassID && m.Class_Date == ClassDate);
if (meet != null && DidClassMeet != null &&
(DidClassMeet == "Y" || DidClassMeet == "N"))
{
meet.DidClassMeet = DidClassMeet;
dbConn.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public ActionResult Create(string start, string end, string text)
{
var toBeCreated = new ClassDate();
toBeCreated.StartDate = Convert.ToDateTime(start);
toBeCreated.EndDate = Convert.ToDateTime(end);
toBeCreated.Title = text;
toBeCreated.isActive = true;
db.ClassDates.Add(toBeCreated);
db.SaveChanges();
return(new JsonResult {
Data = new Dictionary <string, object> {
{ "id", toBeCreated.Id }
}
});
}
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 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 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 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(); }
}
