//Select BY Category Id public Ent_Category SelectCategory(int categoryId, string condition) { Ent_Category result = new Ent_Category(); Ent_Category ent = new Ent_Category(); try { using (SqlCommand cmd = new SqlCommand("EC_SelectCategory", con)) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Category_ID", categoryId)); cmd.Parameters.Add(new SqlParameter("@condition", condition)); IDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ent.Category_ID = Convert.ToInt32(dr["Category_ID"]); ent.Category_Name = Convert.ToString(dr["Category_Name"]); } } } catch (Exception ex) { InsertException(ex.Message, "SelectCategoryList", categoryId); } finally { con.Close(); } return(ent); }
// GET: Category public int SaveCategory(Ent_Category 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 = balCategory.SaveCategory(model, trans); if (i > 0) { trans.Commit(); } else { trans.Rollback(); } return(i); }
public int DeleteCategory(int Category_ID) { Ent_Category ent = new Ent_Category(); ent.Category_ID = Category_ID; HttpCookie UserID = Request.Cookies["User_ID"]; var UserId = UserID != null?UserID.Value.Split('=')[1] : ""; ent.Modified_By = Convert.ToInt32(UserId); 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 = balCategory.DeleteCategory(ent, trans); if (i > 0) { trans.Commit(); } else { trans.Rollback(); } return(i); }
public int DeleteCategory(Ent_Category ent, SafeTransaction trans) { int dataResult; try { Dal_Category dal = new Dal_Category(); dataResult = dal.DeleteCategory(ent, trans); return(dataResult); } catch { return(-1); } }
//Select By Category ID public Ent_Category SelectCategory(int categoryId, string condition) { Ent_Category result = new Ent_Category(); try { Dal_Category dal = new Dal_Category(); result = dal.SelectCategory(categoryId, condition); return(result); } catch { return(result); } }
public int SaveCategory(Ent_Category entGuest, SafeTransaction trans) { int dataResult = 0; try { Dal_Category dal = new Dal_Category(); dataResult = dal.SaveCategory(entGuest, trans); return(dataResult); } catch { return(0); } }
//Category public ActionResult AddCategory() { int CategoryId = Request.QueryString["CategoryId"] != null?Convert.ToInt32(Request.QueryString["CategoryId"]) : 0; List <Ent_SubCategory> listSubCategory = new List <Ent_SubCategory>(); Ent_Category ent = new Ent_Category(); if (CategoryId != 0) { ent = balCategory.SelectCategory(CategoryId, ""); if (ent != null) { listSubCategory = balCategory.SelectSubCategoryList(CategoryId); } } ViewBag.listSubCategory = listSubCategory; return(View(ent)); }
public int DeleteCategory(Ent_Category ent, SafeTransaction trans) { int dataResult = 0; int dataresult1 = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlCommand cmd = new SqlCommand("EC_DeleteCategory", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Category_ID", ent.Category_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, "DeleteCategory", ent.Category_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.Category_ID)); cmd.Parameters.Add(new SqlParameter("@Log_Action", "Delete Category ")); 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 SaveCategory(Ent_Category ent, SafeTransaction trans) { int dataresult = 0; int dataresult1 = 0; int dataresult2 = 0; try { if (con.State == ConnectionState.Closed) { con.Open(); } //Insert To category Main Table using (SqlCommand cmd = new SqlCommand("EC_InsertCategory", trans.DatabaseConnection, trans.Transaction)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Category_ID", ent.Category_ID)); cmd.Parameters.Add(new SqlParameter("@Category_Name", ent.Category_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, "SaveCategory", ent.Category_ID); } } //Insert To Sub Category Table if (dataresult > 0) { var query = "update EC_Category set Is_Active=0 where Parent_Category=" + dataresult; int k = 0; using (SqlCommand cmd2 = new SqlCommand(query, trans.DatabaseConnection, trans.Transaction)) { k = cmd2.ExecuteNonQuery(); } if (ent.SubCategoryList != null) { for (int i = 0; i < ent.SubCategoryList.Count; i++) { using (SqlCommand cmd1 = new SqlCommand("EC_InsertSubCategory", trans.DatabaseConnection, trans.Transaction)) { cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.Add(new SqlParameter("@Category_ID", ent.SubCategoryList[i].Category_ID)); cmd1.Parameters.Add(new SqlParameter("@Category_Name", ent.SubCategoryList[i].Category_Name)); cmd1.Parameters.Add(new SqlParameter("@Parent_Category", dataresult)); cmd1.Parameters.Add(new SqlParameter("@Created_Date", ent.Created_Date)); cmd1.Parameters.Add(new SqlParameter("@Created_By", ent.Created_By)); try { dataresult1 = Convert.ToInt32(cmd1.ExecuteScalar()); cmd1.Dispose(); } catch (Exception ex) { //General gl = new General(); //gl.UpdateErrorLog(Ex, "CreateDietPlan"); dataresult1 = -1; InsertException(ex.Message, "SaveSubCategory", ent.Category_ID); } } } } else { dataresult1 = 1; } } if (dataresult1 > 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.Category_ID > 0) { cmd.Parameters.Add(new SqlParameter("@Log_Action", "Update Category")); } else { cmd.Parameters.Add(new SqlParameter("@Log_Action", "Insert Category")); } cmd.Parameters.Add(new SqlParameter("@Log_Status", "Admin")); try { dataresult2 = Convert.ToInt32(cmd.ExecuteScalar()); if (dataresult2 > 0) { cmd.Dispose(); } } catch (Exception ex) { dataresult2 = -2; } } } } catch (Exception ex) { dataresult2 = -2; } finally { con.Close(); } if (dataresult1 <= 0) { dataresult = -1; } return(dataresult); }