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;
}
}
