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