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