public static DataSet Category_Send_To_DB(Admin_Category objAdmin_Category)
{
try
{
SqlParameter[] objSqlParameter = new SqlParameter[6];
objSqlParameter[0] = new SqlParameter("@CategoryName", objAdmin_Category.CategoryName);
objSqlParameter[1] = new SqlParameter("@CategoryId", objAdmin_Category.CategoryId);
objSqlParameter[2] = new SqlParameter("@DumpCategoryName", objAdmin_Category.DumpCategoryName);
objSqlParameter[3] = new SqlParameter("@Isactive", objAdmin_Category.Isactive);
objSqlParameter[4] = new SqlParameter("@CreatedDate", objAdmin_Category.CreatedDate);
objSqlParameter[5] = new SqlParameter("@UserId", objAdmin_Category.UserId);
return(SqlHelper.ExecuteDataSet(con, CommandType.StoredProcedure, "Sp_Admin_Category", objSqlParameter));
}
catch (Exception Ex)
{
throw Ex;
}
}
public void Send_Category_Data(string Category_Name, int Category_Id, string DumpCategory_Name, bool Isactive)
{
try
{
if (Category_Name != "")
{
if (Session["UserCode"] != null)
{
Admin_Category objAdmin_Category = new Admin_Category();
objAdmin_Category.CategoryName = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(Category_Name.ToLower());
objAdmin_Category.CategoryId = Category_Id;
objAdmin_Category.DumpCategoryName = DumpCategory_Name;
objAdmin_Category.Isactive = Isactive;
objAdmin_Category.CreatedDate = DateTime.Now.AddHours(Connection.SetHours);
objAdmin_Category.UserId = Convert.ToInt32(Session["UserId"].ToString());
DataSet objDataSet = Admin_Category.Category_Send_To_DB(objAdmin_Category);
if (objDataSet.Tables[0].Rows[0][0].ToString() == "1")
{
if (Category_Id == 0)
{
ShowNotification("Category", "Inserted Successfully..", NotificationType.success);
txtCategory.Text = "";
Categorys_List(gvCategory, "select Category_Id,Category_Name,Isactive from tbl_Admin_Category Order by Category_Name");
}
else
{
ShowNotification("Category", "Updated Successfully..", NotificationType.success);
Categorys_List(gvCategory, "select Category_Id,Category_Name,Isactive from tbl_Admin_Category Order by Category_Name");
}
}
else if (objDataSet.Tables[0].Rows[0][0].ToString() == "-5")
{
ShowNotification("Category", "Category Already Existed..!", NotificationType.error);
if (Category_Id == 0)
{
txtCategory.Focus();
}
else
{
txtUpdateCategory.Focus();
}
}
else
{
ShowNotification("Category", "Not inserted..!", NotificationType.error);
}
}
else
{
ShowNotification("Category", "Sorry, Your Session had been Expired.. So Please Logout Once & Login Again..!", NotificationType.error);
}
}
else
{
ShowNotification("Category", "Please fill all Fields..!", NotificationType.error);
}
}
catch (Exception Ex)
{
}
}
/// <summary>
/// Sync actions with Permission object
/// </summary>
public static void SyncPermissionWithAction()
{
Type permission = typeof(Permission);
FieldInfo[] fields = permission.GetFields();
if (fields == null || fields.Length <= 0)
{
return;
}
KuanMaiEntities db = new KuanMaiEntities();
try
{
List <AdminActionAttribute> cates = new List <AdminActionAttribute>();
List <Admin_Action> allActions = (from action in db.Admin_Action select action).ToList <Admin_Action>();
List <Admin_Category> allCates = (from cate in db.Admin_Category select cate).ToList <Admin_Category>();
foreach (FieldInfo field in fields)
{
AdminActionAttribute attr = field.GetCustomAttribute <AdminActionAttribute>();
Admin_Action action = (from a in allActions where a.action_name == field.Name select a).FirstOrDefault <Admin_Action>();
if (action == null)
{
action = new Admin_Action();
action.action_name = field.Name;
action.enable = true;
db.Admin_Action.Add(action);
}
if (attr != null)
{
action.category_id = attr.ID;
action.action_description = attr.ActionDescription;
AdminActionAttribute existed = (from pcate in cates where pcate.ID == attr.ID select pcate).FirstOrDefault <AdminActionAttribute>();
if (existed == null)
{
cates.Add(attr);
}
}
}
db.SaveChanges();
foreach (Admin_Action action in allActions)
{
bool found = false;
foreach (FieldInfo field in fields)
{
if (action.action_name == field.Name)
{
found = true;
break;
}
}
if (!found)
{
action.enable = false;
//db.Admin_Action.Remove(action);
}
}
db.SaveChanges();
//category
foreach (AdminActionAttribute pcate in cates)
{
Admin_Category dbCate = (from c in allCates where c.ID == pcate.ID select c).FirstOrDefault <Admin_Category>();
if (dbCate == null)
{
dbCate = new Admin_Category();
dbCate.ID = pcate.ID;
dbCate.Name = pcate.CategoryName;
dbCate.System_category = pcate.IsSystem;
dbCate.Created = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now);
db.Admin_Category.Add(dbCate);
}
}
db.SaveChanges();
}
catch (Exception ex)
{
}
finally
{
db.Dispose();
}
}
