private void SetVicePresidentByCompany(Project proj, SqlConnection sqlc, IUserService _userService, IMfUserGroupService _mfusergroupService, long companyid) { try { var select1 = string.Format("select userid,groupid from usergroup where id = '{0}' ", companyid); var sqlcommand1 = new SqlCommand(select1, sqlc); var rds1 = new SqlDataAdapter(sqlcommand1); var dt1 = new DataTable(); rds1.Fill(dt1); if (dt1.Rows.Count > 0) { foreach (DataRow row in dt1.Rows) { var index = 0; var userg = new UserGroupDb(); foreach (DataColumn column in dt1.Columns) { switch (index) { case 0: userg.UserId = int.Parse(row[column].ToString()); break; case 1: userg.GroupId = int.Parse(row[column].ToString()); break; } index++; } var username = _userService.GetUserById(userg.UserId).UserName; string mfigroupid = GetMfGroupName(userg.GroupId); _mfusergroupService.AddUserToGroup(proj.Vault, username, mfigroupid); } } } catch (Exception ex) { // Log.Info(companyid + "SetVicePresidentByCompany error:" + ex.Message); } }
//[HttpPost] //public ActionResult ChangePassword(ChangePasswordViewModel model) //{ // SimpleLog("in post changepassword"); // SimpleLog("in post changepassword"+model.OldPassword); // SimpleLog("in post changepassword" + model.NewPassword); // SimpleLog("in post changepassword" + model.ConfirmPassword); // try // { // var userid = User.Identity.GetUserName(); // SimpleLog("in post 11"); // var pass = DBWorldCache.Get(User.Identity.GetUserId()); // SimpleLog("in post 22"); // var vs = _mfvaultServerService.GetServer(); // SimpleLog("in post 33"); // var app = MFServerUtility.ConnectToServer(userid, pass, vs.Ip, vs.Port); // SimpleLog("in post 44"); // app.LoginAccountOperations.UpdateLoginPassword(userid, model.NewPassword); // SimpleLog("in post 55"); // } // catch (Exception ex) // { // return View(model); // } // return RedirectToAction("Welcome", "Manage"); //} //[HttpPost] //public async Task<ActionResult> CheckProjectCreationPermission(int userid) //{ // var res = await Task.Run(() => ProjectCreationPermission(userid)); // if (!String.IsNullOrEmpty(res)) // { // return Content(res); // } // return Content("success"); //} //private string ProjectCreationPermission(int userid) //{ // var connstr = ConfigurationManager.ConnectionStrings["AecCloudObjects"].ConnectionString; // var ret = string.Empty; // var sqlc = new SqlConnection(connstr); // sqlc.Open(); // try // { // var select = string.Format("select id from erppm where userid ={0} ", userid); // var sqlcommand = new SqlCommand(select, sqlc); // var rds = new SqlDataAdapter(sqlcommand); // var dt = new DataTable(); // rds.Fill(dt); // if (dt.Rows.Count <1) // { // ret = string.Format("您没有创建项目的权限,请联系公司总部工程管理部ERP立项信息负责人! "); // } // } // catch (Exception ex) // { // Log.Info(string.Format("ProjectCreationPermission {0} ", ex.Message)); // ret = ex.Message; // } // sqlc.Close(); // return ret; //} public ActionResult GetDbUserGroup(string code) { var connstr = ConfigurationManager.ConnectionStrings["AecCloudObjects"].ConnectionString; Log.Info("--" + connstr); var sqlc = new SqlConnection(connstr); Log.Info("333"); sqlc.Open(); var ugs = new List <UserGroupDb>(); try { var companyid = int.Parse(GetCompanyId(sqlc, code)); Log.Info("555"); var select = string.Format("select * from usergroup where companyid = '{0}' ", companyid); var sqlcommand = new SqlCommand(select, sqlc); var rds = new SqlDataAdapter(sqlcommand); var dt = new DataTable(); rds.Fill(dt); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { var index = 0; var userg = new UserGroupDb(); foreach (DataColumn column in dt.Columns) { switch (index) { case 0: userg.Id = int.Parse(row[column].ToString()); break; case 1: userg.CompanyId = int.Parse(row[column].ToString()); break; case 2: userg.UserId = int.Parse(row[column].ToString()); break; case 3: userg.GroupId = int.Parse(row[column].ToString()); break; } index++; } userg.GroupName = GetUgName(sqlc, userg.GroupId); userg.Dbusers = GetUsersForUg(sqlc, code); ugs.Add(userg); } } else { Log.Info(select + "GetDbUserGroup there is no usegroup for --" + companyid); } } catch (Exception ex) { Log.Info(string.Format("ConCompanyUg {0} ", ex.Message)); } sqlc.Close(); // return Json(ugs,JsonRequestBehavior.AllowGet); var json = JsonConvert.SerializeObject(ugs, new JsonSerializerSettings { NullValueHandling = NullValueHandling.Ignore, Formatting = Newtonsoft.Json.Formatting.None }); return(Content(json)); }
public ActionResult PermissionManagement() { var companies = _projService.GetAllCompany(); var clist = new List <CompanyManager>(); var connstr = ConfigurationManager.ConnectionStrings["AecCloudObjects"].ConnectionString; var sqlc = new SqlConnection(connstr); sqlc.Open(); try { foreach (Company company in companies) { var select = string.Format("select * from usergroup where companyid = '{0}' ", company.Id); var sqlcommand = new SqlCommand(select, sqlc); var rds = new SqlDataAdapter(sqlcommand); var dt = new DataTable(); rds.Fill(dt); var cm = new CompanyManager { Code = company.Code, Id = company.Id, Name = company.Name }; if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { var index = 0; var userg = new UserGroupDb(); foreach (DataColumn column in dt.Columns) { switch (index) { case 0: userg.Id = int.Parse(row[column].ToString()); break; case 1: userg.CompanyId = int.Parse(row[column].ToString()); break; case 2: userg.UserId = int.Parse(row[column].ToString()); break; case 3: userg.GroupId = int.Parse(row[column].ToString()); break; } index++; } cm.UserGroups.Add(userg); } } clist.Add(cm); } } catch (Exception ex) { Log.Info("PermissionManagement error:" + connstr + ex.Message); } sqlc.Close(); return(View(clist)); }
public static void Main(string[] args) { var userGroupDb = new UserGroupDb("test"); Console.WriteLine("Works : {0}", userGroupDb); }