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