private static void CreateHostRoleUser(MasterDbContext context)
{
//管理员角色
var adminRole = context.Role.IgnoreQueryFilters().FirstOrDefault(r => r.TenantId == null && r.Name == StaticRoleNames.Host.Admin);
if (adminRole == null)
{
adminRole = context.Role.Add(new Role(null, StaticRoleNames.Host.Admin, StaticRoleNames.Host.Admin)
{
IsStatic = true
}).Entity;
context.SaveChanges();
}
// 使管理员有所有权限
var grantedPermissions = context.Permission.IgnoreQueryFilters()
.OfType <RolePermissionSetting>()
.Where(p => p.TenantId == null && p.RoleId == adminRole.Id)
.Select(p => p.Name)
.ToList();
using (var provider = IocManager.Instance.ResolveAsDisposable <IPermissionManager>())
{
var permissions = provider.Object.GetAllPermissions(MultiTenancySides.Host);
permissions = permissions.Where(p => !grantedPermissions.Contains(p.Name)).ToList();
if (permissions.Any())
{
context.Permission.AddRange(
permissions.Select(permission => new RolePermissionSetting
{
TenantId = null,
Name = permission.Name,
IsGranted = true,
RoleId = adminRole.Id
})
);
context.SaveChanges();
}
}
//管理用户
var adminUser = context.User.IgnoreQueryFilters().FirstOrDefault(u => u.TenantId == null && u.UserName == User.AdminUserName);
if (adminUser == null)
{
adminUser = User.CreateHostAdminUser();
context.User.Add(adminUser);
context.SaveChanges();
// Assign Admin role to admin user
context.UserRole.Add(new UserRole(null, adminUser.Id, adminRole.Id));
context.SaveChanges();
}
}
protected void saveBill_onclick(object sender, EventArgs e)
{
using (MasterDbContext db = new MasterDbContext())
{
// change quantity bill
int id_bill = Convert.ToInt32(billID_hint.Value);
Bill changeBill = db.Bills.Find(id_bill);
double totalQuantity = Convert.ToDouble(getQuantity("SELECT sum(Quantity) FROM Items WHERE CONVERT(DATE, CreatedTime) = CONVERT(DATE, GETDATE()) AND BillID =" + id_bill));
decimal totalPrice = Convert.ToDecimal(getQuantity("SELECT sum(fl.Price*item.Quantity) FROM Items item, Flowers fl WHERE CONVERT(DATE, item.CreatedTime) = CONVERT(DATE, GETDATE()) AND item.FlowerID = fl.ID AND item.BillID =" + id_bill));
changeBill.Quantity += totalQuantity;
changeBill.Price += totalPrice;
db.Entry(changeBill).State = EntityState.Modified;
db.SaveChanges();
////data of revenue
/// query
///
var nowDate = DateTime.Now;
IQueryable <Revenue> qr = db.Revenues.AsNoTracking();
qr = qr.Where(x => x.CreatedTime <= nowDate && x.CreatedTime >= nowDate.Date);
// get
decimal quantityDateTypeBuy = Convert.ToDecimal(getQuantity("SELECT ISNULL(Sum(Price), 0) FROM Bills WHERE CONVERT(DATE, CreatedTime) = CONVERT(DATE, GETDATE()) AND Type = 0"));
decimal quantityDateTypeSale = Convert.ToDecimal(getQuantity("SELECT ISNULL(Sum(Price), 0) FROM Bills WHERE CONVERT(DATE, CreatedTime) = CONVERT(DATE, GETDATE()) AND Type = 1"));
if (qr.Count() <= 0)
{
Revenue revenue = new Revenue();
revenue.TotalBuy = quantityDateTypeBuy;
revenue.TotalSale = quantityDateTypeSale;
revenue.QuantityOfDate = quantityDateTypeSale - quantityDateTypeBuy;
db.Revenues.Add(revenue);
}
else
{
Revenue revenue = qr.FirstOrDefault();
revenue.TotalBuy = quantityDateTypeBuy;
revenue.TotalSale = quantityDateTypeSale;
revenue.QuantityOfDate = quantityDateTypeSale - quantityDateTypeBuy;
// set update
db.Entry(revenue).State = EntityState.Modified;
}
db.SaveChanges();
Response.Redirect("~/Bill/ListBill.aspx");
}
}
private void CreateEditions()
{
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition == null)
{
defaultEdition = new Edition {
Name = EditionManager.DefaultEditionName, DisplayName = EditionManager.DefaultEditionName
};
_context.Editions.Add(defaultEdition);
_context.SaveChanges();
/* Add desired features to the standard edition, if wanted... */
}
}
public bool AddCustomer(CustomerVM custVM)
{
try
{
MasterDbContext db = new MasterDbContext();
Customer l_oCust = new Customer();
//l_oCust.groupI = model.groupId;
//l_oCust.cust_gstin=model
//db.users.Add(l_oUser);
//db.SaveChanges();
l_oCust.cust_name = custVM.cust_name;
l_oCust.cust_uid_type = custVM.cust_uid_type;
l_oCust.cust_uid = custVM.cust_uid;
l_oCust.cust_dob = custVM.cust_dob;
l_oCust.remarks = custVM.remarks;
l_oCust.cust_gstin = custVM.firstfield + custVM.secondField + custVM.thirdfield;
db.customers.Add(l_oCust);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
#pragma warning disable CS1998 // Async method lacks 'await' operators and will run synchronously
/// <summary>
/// Add all of the pre-defined data into the <see cref="MasterDbContext"/>
/// </summary>
public async Task Seed()
#pragma warning restore CS1998 // Async method lacks 'await' operators and will run synchronously
{
_context.Persons.AddRange(PreDefinedData.Persons);
_context.Births.AddRange(PreDefinedData.Births);
_context.ReferenceAccessionSources.AddRange(PreDefinedData.ReferenceAccessionSources);
_context.ReferenceBasesForUsCitizenship.AddRange(PreDefinedData.ReferenceBasesForUsCitizenship);
_context.ReferenceBloodTypes.AddRange(PreDefinedData.ReferenceBloodTypes);
_context.ReferenceCountries.AddRange(PreDefinedData.ReferenceCountries);
_context.ReferenceEthnicGroups.AddRange(PreDefinedData.ReferenceEthnicGroups);
_context.ReferenceEyeColors.AddRange(PreDefinedData.ReferenceEyeColors);
_context.ReferenceGenders.AddRange(PreDefinedData.ReferenceGenders);
_context.ReferenceHairColors.AddRange(PreDefinedData.ReferenceHairColors);
_context.ReferenceMarriages.AddRange(PreDefinedData.ReferenceMarriages);
_context.ReferenceMilSvcCitizenshipQuals.AddRange(PreDefinedData.ReferenceMilSvcCitizenshipQuals);
_context.ReferenceNameSuffixes.AddRange(PreDefinedData.ReferenceNameSuffixes);
_context.ReferencePayPlans.AddRange(PreDefinedData.ReferencePayPlans);
_context.ReferencePersonnelClasses.AddRange(PreDefinedData.ReferencePersonnelClasses);
_context.ReferenceRaces.AddRange(PreDefinedData.ReferenceRaces);
_context.ReferenceReligions.AddRange(PreDefinedData.ReferenceReligions);
_context.ReferenceServiceBranches.AddRange(PreDefinedData.ReferenceServiceBranches);
_context.ReferenceServiceBranchComponents.AddRange(PreDefinedData.ReferenceServiceBranchComponents);
_context.ReferenceSsnVerifications.AddRange(PreDefinedData.ReferenceSsnVerifications);
_context.ReferenceStateProvinces.AddRange(PreDefinedData.ReferenceStateProvinces);
_context.SaveChanges();
}
public ActionResult AddUser(UserVM model)
{
MasterDbContext db = new MasterDbContext();
if (!ModelState.IsValid)
{
return(View(model));
}
user l_oUser = new user();
l_oUser.groupId = model.groupId;
l_oUser.id = model.id;
l_oUser.isActive = model.isActive;
l_oUser.userName = model.userName;
l_oUser.userPass = ComputeSHA(model.userPass);
l_oUser.loginId = model.loginId;
db.users.Add(l_oUser);
db.SaveChanges();
TempData["SM"] = "User successfully added!";
return(Redirect("UsersList"));
//return View();
}
public int Delete(int ID)
{
try
{
using (MasterDbContext db = new MasterDbContext())
{
var item = db.Categories.Find(ID);
if (item == null)
{
return(-1);
}
item.Activate = false;
db.SaveChanges();
return(ID);
}
}
catch
{
}
return(-1);
}
protected void writeBill(object sender, EventArgs e)
{
if (lb_staff.Text == "")
{
lb_staff.Text = staffList.SelectedItem.ToString();
lb_transaction.Text = transaction_type.SelectedItem.ToString();
using (MasterDbContext db = new MasterDbContext())
{
try
{
var bill = new Bill();
string timeCreate = bill.saveBill(Convert.ToInt32(staffList.SelectedValue), Convert.ToInt32(transaction_type.SelectedValue));
db.Bills.Add(bill);
db.SaveChanges();
double billId = GetBillID(timeCreate);
billID_hint.Value = billId.ToString();
int id_bill = Convert.ToInt32(billID_hint.Value);
var item = new Item();
item.BillID = id_bill;
item.Quantity = Convert.ToInt32(quantity.Text);
item.FlowerID = Convert.ToInt32(flowerList.SelectedValue);
db.Items.Add(item);
db.SaveChanges();
load_data();
}
catch { }
}
}
else
{
try
{
using (MasterDbContext db = new MasterDbContext())
{
int id_bill = Convert.ToInt32(billID_hint.Value);
var item = new Item();
item.BillID = id_bill;
item.Quantity = Convert.ToInt32(quantity.Text);
item.FlowerID = Convert.ToInt32(flowerList.SelectedValue);
db.Items.Add(item);
db.SaveChanges();
load_data();
}
}
catch { }
}
}
public void Create()
{
new DefaultEditionCreator(_context).Create();
new DefaultLanguagesCreator(_context).Create();
new HostRoleAndUserCreator(_context).Create();
new DefaultSettingsCreator(_context).Create();
_context.SaveChanges();
}
// POST api/personne
public Vehicule Post([FromBody] Vehicule value)
{
using (var context = new MasterDbContext())
{
context.Vehicules.Add(value);
context.SaveChanges();
return(value);
}
}
public static bool SynchronizationMethod(INode node, MasterDbContext masterDbContext, Server.ServerDbContext serverDbContext)
{
var oldNodeGroupLinks = masterDbContext.SymNodeGroupLink.Select(x => x).ToDictionary(x => string.Format("[{0}][{1}]", x.SourceNodeGroupId, x.TargetNodeGroupId), x => x);
var newNodeGroupLinks = new Dictionary <string, char>();
var newNodeGroupLinkDatas = serverDbContext.Router.Include("SourceNodeGroup").Include("TargetNode.NodeGroup").Where(x => x.ProjectId == node.ProjectId).ToList();
foreach (var data in newNodeGroupLinkDatas)
{
newNodeGroupLinks.Add(string.Format("[{0}][{1}]", data.SourceNodeGroup.NodeGroupId, data.TargetNode.NodeGroup.NodeGroupId), 'P');
newNodeGroupLinks.Add(string.Format("[{0}][{1}]", data.TargetNode.NodeGroup.NodeGroupId, data.SourceNodeGroup.NodeGroupId), 'W');
}
foreach (var nodeGroupLink in newNodeGroupLinks)
{
if (!oldNodeGroupLinks.ContainsKey(nodeGroupLink.Key))
{
var values = nodeGroupLink.Key.Split(new char[] { '[', ']' }, StringSplitOptions.RemoveEmptyEntries);
// 新增
masterDbContext.SymNodeGroupLink.Add(new SymNodeGroupLink
{
SourceNodeGroupId = values[0],
TargetNodeGroupId = values[1],
DataEventAction = nodeGroupLink.Value
});
}
else
{
// 修改
var oldNodeGroupLink = oldNodeGroupLinks[nodeGroupLink.Key];
oldNodeGroupLink.DataEventAction = nodeGroupLink.Value;
}
}
foreach (var nodeGroupLink in oldNodeGroupLinks)
{
if (!newNodeGroupLinks.ContainsKey(nodeGroupLink.Key))
{
// 刪除
masterDbContext.SymNodeGroupLink.Remove(nodeGroupLink.Value);
}
}
bool result = false;
try
{
masterDbContext.SaveChanges();
result = true;
}
catch (Exception e)
{
LogException(nameof(SynchronizationMethod), e);
}
return(result);
}
public static bool Router(MasterDbContext masterDbContext, Server.ServerDbContext serverDbContext)
{
var oldRouters = masterDbContext.SymRouter.Select(x => x).ToDictionary(x => x.RouterId, x => x);
var newRouters = serverDbContext.Router.Include("SourceNodeGroup").Include("TargetNode.NodeGroup").Select(x => x).ToDictionary(x => x.RouterId, x => x);
DateTime dateTimeNow = DateTime.Now;
foreach (var router in newRouters)
{
if (!oldRouters.ContainsKey(router.Key))
{
// 新增
masterDbContext.SymRouter.Add(new SymRouter
{
RouterId = router.Value.RouterId,
SourceNodeGroupId = router.Value.SourceNodeGroup.NodeGroupId,
TargetNodeGroupId = router.Value.TargetNode.NodeGroup.NodeGroupId,
RouterType = "default",
CreateTime = dateTimeNow,
LastUpdateTime = dateTimeNow
});
}
else
{
// 修改
var oldRouter = oldRouters[router.Key];
oldRouter.SourceNodeGroupId = router.Value.SourceNodeGroup.NodeGroupId;
oldRouter.TargetNodeGroupId = router.Value.TargetNode.NodeGroup.NodeGroupId;
oldRouter.CreateTime = dateTimeNow;
oldRouter.LastUpdateTime = dateTimeNow;
}
}
foreach (var router in oldRouters)
{
if (!newRouters.ContainsKey(router.Key))
{
// 刪除
masterDbContext.SymRouter.Remove(router.Value);
}
}
bool result = false;
try
{
masterDbContext.SaveChanges();
result = true;
}
catch (Exception e)
{
LogException(nameof(Router), e);
}
return(result);
}
private void AddSettingIfNotExists(string name, string value, int?tenantId = null)
{
if (_context.Settings.IgnoreQueryFilters().Any(s => s.Name == name && s.TenantId == tenantId && s.UserId == null))
{
return;
}
_context.Settings.Add(new Setting(tenantId, null, name, value));
_context.SaveChanges();
}
private void AddLanguageIfNotExists(ApplicationLanguage language)
{
if (_context.Languages.IgnoreQueryFilters().Any(l => l.TenantId == language.TenantId && l.Name == language.Name))
{
return;
}
_context.Languages.Add(language);
_context.SaveChanges();
}
public static bool Channel(MasterDbContext masterDbContext, Server.ServerDbContext serverDbContext)
{
var oldChannels = masterDbContext.SymChannel.Select(x => x).ToDictionary(x => x.ChannelId, x => x);
var newChannels = serverDbContext.Channel.Select(x => x).ToDictionary(x => x.ChannelId, x => x);
foreach (var channel in newChannels)
{
if (!oldChannels.ContainsKey(channel.Key))
{
// 新增
masterDbContext.SymChannel.Add(new SymChannel
{
ChannelId = channel.Value.ChannelId,
ProcessingOrder = 1,
MaxBatchSize = 100000,
Enabled = 1,
Description = channel.Value.Description
});
}
else
{
// 修改
var oldChannel = oldChannels[channel.Key];
oldChannel.Description = channel.Value.Description;
}
}
foreach (var channel in oldChannels)
{
if (new string[] { "config", "reload", "monitor", "heartbeat", "default", "dynamic" }.Contains(channel.Key))
{
continue;
}
if (!newChannels.ContainsKey(channel.Key))
{
// 刪除
masterDbContext.SymChannel.Remove(channel.Value);
}
}
bool result = false;
try
{
masterDbContext.SaveChanges();
result = true;
}
catch (Exception e)
{
LogException(nameof(Channel), e);
}
return(result);
}
protected void btnSaveClick(object sender, EventArgs e)
{
using (MasterDbContext db = new MasterDbContext())
{
if (Request.QueryString["ID"] != null && string.IsNullOrEmpty(Request.QueryString["ID"].ToString()) == false)
{
// edit
var id = Convert.ToInt32(Request.QueryString["ID"].ToString());
var item = db.Positions.Find(id);
if (item != null)
{
// set data
item.Value = txtName.Text;
item.UpdatedTime = DateTime.Now;
// save
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
Response.Redirect("~/Positions/ListPosition.aspx");
}
else
{
Response.Redirect("~/Positions/ListPosition.aspx");
}
}
else
{
var pos = new Web.Model.Position();
pos.Value = txtName.Text;
pos.Active = true;
// save
db.Positions.Add(pos);
db.SaveChanges();
Response.Redirect("~/Positions/ListPosition.aspx");
}
}
}
public void ChangeEntityVersion(Guid muuid)
{
using (var db = new MasterDbContext())
{
Master master = (from m in db.Master
where m.Uuid == MySQLByteArray(muuid) && m.Source == XMLSource.PLANNING.ToString()
select m).FirstOrDefault();
master.EntityVersion++;
Console.WriteLine("Entity Version: " + master.EntityVersion);
db.SaveChanges();
}
}
private static void CreateTenantOrganization(MasterDbContext context, int tenantId)
{
//根组织
if (context.Organization.Count() == 0)
{
context.Organization.Add(new Organization("系统管理")
{
Code = "00001", TenantId = tenantId
});
context.SaveChanges();
}
}
public ActionResult DeleteUser(int id)
{
using (MasterDbContext db = new MasterDbContext())
{
user l_oUser = db.users.Find(id);
db.users.Remove(l_oUser);
db.SaveChanges();
}
return(RedirectToAction("UsersList"));
}
public static bool Relationship(MasterDbContext masterDbContext, Server.ServerDbContext serverDbContext)
{
var oldTriggerRouters = masterDbContext.SymTriggerRouter.Select(x => x).ToDictionary(x => string.Format("[{0}][{1}]", x.TriggerId, x.RouterId), x => x);
var newTriggerRouters = serverDbContext.TriggerRouter.Include("Trigger").Include("Router").Select(x => x).ToDictionary(x => string.Format("[{0}][{1}]", x.Trigger.TriggerId, x.Router.RouterId), x => x);
DateTime dateTimeNow = DateTime.Now;
foreach (var triggerRouter in newTriggerRouters)
{
if (!oldTriggerRouters.ContainsKey(triggerRouter.Key))
{
// 新增
masterDbContext.SymTriggerRouter.Add(new SymTriggerRouter
{
TriggerId = triggerRouter.Value.Trigger.TriggerId,
RouterId = triggerRouter.Value.Router.RouterId,
InitialLoadOrder = 200,
LastUpdateTime = dateTimeNow,
CreateTime = dateTimeNow
});
}
else
{
// 修改
var oldTriggerRouter = oldTriggerRouters[triggerRouter.Key];
oldTriggerRouter.LastUpdateTime = dateTimeNow;
oldTriggerRouter.CreateTime = dateTimeNow;
}
}
foreach (var triggerRouter in oldTriggerRouters)
{
if (!newTriggerRouters.ContainsKey(triggerRouter.Key))
{
// 刪除
masterDbContext.SymTriggerRouter.Remove(triggerRouter.Value);
}
}
bool result = false;
try
{
masterDbContext.SaveChanges();
result = true;
}
catch (Exception e)
{
LogException(nameof(Relationship), e);
}
return(result);
}
public int AddOrUpdate(Post post)
{
if (Validate(post))
{
using (MasterDbContext db = new MasterDbContext())
{
if (post.ID > 0)
{
db.Entry(post).State = EntityState.Modified;
db.SaveChanges();
}
else
{
// add
post.CreatedDate = DateTime.Now;
var imgs = post.Images;
post.Images = null;
db.Posts.Add(post);
db.SaveChanges();
if (post.ID > 0)
{
foreach (var img in imgs)
{
img.PostID = post.ID;
db.Images.Add(img);
}
db.SaveChanges();
}
}
return(post.ID);
}
}
return(-1);
}
public int ActivatePost(int postID)
{
using (MasterDbContext db = new MasterDbContext())
{
var post = db.Posts.Find(postID);
post.Activate = true;
post.CreatedDate = DateTime.Now;
db.Entry(post).State = EntityState.Modified;
db.SaveChanges();
return(post.ID);
}
}
public string Put()
{
MasterDbContext masterDbContext = new MasterDbContext(connString);
DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>();
try
{
string reqType = this.ReadQueryStringData("reqType");
int empId = ToInt(this.ReadQueryStringData("empId"));
var files = Request.Form.Files;
string ImagePath = null;
string ImageName = null;
if (files.Count != 0)
{
//
DanpheHTTPResponse <object> uploadResponse = FileUploader.Upload(files, "UserProfile\\");
if (uploadResponse.Status == "OK")
{
ImagePath = uploadResponse.Results.ToString();
ImageName = files[0].FileName;
EmployeeModel dbemp = masterDbContext.Employees.Where(a => a.EmployeeId == empId)
.FirstOrDefault <EmployeeModel>();
dbemp.ImageFullPath = ImagePath;
dbemp.ImageName = ImageName;
masterDbContext.Entry(dbemp).State = EntityState.Modified;
responseData.Status = "OK";
masterDbContext.SaveChanges();
responseData.Results = ImageName;
}
else
{
throw new Exception("Upload Failed");
}
}
else
{
responseData.ErrorMessage = "Upload Failed";
responseData.Status = "Failed";
}
}
catch (Exception ex)
{
responseData.Status = "Failed";
responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString();
}
return(DanpheJSONConvert.SerializeObject(responseData, true));
}
public virtual void Add(TEntity entity, bool saveNow = true)
{
Assert.NotNull(entity, nameof(entity));
Entities.Add(entity);
if (saveNow)
{
MasterDbContext.SaveChanges();
}
}
public int AddComment(Comment cmt)
{
if (cmt != null && cmt.Name.Length > 0 && cmt.Message.Length > 0 && cmt.PostID > 0)
{
using (MasterDbContext db = new MasterDbContext())
{
db.Comments.Add(cmt);
db.SaveChanges();
return(cmt.ID);
}
}
return(-1);
}
public static bool NodeGroups(INode node, MasterDbContext masterDbContext, Server.ServerDbContext serverDbContext)
{
var oldNodeGroups = masterDbContext.SymNodeGroup.Select(x => x).ToDictionary(x => x.NodeGroupId, x => x);
var newNodeGroups = serverDbContext.NodeGroup.Where(ng => ng.ProjectId == node.ProjectId).ToDictionary(x => x.NodeGroupId, x => x);
foreach (var nodeGroup in newNodeGroups)
{
if (!oldNodeGroups.ContainsKey(nodeGroup.Key))
{
// 新增
masterDbContext.SymNodeGroup.Add(new SymNodeGroup
{
NodeGroupId = nodeGroup.Value.NodeGroupId,
Description = nodeGroup.Value.Description
});
}
else
{
// 修改
var oldNodeGroup = oldNodeGroups[nodeGroup.Key];
oldNodeGroup.Description = nodeGroup.Value.Description;
}
}
foreach (var nodeGroup in oldNodeGroups)
{
if (!newNodeGroups.ContainsKey(nodeGroup.Key))
{
// 刪除
masterDbContext.SymNodeGroup.Remove(nodeGroup.Value);
}
}
bool result = false;
try
{
masterDbContext.SaveChanges();
result = true;
}
catch (Exception e)
{
LogException(nameof(NodeGroups), e);
}
return(result);
}
public void CreateEntity(Guid muuid, string id, string entityType)
{
using (var db = new MasterDbContext())
{
ASCIIEncoding enc = new ASCIIEncoding();
Console.WriteLine(muuid.ToString());
Master master = new Master();
master.Uuid = MySQLByteArray(muuid);
master.SourceEntityId = id;
master.EntityType = entityType.ToString();
master.EntityVersion = 1;
master.Source = "PLANNING";
db.Master.Add(master);
db.SaveChanges();
}
}
private static void CreateDefaultTenant(MasterDbContext context)
{
var defaultTenant = context.Set <Tenant>().IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == Tenant.DefaultTenantName);
if (defaultTenant == null)
{
defaultTenant = new Tenant(Tenant.DefaultTenantName, Tenant.DefaultTenantName);
//defaultTenant.ConnectionString = SimpleStringCipher.Instance.Encrypt("Server=localhost; Database=MasterDb_Tenant_"+AbpTenantBase.DefaultTenantName+"; User Id=skynetsoft;password=skynetsoft");
//var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
//if (defaultEdition != null)
//{
// defaultTenant.EditionId = defaultEdition.Id;
//}
context.Set <Tenant>().Add(defaultTenant);
context.SaveChanges();
}
}
private void CreateDefaultTenant()
{
// Default tenant
var defaultTenant = _context.Tenants.IgnoreQueryFilters().FirstOrDefault(t => t.TenancyName == AbpTenantBase.DefaultTenantName);
if (defaultTenant == null)
{
defaultTenant = new Tenant(AbpTenantBase.DefaultTenantName, AbpTenantBase.DefaultTenantName);
var defaultEdition = _context.Editions.IgnoreQueryFilters().FirstOrDefault(e => e.Name == EditionManager.DefaultEditionName);
if (defaultEdition != null)
{
defaultTenant.EditionId = defaultEdition.Id;
}
_context.Tenants.Add(defaultTenant);
_context.SaveChanges();
}
}
public ActionResult EditUser(UserVM model)
{
using (MasterDbContext db = new MasterDbContext())
{
Int64 id = model.id;
user obj = db.users.Find(id);
if (obj == null)
{
return(Content("This user does not exist"));
}
obj.id = model.id;
obj.isActive = model.isActive;
obj.loginId = model.loginId;
obj.userName = model.userName;
obj.userPass = model.userPass;
obj.groupId = model.groupId;
db.SaveChanges();
}
return(RedirectToAction("UsersList"));
}
