public void SetDefaultSiteByForUser(string userId, int siteId) { using (var db = new PCVEntities()) { //return query.ToList(); var userSite = db.UserSite.AsNoTracking().Where(m => m.UserId == userId).ToList(); if (userSite.IsNotBlank()) { foreach (var item in userSite) { if (item.SiteId == siteId) { item.IsDefaultSite = true; } else { item.IsDefaultSite = false; } item.UpdatedDate = DateTime.Now; item.UpdatedBy = MySession.Current.UserName; db.Entry(item).State = EntityState.Modified; } db.SaveChanges(); } } }
public void UpdateSiteStatusById(long site) { using (var db = new PCVEntities()) { var data = db.PC_Tool_Site.Where(m => m.ID == site).FirstOrDefault(); data.InActive = data.InActive == true ? false : true; data.updated_date = DateTime.Now; data.updated_by = MySession.Current.UserName; db.Entry(data).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateRegionStatusById(long regionId) { using (var db = new PCVEntities()) { var data = db.Region.Where(m => m.Id == regionId).FirstOrDefault(); data.InActive = data.InActive == true ? false : true; data.UpdatedDate = DateTime.Now; data.UpdatedBy = MySession.Current.UserName; db.Entry(data).State = EntityState.Modified; db.SaveChanges(); } }
public long CreateUpdateSite(SiteModel model) { using (var db = new PCVEntities()) { if (model != null) { var myModel = new PC_Tool_Site(); myModel.ConnString = model.ConnString; myModel.Site_name = model.Site_name; myModel.Area_name = model.Area_name; myModel.RegionID = model.RegionID; myModel.Database_ID = model.Database_ID; myModel.Database_Name = model.Database_Name; myModel.Database_PW = model.Database_PW; if (model.IsDefaultSite) { myModel.Default_Site = "Y"; } else { myModel.Default_Site = "N"; } myModel.Server_IP = model.Server_IP; myModel.SiteUrl = model.SiteUrl; myModel.InActive = model.InActive; if (model.ID > 0) { myModel.ID = model.ID; myModel.updated_date = DateTime.Now; myModel.updated_by = MySession.Current.UserName; db.Entry(myModel).State = EntityState.Modified; } else { myModel.CreatedDate = DateTime.Now; myModel.CreatedBy = MySession.Current.UserName; db.PC_Tool_Site.Add(myModel); } db.SaveChanges(); if (myModel.ID > 0) { return(myModel.ID); } else { return(0); } } return(0); } }
public long CreateUpdateMenu(MenuModel model) { using (var db = new PCVEntities()) { if (model != null) { var myModel = new Menu(); myModel.MenuName = model.MenuName; myModel.MenuType = model.MenuType; myModel.Description = model.Description; if (model.ParentId.IsNotBlank()) { myModel.ParentId = model.ParentId; } else { myModel.ParentId = 0; } myModel.Url = model.Url; myModel.Tooltip = model.Tooltip; myModel.InActive = model.InActive; myModel.Priority = model.Priority; if (model.Id > 0) { myModel.Id = model.Id.To <long>(); myModel.UpdatedDate = DateTime.Now; myModel.UpdatedBy = MySession.Current.UserName; db.Entry(myModel).State = EntityState.Modified; } else { myModel.CreatedDate = DateTime.Now; myModel.CreatedBy = MySession.Current.UserName; db.Menu.Add(myModel); } db.SaveChanges(); if (myModel.Id > 0) { return(myModel.Id); } else { return(0); } } return(0); } }
public long CreateUpdateUserSite(UserSiteModel model) { using (var db = new PCVEntities()) { if (model != null) { var myModel = new UserSite(); myModel.SiteId = model.SiteId; myModel.UserId = model.UserId; myModel.RoleId = model.RoleId; myModel.InActive = model.InActive; if (model.Id > 0) { myModel.Id = model.Id.To <long>(); myModel.UpdatedDate = DateTime.Now; myModel.UpdatedBy = MySession.Current.UserName; db.Entry(myModel).State = EntityState.Modified; } else { myModel.CreatedDate = DateTime.Now; myModel.CreatedBy = MySession.Current.UserName; db.UserSite.Add(myModel); } db.SaveChanges(); if (myModel.Id > 0) { return(myModel.Id); } else { return(0); } } return(0); } }
public long CreateUpdateRegion(RegionModel model) { using (var db = new PCVEntities()) { if (model != null) { var myModel = new Region(); myModel.RegionName = model.RegionName; myModel.RegionCode = model.RegionCode; myModel.Description = model.Description; myModel.InActive = model.InActive; if (model.Id > 0) { myModel.Id = model.Id.To <long>(); myModel.UpdatedDate = DateTime.Now; myModel.UpdatedBy = MySession.Current.UserName; db.Entry(myModel).State = EntityState.Modified; } else { myModel.CreatedDate = DateTime.Now; myModel.CreatedBy = MySession.Current.UserName; db.Region.Add(myModel); } db.SaveChanges(); if (myModel.Id > 0) { return(myModel.Id); } else { return(0); } } return(0); } }