public string InsertCompanyModules(int companyid) { C3Entities context = new C3Entities(); int moduleid = 0; int[] menus = { 0 }; string m = ""; int i = 0; var query = from t in context.Modules where (t.ParentID!=0 && t.RelativePath == null) orderby t.ModuleID ascending select t.ModuleID; if (query.Count() > 0) { menus = new int[query.Count()]; foreach (var q in query) { moduleid = q; m += q + ","; menus[i] = q; i++; } } foreach(int j in menus) { var companymodules = new CompanyModule { CompanyID=companyid, ModuleID = j, IsDeleted=false, CreatedTime = DateTime.Now, ModifiedTime = DateTime.Now }; context.CompanyModules.Add(companymodules); context.SaveChanges(); } return m; }
protected void Page_Load(object sender, EventArgs e) { //Int32 companyid = Convert.ToInt32(HttpContext.Current.Session["CompanyID"]); C3Entities context = new C3Entities(); ACLRoleBL aclRoleBL = new ACLRoleBL(); int roleid = aclRoleBL.InsertRole("csd", "csd"); Response.Write("roleid is " + roleid); //int moduleid = 0; //int functionid = 0; //int[] menus = { 0 }; //int[] functions = { 0 }; //int i = 0; //int j = 0; //var query = from t in context.CompanyModules // where (t.CompanyID == companyid) // orderby t.ModuleID ascending // select t.ModuleID; //if (query.Count() > 0) //{ // menus = new int[query.Count()]; // foreach (var q in query) // { // moduleid = q; // // Response.Write("module id is: " + q + "<hr>"); // menus[i] = q; // i++; // } //} //var query1 = from t in context.ACLFunctions // orderby t.FunctionOrder ascending // select t.FunctionID; //if (query1.Count() > 0) //{ // functions = new int[query1.Count()]; // foreach (var q1 in query1) // { // functionid = q1; // // Response.Write("function id is: " + q1 + "<hr>"); // functions[j] = q1; // j++; // } //} //foreach (int x in menus) //{ // foreach (int y in functions) // { // Response.Write("menu id are: " + x + "function id" + y + "<hr>"); // var aclaction = new ACLAction { ModuleID = x, FunctionID = y, Access = true, RoleID=4, CreatedTime = DateTime.Now }; // context.ACLActions.Add(aclaction); // context.SaveChanges(); // } //} }
public void InsertACLAction(int roleid,int companyid) { //var acs = false; //if (access == "1") // acs = true; //if (access == "0") // acs = false; //var aclaction = new ACLAction //{ // ModuleID = moduleId, // FunctionID = functionId, // CreatedTime = DateTime.Now, // Access = acs, // RoleID = roleid //}; //context.ACLActions.Add(aclaction); //SaveChanges(); if (companyid == 0) { companyid = Convert.ToInt32(HttpContext.Current.Session["CompanyID"]); } C3Entities context = new C3Entities(); int moduleid = 0; int functionid = 0; int[] menus = { 0 }; int[] functions = { 0 }; int i = 0; int j = 0; var query = from t in context.CompanyModules where (t.CompanyID == companyid) orderby t.ModuleID ascending select t.ModuleID; if (query.Count() > 0) { menus = new int[query.Count()]; foreach (var q in query) { moduleid = q; menus[i] = q; i++; } } var query1 = from t in context.ACLFunctions orderby t.FunctionOrder ascending select t.FunctionID; if (query1.Count() > 0) { functions = new int[query1.Count()]; foreach (var q1 in query1) { functionid = q1; functions[j] = q1; j++; } } foreach (int x in menus) { foreach (int y in functions) { var aclaction = new ACLAction { ModuleID = x, FunctionID = y, Access = true, RoleID = roleid, CreatedTime = DateTime.Now }; context.ACLActions.Add(aclaction); context.SaveChanges(); //SaveChanges(); } } }