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