//Select All Brand public List <Ent_Brand> SelectBrandList(int brandId) { List <Ent_Brand> result = new List <Ent_Brand>(); Ent_Brand ent = new Ent_Brand(); try { using (SqlCommand cmd = new SqlCommand("EC_Selectbrand", con)) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Brand_ID", brandId)); IDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ent = new Ent_Brand(); ent.Brand_ID = Convert.ToInt32(dr["Brand_ID"]); ent.Brand_Name = Convert.ToString(dr["Brand_Name"]); result.Add(ent); } } } catch (Exception ex) { InsertException(ex.Message, "SelectCategoryList", brandId); } finally { con.Close(); } return(result); }
public int DeleteBrand(int Brand_ID) { Ent_Brand ent = new Ent_Brand(); ent.Brand_ID = Brand_ID; //HttpCookie UserID = Request.Cookies["User_ID"]; //var UserId = UserID != null ? UserID.Value.Split('=')[1] : ""; //ent.Modified_By = Convert.ToInt32(UserId); ent.Modified_By = 1; DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); ent.Modified_Date = indiTime; SafeTransaction trans = new SafeTransaction(); int i = balMaster.DeleteBrand(ent, trans); if (i > 0) { trans.Commit(); } else { trans.Rollback(); } return(i); }
public int DeleteBrand(Ent_Brand ent, SafeTransaction trans) { int dataResult; try { Dal_Master dal = new Dal_Master(); dataResult = dal.DeleteBrand(ent, trans); return(dataResult); } catch { return(-1); } }
public int SaveBrand(Ent_Brand entGuest, SafeTransaction trans) { int dataResult = 0; try { Dal_Master dal = new Dal_Master(); dataResult = dal.SaveBrand(entGuest, trans); return(dataResult); } catch { return(0); } }
// GET: Category public int SaveBrand(Ent_Brand model) { SafeTransaction trans = new SafeTransaction(); DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE); DateTime indiTime = Convert.ToDateTime(indianTime.ToString("yyyy-MM-dd h:m:s")); model.Created_Date = indiTime; HttpCookie C_UserID = Request.Cookies["User_ID"]; string User_ID = C_UserID != null?C_UserID.Value.Split('=')[1] : ""; model.Created_By = Convert.ToInt32(User_ID); int i = balMaster.SaveBrand(model, trans); if (i > 0) { trans.Commit(); } else { trans.Rollback(); } return(i); }
public int DeleteBrand(Ent_Brand ent, SafeTransaction trans) { int dataResult = 0; int dataresult1 = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("EC_DeleteBrand", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Brand_ID", ent.Brand_ID)); cmd.Parameters.Add(new SqlParameter("@Modified_By", ent.Modified_By)); cmd.Parameters.Add(new SqlParameter("@Modified_Date", ent.Modified_Date)); try { dataResult = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); } catch (Exception e) { InsertException(e.Message, "DeleteBrand", ent.Brand_ID); dataResult = -1; } } if (dataResult > 0) { using (SqlCommand cmd = new SqlCommand("EC_InsertLog", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Modified_By)); cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Modified_Date)); cmd.Parameters.Add(new SqlParameter("@Primary_Id", ent.Brand_ID)); cmd.Parameters.Add(new SqlParameter("@Log_Action", "Delete Brand")); cmd.Parameters.Add(new SqlParameter("@Log_Status", "Admin")); try { dataresult1 = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult1 > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult1 = -2; } } } } catch (Exception) { dataResult = -1; } finally { con.Close(); } return(dataResult); }
public int SaveBrand(Ent_Brand ent, SafeTransaction trans) { int dataresult = 0; int dataresult1 = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } //Insert To category Main Table using (SqlCommand cmd = new SqlCommand("EC_InsertBrand", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Brand_ID", ent.Brand_ID)); cmd.Parameters.Add(new SqlParameter("@Brand_Name", ent.Brand_Name)); cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date)); cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Created_By)); try { dataresult = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult > 0) { cmd.Dispose(); } } catch (Exception ex) { //General gl = new General(); //gl.UpdateErrorLog(Ex, "CreateDietPlan"); dataresult = -2; InsertException(ex.Message, "SaveBrand", ent.Brand_ID); } } if (dataresult > 0) { using (SqlCommand cmd = new SqlCommand("EC_InsertLog", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Created_By", ent.Created_By)); cmd.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date)); cmd.Parameters.Add(new SqlParameter("@Primary_Id", dataresult)); if (ent.Brand_ID > 0) { cmd.Parameters.Add(new SqlParameter("@Log_Action", "Update Brand")); } else { cmd.Parameters.Add(new SqlParameter("@Log_Action", "Insert Brand")); } cmd.Parameters.Add(new SqlParameter("@Log_Status", "Admin")); try { dataresult1 = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult1 > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult1 = -2; } } } } catch (Exception ex) { dataresult1 = -2; } finally { con.Close(); } return(dataresult); }