private void ChnagePass(string Newpass, string oldPass) { try { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); DataTable dataTable = ObjDAL.ExecuteSelectStatement("SELECT ID,CAST(AES_DECRYPT(Password, 'UserNameEmailID') AS CHAR(255)) Pass FROM ztech.tblUserDetails;"); if (dataTable != null && dataTable.Rows.Count > 0) { string strOldPass = dataTable.Rows[0]["Pass"].ToString(); int pID = Convert.ToInt32(dataTable.Rows[0]["ID"]); if (oldPass == strOldPass) { ObjDAL.ExecuteNonQuery("UPDATE ztech.tblUserDetails SET Password=AES_ENCRYPT('" + Newpass + "', 'UserNameEmailID'),UpdatedOn=NOW(),UpdatedBy=" + pID + " WHERE 1=1;"); NavigationURL.Value = "MyProfile.aspx"; ShowMessageBox("Password has been update successfully."); } else { NavigationURL.Value = "MyProfile.aspx"; ShowMessageBox("Old password doesn't match with existing old password.", false); } } } catch (Exception ex) { NavigationURL.Value = "MyProfile.aspx"; ShowMessageBox(ex.Message, false); } }
private void LoadEmail() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); DataTable dataTable = ObjDAL.ExecuteSelectStatement("SELECT EmailID FROM ztech.tblUserDetails;"); if (dataTable != null && dataTable.Rows.Count > 0) { txtemail.Value = dataTable.Rows[0]["EmailID"].ToString(); } }
private void SaveDataIntoDB(string strName, string path, int flag) { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); ObjDAL.SetStoreProcedureData("ParmPID", MySql.Data.MySqlClient.MySqlDbType.Int32, ProductID); ObjDAL.SetStoreProcedureData("ParmPath ", MySql.Data.MySqlClient.MySqlDbType.VarChar, path); ObjDAL.SetStoreProcedureData("ParmFileName ", MySql.Data.MySqlClient.MySqlDbType.VarChar, strName); ObjDAL.SetStoreProcedureData("ParmFlag", MySql.Data.MySqlClient.MySqlDbType.Int32, flag); ObjDAL.ExecuteStoreProcedure_DML("spr_InsertProductImages"); }
private void LoadImages() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); DataTable dtProductImages = ObjDAL.ExecuteSelectStatement("select * from ztech.tblImages where ProductID=" + ProductID); if (dtProductImages != null && dtProductImages.Rows.Count > 0) { Repeater2.DataSource = dtProductImages; Repeater2.DataBind(); } }
private void LoadCarouselRepeater() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); // dont write db_name.dbo.viewname, it doesn't work in my sq. 1 is hardcode for gate which is fixed DataTable dtProduct = ObjDAL.ExecuteSelectStatement("SELECT Path FROM ztech.tblImages WHERE ProductID=4 AND flag=0"); if (dtProduct != null && dtProduct.Rows.Count > 0) { CarouselRepeater.DataSource = dtProduct; CarouselRepeater.DataBind(); } }
private void LoadProductDetails() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); DataTable dtProductDetails = ObjDAL.ExecuteSelectStatement("SELECT * FROM View_ProductDetails WHERE ProductID=" + ProductID); if (dtProductDetails != null && dtProductDetails.Rows.Count > 0) { ProductID = dtProductDetails.Rows[0]["ProductID"].ToString(); Description = dtProductDetails.Rows[0]["Description"].ToString(); ConstFeatures = dtProductDetails.Rows[0]["ConstFeatures"].ToString(); ProductName = dtProductDetails.Rows[0]["ProductName"].ToString(); SizeDetails = dtProductDetails.Rows[0]["SizeDetails"].ToString(); } }
private void LoadCarouselRepeater() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); // dont write db_name.dbo.viewname, hardcode for gate which is fixed DataTable dtProduct = ObjDAL.ExecuteSelectStatement("select * from View_MainSliderDetails"); if (dtProduct.Rows.Count > 0) { CarouselRepeater.DataSource = dtProduct; CarouselRepeater.DataBind(); } }
private void ChagngeEmail(string mail) { int pID = 0; if (Session["User"] != null) { pID = Convert.ToInt32(Session["User"]); clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); ObjDAL.ExecuteNonQuery("UPDATE ztech.tblUserDetails SET EmailID='" + mail + "',UpdatedOn=NOW(),UpdatedBy=" + pID + " WHERE 1=1;"); ShowMessageBox("Email has been update successfully."); } else { ShowMessageBox("Unable to Update Email Address."); } NavigationURL.Value = "MyProfile.aspx"; }
private void UpdateProductData() { ProductName = Request["txtProductName"].ToString(); string strProdDesc = Request["txtProdDesc"].ToString(); string strConsFeature = Request["txtConsFeature"].ToString(); string strSizeDetails = Request["txtSizeDetails"].ToString(); string strProductName = ""; int ProductID = 0; if (Session["ProductName"] != null) { strProductName = Session["ProductName"].ToString(); } else { strProductName = "NA"; } if (Session["ProductID"] != null) { ProductID = Convert.ToInt32(Session["ProductID"]); } clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); ObjDAL.SetStoreProcedureData("ProductName", MySql.Data.MySqlClient.MySqlDbType.VarChar, ProductName); ObjDAL.SetStoreProcedureData("PID", MySql.Data.MySqlClient.MySqlDbType.Int32, ProductID); ObjDAL.SetStoreProcedureData("Description", MySql.Data.MySqlClient.MySqlDbType.LongText, strProdDesc); ObjDAL.SetStoreProcedureData("ConstFeatures", MySql.Data.MySqlClient.MySqlDbType.LongText, strConsFeature); ObjDAL.SetStoreProcedureData("SizeDetails", MySql.Data.MySqlClient.MySqlDbType.LongText, strSizeDetails); bool result = ObjDAL.ExecuteStoreProcedure_DML("spr_InsUpdateProductDetails"); if (!result) { Response.Write(ObjDAL.strErrorText); } else { Session["UpdateStatus"] = "1"; Response.Redirect("Admin_Manager.aspx"); } }
//[System.Web.Services.WebMethod] //private string ForgotPass(string mail) private void ForgotPass(string mail) { string result = ""; try { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); string strpass = string.Empty; DataTable dt = ObjDAL.ExecuteSelectStatement("SELECT Password FROM ztech.tblUserDetails WHERE EmailID='" + mail + "';"); if (dt != null && dt.Rows.Count > 0) { strpass = dt.Rows[0]["Password"].ToString(); bool b = SendEmail(mail, strpass); NavigationURL.Value = "Admin_Login.aspx"; if (b) { ShowMessageBox("Password has been sent to your mail address."); //result = "Password has been sent to your mail address."; } else { ShowMessageBox("Unable to Send Password to your mail address.", false); //result = "Unable to Send Password to your mail address."; } } else { NavigationURL.Value = "Admin_Login.aspx"; ShowMessageBox("Unable to Send Password to your mail address.", false); //result = "Unable to Send Password to your mail address."; } //return result; } catch (Exception ex) { NavigationURL.Value = "Admin_Login.aspx"; ShowMessageBox(ex.ToString(), false); } }
private void LoadData() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); // dont write db_name.dbo.viewname, it doesn't work in my sq. 4 is hardcode for ball valve which is fixed DataTable dtProduct = ObjDAL.ExecuteSelectStatement("SELECT ProductName,ConstFeatures,SizeDetails FROM ztech.View_ProductDetails WHERE ProductID=4"); if (dtProduct != null && dtProduct.Rows.Count > 0) { string[] constFeature = dtProduct.Rows[0]["ConstFeatures"].ToString().Split('\n'); string[] sizeDetails = dtProduct.Rows[0]["SizeDetails"].ToString().Split('\n'); ProductName = dtProduct.Rows[0]["ProductName"].ToString(); Repeater1.DataSource = constFeature; Repeater1.DataBind(); Repeater2.DataSource = sizeDetails; Repeater2.DataBind(); } }
private void DeleteImage(string imgID, string ImageName) { try { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); ObjDAL.ExecuteNonQuery("DELETE FROM ztech.tblImages WHERE ImageID=" + imgID); if (File.Exists(Server.MapPath("~/Uploads/" + ImageName))) { File.Delete(Server.MapPath("~/Uploads/" + ImageName)); } NavigationURL.Value = "UpdateProductImage.aspx"; ShowMessageBox("Image has been deleted successfully."); } catch (Exception ex) { NavigationURL.Value = "UpdateProductImage.aspx"; ShowMessageBox(ex.Message, false); } }
private void LoadProdcuts() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); DataTable dtProducts = ObjDAL.ExecuteSelectStatement("SELECT ProductID,ProductName FROM ztech.tblProductMaster"); if (dtProducts != null && dtProducts.Rows.Count > 0) { cmbProduct.DataSource = dtProducts; cmbProduct.DataBind(); cmbProduct.DataTextField = "ProductName"; cmbProduct.DataValueField = "ProductID"; cmbProduct.DataBind(); //Add a default item at first position. cmbProduct.Items.Insert(0, new ListItem("Please select", "")); //Set the default item as selected. cmbProduct.Items[0].Selected = true; //Disable the default item. cmbProduct.Items[0].Attributes["disabled"] = "disabled"; } }