public DataSet BindServices() { cls_DBConnection obj_DbConnection = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_DbConnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); DataTable dtbl = new System.Data.DataTable(); cmd.CommandText = "sp_get_front_services"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); return(ds); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }
public List <MainServices> GetMainServices() { SqlConnection con = new SqlConnection(); try { cls_DBConnection obj_DbConnection = new cls_DBConnection(); con = obj_DbConnection.getSqlConnection(); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_get_service_names"; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable dt = new DataTable(); da.Fill(dt); List <MainServices> list = dt.DataTableToList <MainServices>(); return(list); } catch { if (con.State == ConnectionState.Open) { con.Close(); } return(null); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
public void bindPage() { cls_DBConnection obj_sqlcon = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_sqlcon.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_get_service_names"; cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dtbl = new DataTable(); da.Fill(dtbl); ddlService_Name.DataSource = dtbl; ddlService_Name.DataTextField = "services_name"; ddlService_Name.DataValueField = "id"; ddlService_Name.DataBind(); ddlService_Name.Items.Insert(0, "Select Services"); if (con.State == ConnectionState.Closed) { con.Close(); } } catch (Exception ex) { throw ex; } }
public void fillpage() { int li_banner_id; Boolean lb_show; li_banner_id = Convert.ToInt32(Request.QueryString["key"]); cls_DBConnection obj_DbConnection = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_DbConnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_get_project_details"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)); cmd.Parameters["@id"].Value = li_banner_id; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { txtProjectName.Text = Convert.ToString(rdr["project_name"]); txtDescription.Text = Convert.ToString(rdr["project_desc"]); txtDate.Text = Convert.ToString(rdr["project_date"]); txtClient.Text = Convert.ToString(rdr["clinet"]); txtCat.Text = Convert.ToString(rdr["category"]); txtNetW.Text = Convert.ToString(rdr["net_worth"]); Image1.ImageUrl = "../images/project/" + Convert.ToString(rdr["img_url"]); FilenameLabel.Text = Convert.ToString(rdr["img_url"]); if (Convert.ToInt32(rdr["status"]) == 1) { chkStatus.Checked = true; } else { chkStatus.Checked = false; } } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }
public void pub_bind_grid() { int i = 0; cls_DBConnection obj_DbConnection = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_DbConnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); DataTable dtbl = new System.Data.DataTable(); cmd.CommandText = "sp_get_adminbannerlist"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; SqlDataReader rdr = cmd.ExecuteReader(); StringBuilder sb = new StringBuilder(); if (rdr.HasRows) { while (rdr.Read()) { i = i + 1; sb.Append(String.Format(@"<tr class=""odd gradeX"">")); sb.Append(String.Format(@"<td style=""text-align:left"">{0}</td>", i.ToString())); sb.Append(String.Format(@"<td style=""text-align:left"">{0}</td>", rdr["banner_name"].ToString())); //sb.Append(String.Format(@"<td style=""text-align:left"">{0}</td>", rdr["show"].ToString())); sb.Append(String.Format(@"<td class=""left""><img src=""../images/banners/{0}"" width=""200px"" height=""50px"" /></td>", rdr["img_url"].ToString())); //sb.Append(String.Format("<td class=""center""><span class=""tip"" ><a title=""Edit"" href=""itemedit.aspx?key={0}"" ><img src=""images/icon/icon_edit.png"" ></a></span><span class=""tip"" ><a id=""1"" href=""deletedata.aspx?methodname=deleteitem&key={0}"" onclick=""javascript:return confirm('Are you sure you want to delete?')"" name=""{1}"" title=""Delete"" ><img src=""images/icon/icon_delete.png"" ></a></span></td>", dr("item_id"), dr("title"))) sb.Append(String.Format(@"<td class=""center""><span class=""tip"" ><a title=""Edit"" href=""banneredit.aspx?key={0}"" ><img src=""images/icon/icon_edit.png"" ></a></span></td>", rdr["banner_id"])); sb.Append(String.Format(@"<td class=""center""><span class=""tip"" ><a id=""1"" href=""deletedata.aspx?methodname=deletebanner&key={0}"" onclick=""javascript:return confirm('Are you sure you want to delete?')"" name=""{1}"" title=""Delete"" ><img src=""images/icon/icon_delete.png"" ></a></span></td>", rdr["banner_id"], rdr["banner_name"])); sb.Append(String.Format("</tr>")); } } mTableRows = sb.ToString(); if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }
public void get_last_records() { cls_DBConnection obj_DbConnection = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_DbConnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); DataTable dtbl = new System.Data.DataTable(); cmd.CommandText = "sp_get_aboutus_details"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { txtTitle.Text = rdr["title"].ToString(); txtLeft.Text = rdr["title_left"].ToString(); txtDescription.Text = rdr["description"].ToString(); Image2.ImageUrl = "../images/about/" + Convert.ToString(rdr["image_url"]); hdfID.Value = Convert.ToString(rdr["ID"]); FilenameLabel.Text = Convert.ToString(rdr["image_url"]); if (Convert.ToInt32(rdr["status"]) == 1) { chkStatus.Checked = true; } else { chkStatus.Checked = false; } } } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }
public int pub_get_maxid() { Boolean show_flag; cls_DBConnection obj_dbconnection = new cls_DBConnection(); cls_GlobalFunctions obj_GlobalFunction = new cls_GlobalFunctions(); SqlConnection con = new SqlConnection(); con = obj_dbconnection.getSqlConnection(); int li_max_id = 0; try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "select isnull(MAX(id),0) as max_id from tbl_services"; SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { li_max_id = Convert.ToInt32(rdr["max_id"]); } } else { li_max_id = 0; } if (con.State == ConnectionState.Open) { con.Close(); } return(li_max_id + 1); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }
public void get_last_records() { cls_DBConnection obj_DbConnection = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_DbConnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); DataTable dtbl = new System.Data.DataTable(); cmd.CommandText = "sp_get_contact_adress_details"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { txtAddresss.Text = rdr["Address"].ToString(); txtEmail.Text = rdr["MailToFernando"].ToString(); txtContactNo.Text = rdr["CallHim"].ToString(); txtOpenoing_Hours.Text = rdr["Opening_hours"].ToString(); if (Convert.ToInt32(rdr["status"]) == 1) { chkStatus.Checked = true; } else { chkStatus.Checked = false; } } } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }
public Models.Services GetServiceDetailByServiceId(String id) { SqlConnection con = new SqlConnection(); try { cls_DBConnection obj_DbConnection = new cls_DBConnection(); con = obj_DbConnection.getSqlConnection(); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_get_services_details_by_service_id"; cmd.Connection = con; SqlParameter p_id = new SqlParameter("@id", id); cmd.Parameters.Add(p_id); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable dt = new DataTable(); da.Fill(dt); return(dt.DataTableToList <Models.Services>()[0]); } catch { if (con.State == ConnectionState.Open) { con.Close(); } return(null); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
protected void lnkbk_login_Click(object sender, EventArgs e) { int r = 0; string encrptkey; cls_DBConnection obj_SqlConn = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_SqlConn.getSqlConnection(); cls_GlobalFunctions obj_GlobalFunc = new cls_GlobalFunctions(); encrptkey = obj_GlobalFunc.EncryptPass(password.Text, "&%#@?,:*"); //encrptkey = password.Text; try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_user_login"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@arg_nm_user", SqlDbType.NVarChar, 200)); cmd.Parameters["@arg_nm_user"].Value = username_id.Text; cmd.Parameters.Add(new SqlParameter("@arg_pass", SqlDbType.NVarChar, 200)); cmd.Parameters["@arg_pass"].Value = encrptkey; SqlDataReader rdr = cmd.ExecuteReader(); if (rdr.HasRows) { r = 1; } else { lblmsg.Text = "Invalid user name or password"; } while (rdr.Read()) { /*if (Convert.ToInt32(rdr["admin_id"]) == 1) * { * r = 2; * Session["admin_id"] = Convert.ToInt32(rdr["admin_id"]); * //Session["admin_name"] = Convert.ToString(rdr["admin_user"]); * } * else * { * Session["admin_id"] = Convert.ToInt32(rdr["admin_id"]); * Session["admin_name"] = Convert.ToString(rdr["admin_user"]); * }*/ Session["admin_id"] = Convert.ToInt32(rdr["admin_id"]); Session["admin_name"] = Convert.ToString(rdr["admin_user"]); } if (r == 1) { Response.Redirect("Adminmain.aspx"); } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } // lblmsg.Text = ex.Message; } }
protected void btnadd_Click(object sender, EventArgs e) { string fileExt = ""; if (uFileImage.HasFile) { fileExt = System.IO.Path.GetExtension(uFileImage.FileName); if (fileExt.ToLower() == ".jpeg" || fileExt.ToLower() == ".jpg" || fileExt.ToLower() == ".png") { lblmsg.Visible = false; } else { lblmsg.Visible = true; lblmsg.Text = "Please Upload Valid File!"; return; } } int li_prod_id; li_prod_id = Convert.ToInt32(Request.QueryString["key"]); Boolean link; int show_flag = 0; string ls_image = ""; string img = uFileImage.PostedFile.FileName; cls_DBConnection obj_dbconnection = new cls_DBConnection(); cls_GlobalFunctions obj_GlobalFunction = new cls_GlobalFunctions(); SqlConnection con = new SqlConnection(); con = obj_dbconnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_update_project"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@project_name", SqlDbType.VarChar)); cmd.Parameters["@project_name"].Value = txtProjectName.Text; cmd.Parameters.Add(new SqlParameter("@project_desc", SqlDbType.NVarChar, 500)); cmd.Parameters["@project_desc"].Value = txtDescription.Text; DateTime date = DateTime.ParseExact(this.txtDate.Text, "dd/MM/yyyy", null); cmd.Parameters.Add(new SqlParameter("@project_date", SqlDbType.DateTime)); cmd.Parameters["@project_date"].Value = date; cmd.Parameters.Add(new SqlParameter("@clinet", SqlDbType.NVarChar, 500)); cmd.Parameters["@clinet"].Value = txtClient.Text; cmd.Parameters.Add(new SqlParameter("@category", SqlDbType.NVarChar, 500)); cmd.Parameters["@category"].Value = txtCat.Text; cmd.Parameters.Add(new SqlParameter("@net_worth", SqlDbType.NVarChar, 500)); cmd.Parameters["@net_worth"].Value = txtNetW.Text; if (img != "") { ls_image = li_prod_id.ToString() + "_" + uFileImage.FileName; } else { ls_image = FilenameLabel.Text; } cmd.Parameters.Add(new SqlParameter("@img_url", SqlDbType.NVarChar, 500)); cmd.Parameters["@img_url"].Value = ls_image; if (chkStatus.Checked) { show_flag = 1; } else { show_flag = 0; } cmd.Parameters.Add(new SqlParameter("@status", SqlDbType.Int)); cmd.Parameters["@status"].Value = show_flag; cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)); cmd.Parameters["@id"].Value = Convert.ToInt32(li_prod_id); cmd.ExecuteNonQuery(); if (img != "") { uFileImage.PostedFile.SaveAs(Server.MapPath("../images/project/") + ls_image); } if (con.State == ConnectionState.Open) { con.Close(); } Response.Redirect("projects.aspx?updatetype=2"); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } lblmsg.Text = ex.Message; } }
protected void btnadd_Click(object sender, EventArgs e) { string fileExt = ""; if (uFile.HasFile) { fileExt = System.IO.Path.GetExtension(uFile.FileName); if (fileExt.ToLower() == ".jpeg" || fileExt.ToLower() == ".jpg" || fileExt.ToLower() == ".png") { lblmsg.Visible = false; } else { lblmsg.Visible = true; lblmsg.Text = "Please Upload Valid File!"; return; } } string ls_image = ""; int show_flag = 0; string img = uFile.PostedFile.FileName; cls_DBConnection obj_dbconnection = new cls_DBConnection(); cls_GlobalFunctions obj_GlobalFunction = new cls_GlobalFunctions(); SqlConnection con = new SqlConnection(); con = obj_dbconnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_add_aboutus_details"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@title", SqlDbType.NVarChar, 500)); cmd.Parameters["@title"].Value = txtTitle.Text; cmd.Parameters.Add(new SqlParameter("@title_left", SqlDbType.NVarChar, 500)); cmd.Parameters["@title_left"].Value = txtLeft.Text; cmd.Parameters.Add(new SqlParameter("@description", SqlDbType.NVarChar, 500)); cmd.Parameters["@description"].Value = txtDescription.Text; if (chkStatus.Checked) { show_flag = 1; } else { show_flag = 0; } cmd.Parameters.Add(new SqlParameter("@status", SqlDbType.Int)); cmd.Parameters["@status"].Value = show_flag; if (img != "") { ls_image = uFile.FileName; } else { ls_image = FilenameLabel.Text; } cmd.Parameters.Add(new SqlParameter("@image_url", SqlDbType.NVarChar, 500)); cmd.Parameters["@image_url"].Value = ls_image; cmd.Parameters.Add(new SqlParameter("@created_by", SqlDbType.NVarChar, 500)); cmd.Parameters["@created_by"].Value = Session["admin_name"].ToString(); cmd.ExecuteNonQuery(); if (img != "") { uFile.PostedFile.SaveAs(Server.MapPath("../images/about/") + ls_image); } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true); if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } lblmsg.Text = ex.Message; } }
private void allbanner() { int i = 0; cls_DBConnection obj_DbConnection = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_DbConnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); DataTable dtbl = new System.Data.DataTable(); cmd.CommandText = "sp_get_bannerlist"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { var slideItem = ""; var indicatorData = ""; for (int j = 0; j < dt.Rows.Count; j++) { var className = ""; if (j == 0) { className = "active"; } indicatorData = indicatorData + "<li data-target='#myCarousel' data-slide-to='" + j + "' class='" + className + "'>" + "</li>"; var slideImage = ""; slideImage = dt.Rows[j]["img_url"].ToString(); slideItem = slideItem + "<div class='item " + className + "'>" + "<div class='fill'><img width='1920' height=' 730' src ='images/banners/" + slideImage + "' alt = 'image'></div>" + "<div class='pattern'></div>" + "<div class='carousel-caption'>" + "<h2><span>" + dt.Rows[j]["banner_title1"].ToString() + "</span> </h2>" + "<h1>" + dt.Rows[j]["banner_title2"].ToString() + "</h1>" + "</div>" + "</div>"; } indicators.InnerHtml = indicatorData; slides.InnerHtml = slideItem; } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }
protected void btnadd_Click(object sender, EventArgs e) { int show_flag = 0; cls_DBConnection obj_dbconnection = new cls_DBConnection(); cls_GlobalFunctions obj_GlobalFunction = new cls_GlobalFunctions(); SqlConnection con = new SqlConnection(); con = obj_dbconnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_add_contact_address_details"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 500)); cmd.Parameters["@Address"].Value = txtAddresss.Text; cmd.Parameters.Add(new SqlParameter("@MailToFernando", SqlDbType.NVarChar, 50)); cmd.Parameters["@MailToFernando"].Value = txtEmail.Text.Trim(); if (chkStatus.Checked) { show_flag = 1; } else { show_flag = 0; } cmd.Parameters.Add(new SqlParameter("@status", SqlDbType.Int)); cmd.Parameters["@status"].Value = show_flag; cmd.Parameters.Add(new SqlParameter("@CallHim", SqlDbType.NVarChar, 50)); cmd.Parameters["@CallHim"].Value = txtContactNo.Text; cmd.Parameters.Add(new SqlParameter("@Opening_hours", SqlDbType.NVarChar, 50)); cmd.Parameters["@Opening_hours"].Value = txtOpenoing_Hours.Text; cmd.Parameters.Add(new SqlParameter("@created_by", SqlDbType.NVarChar, 500)); cmd.Parameters["@created_by"].Value = Session["admin_name"].ToString(); cmd.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Saved Successfully')", true); if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } lblmsg.Text = ex.Message; } }
protected void btnadd_Click(object sender, EventArgs e) { string fileExt = ""; if (uFile.HasFile) { fileExt = System.IO.Path.GetExtension(uFile.FileName); if (fileExt.ToLower() == ".jpeg" || fileExt.ToLower() == ".jpg" || fileExt.ToLower() == ".png") { lblmsg.Visible = false; } else { lblmsg.Visible = true; lblmsg.Text = "Please Upload Valid File!"; return; } } Boolean link; int show_flag = 0; cls_DBConnection obj_dbconnection = new cls_DBConnection(); cls_GlobalFunctions obj_GlobalFunction = new cls_GlobalFunctions(); SqlConnection con = new SqlConnection(); con = obj_dbconnection.getSqlConnection(); int li_max_id = 0; string ls_image; li_max_id = pub_get_maxid(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_add_services"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@services_id", SqlDbType.Int)); cmd.Parameters["@services_id"].Value = ddlService_Name.SelectedValue; ls_image = li_max_id + "_" + uFile.FileName; cmd.Parameters.Add(new SqlParameter("@img_url", SqlDbType.NVarChar, 50)); cmd.Parameters["@img_url"].Value = ls_image; cmd.Parameters.Add(new SqlParameter("@services_description", SqlDbType.NVarChar, 500)); cmd.Parameters["@services_description"].Value = txtDescription.Text; if (chkStatus.Checked) { show_flag = 1; } else { show_flag = 0; } cmd.Parameters.Add(new SqlParameter("@status", SqlDbType.Int)); cmd.Parameters["@status"].Value = show_flag; cmd.ExecuteNonQuery(); uFile.PostedFile.SaveAs(Server.MapPath("../images/services/") + ls_image); if (con.State == ConnectionState.Open) { con.Close(); } Response.Redirect("servic.aspx?updatetype=1"); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } lblmsg.Text = ex.Message; } }
protected void btnadd_Click(object sender, EventArgs e) { string fileExt = ""; if (uFileImage.HasFile) { fileExt = System.IO.Path.GetExtension(uFileImage.FileName); if (fileExt.ToLower() == ".jpeg" || fileExt.ToLower() == ".jpg" || fileExt.ToLower() == ".png") { lblmsg.Visible = false; } else { lblmsg.Visible = true; lblmsg.Text = "Please Upload Valid File!"; return; } Bitmap img2 = new Bitmap(uFileImage.PostedFile.InputStream, false); int height = img2.Height; // get the height of image in pixel. int width = img2.Width; // get the width of image in pixel. int fileSize = (uFileImage.PostedFile.ContentLength) / 1024; //get the size of image file. if (height > 730 && width > 1920) { lblmsg.Visible = true; lblmsg.ForeColor = Color.Red; lblmsg.Text = "File size not be exceed than 1920 x 730 px"; return; } } int li_prod_id; li_prod_id = Convert.ToInt32(Request.QueryString["key"]); Boolean link; int show_flag = 0; string ls_image = ""; string img = uFileImage.PostedFile.FileName; cls_DBConnection obj_dbconnection = new cls_DBConnection(); cls_GlobalFunctions obj_GlobalFunction = new cls_GlobalFunctions(); SqlConnection con = new SqlConnection(); con = obj_dbconnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "sp_update_banners"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@arg_banner_name", SqlDbType.NVarChar, 50)); cmd.Parameters["@arg_banner_name"].Value = Txtname.Text; cmd.Parameters.Add(new SqlParameter("@banner_title1", SqlDbType.NVarChar, 50)); cmd.Parameters["@banner_title1"].Value = txtTitl1.Text; cmd.Parameters.Add(new SqlParameter("@banner_title2", SqlDbType.NVarChar, 50)); cmd.Parameters["@banner_title2"].Value = txtTitl2.Text; if (img != "") { ls_image = li_prod_id.ToString() + "_" + uFileImage.FileName; } else { ls_image = FilenameLabel.Text; } if (rbn_link_yes.Checked) { link = true; } else { link = false; } cmd.Parameters.Add(new SqlParameter("@arg_imgurl", SqlDbType.NVarChar, 500)); cmd.Parameters["@arg_imgurl"].Value = ls_image; if (chkStatus.Checked) { show_flag = 1; } else { show_flag = 0; } cmd.Parameters.Add(new SqlParameter("@arg_show", SqlDbType.Int)); cmd.Parameters["@arg_show"].Value = show_flag; cmd.Parameters.Add(new SqlParameter("@arg_position", SqlDbType.Int)); cmd.Parameters["@arg_position"].Value = Convert.ToInt32(Txtpostion.Text); cmd.Parameters.Add(new SqlParameter("@arg_url", SqlDbType.NVarChar, 500)); cmd.Parameters["@arg_url"].Value = txtlink.Text; cmd.Parameters.Add(new SqlParameter("@arg_link", SqlDbType.Bit)); cmd.Parameters["@arg_link"].Value = link; cmd.Parameters.Add(new SqlParameter("@arg_target", SqlDbType.Int)); cmd.Parameters["@arg_target"].Value = Convert.ToInt32(drdw_target.SelectedValue); cmd.Parameters.Add(new SqlParameter("@modified_by", SqlDbType.NVarChar, 500)); cmd.Parameters["@modified_by"].Value = Session["admin_name"].ToString(); cmd.Parameters.Add(new SqlParameter("@banner_id", SqlDbType.Int)); cmd.Parameters["@banner_id"].Value = Convert.ToInt32(li_prod_id); cmd.ExecuteNonQuery(); if (img != "") { uFileImage.PostedFile.SaveAs(Server.MapPath("../images/banners/") + ls_image); } if (con.State == ConnectionState.Open) { con.Close(); } Response.Redirect("banners.aspx"); } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } lblmsg.Text = ex.Message; } }
public void fillpage() { int li_banner_id; Boolean lb_show; li_banner_id = Convert.ToInt32(Request.QueryString["key"]); cls_DBConnection obj_DbConnection = new cls_DBConnection(); SqlConnection con = new SqlConnection(); con = obj_DbConnection.getSqlConnection(); try { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_get_banner_details"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@arg_banner_id", SqlDbType.Int)); cmd.Parameters["@arg_banner_id"].Value = li_banner_id; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Txtname.Text = Convert.ToString(rdr["banner_name"]); txtTitl1.Text = Convert.ToString(rdr["banner_title1"]); txtTitl2.Text = Convert.ToString(rdr["banner_title2"]); Image1.ImageUrl = "../images/banners/" + Convert.ToString(rdr["img_url"]); FilenameLabel.Text = Convert.ToString(rdr["img_url"]); if (Convert.ToInt32(rdr["show"]) == 1) { chkStatus.Checked = true; } else { chkStatus.Checked = false; } Txtpostion.Text = rdr["position"].ToString(); txtlink.Text = rdr["url"].ToString(); if (Convert.ToBoolean(rdr["link"]) == true) { rbn_link_yes.Checked = true; rbn_link_no.Checked = false; txtlink.Enabled = true; } else { rbn_link_no.Checked = true; rbn_link_yes.Checked = false; txtlink.Enabled = false; } drdw_target.SelectedValue = rdr["target"].ToString(); } if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { if (con.State == ConnectionState.Open) { con.Close(); } throw ex; } }