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