public List <SystemGroup> SystemGroup_SelectByu_gid(string u_gid)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemGroup_SelectByu_gid");
db.AddInParameter(dbCmd, "@u_gid", DbType.String, u_gid);
List <SystemGroup> list = new List <SystemGroup>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
SystemGroup obj = Obj2Model <SystemGroup>(reader);
list.Add(obj);
}
}
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public static string CreateStringSummary(int SystemGroupId)
{
AuleaseEntities db = new AuleaseEntities();
SystemGroup systemGroup = db.SystemGroups.Where(n => n.Id == SystemGroupId).Single();
string summary = "";
List <Lease> leases = systemGroup.Leases.OrderBy(n => n.Component.TypeId).ToList();
string lineBreak = "\n";
int i = 1;
foreach (var lease in leases)
{
summary += "Component " + i.ToString() + ": " + lease.Component.Type.Name + lineBreak;
i++;
decimal TotalCost = lease.Charges.Where(n => n.TypeId == lease.Component.TypeId).Single().Price;
summary += "Total Cost: " + TotalCost.ToString() + lineBreak;
summary += "Leasing Rate: " + CalculateLeasingRate(lease.ComponentId).ToString() + lineBreak;
summary += "Insurance/Shipping/Warranty Rate: " + CalculateSecondaryCosts(lease.ComponentId).ToString("###.###") + lineBreak;
summary += "Overhead Rate: " + lease.Overhead.Rate + lineBreak;
summary += "Vendor Rate: " + lease.Charges.Where(n => n.TypeId == lease.Component.TypeId).Single().VendorRate.Rate + lineBreak;
summary += "Vendor Insurance Rate: " + (lease.Charges.Where(n => n.Type.Name == "Insurance").Count() > 0 ? lease.Charges.Where(n => n.Type.Name == "Insurance").FirstOrDefault().VendorRate.Rate.ToString("###.###") : "NaN") + lineBreak;
summary += "Tax: " + CalculateTax(lease.Component.Id).ToString("##.##") + lineBreak;
summary += "Monthly Charge: " + CalculateMonthlyCharge(lease.Id).ToString("###.###") + lineBreak;
summary += lineBreak;
}
return(summary);
}
public List <SystemGroup> SystemGroup_SelectPage(string cloumns, int pageIndex, int pageSize, string orderBy, string where, out int rowCount)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemGroup_SelectPage");
db.AddOutParameter(dbCmd, "@rowCount", DbType.Int32, 4);
db.AddInParameter(dbCmd, "@cloumns", DbType.String, cloumns);
db.AddInParameter(dbCmd, "@pageIndex", DbType.Int32, pageIndex);
db.AddInParameter(dbCmd, "@pageSize", DbType.Int32, pageSize);
db.AddInParameter(dbCmd, "@orderBy", DbType.String, orderBy);
db.AddInParameter(dbCmd, "@where", DbType.String, where);
List <SystemGroup> list = new List <SystemGroup>();
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
//属性赋值
SystemGroup obj = Obj2Model <SystemGroup>(reader);
list.Add(obj);
}
reader.NextResult();
}
rowCount = (int)dbCmd.Parameters["@rowCount"].Value;
return(list);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public async Task <bool> DeleteSystemGroup(string id)
{
var filter = Builders <SystemGroup> .Filter.Eq(s => s.InternalId, GetInternalId(id));
try
{
SystemGroup sys = new SystemGroup();
sys.InternalId = GetInternalId(id);
// only save the data outside of the checklist, update the date
var currentRecord = await _context.SystemGroups.Find(s => s.InternalId == sys.InternalId).FirstOrDefaultAsync();
if (currentRecord != null)
{
DeleteResult actionResult = await _context.SystemGroups.DeleteOneAsync(Builders <SystemGroup> .Filter.Eq("_id", sys.InternalId));
return(actionResult.IsAcknowledged && actionResult.DeletedCount > 0);
}
else
{
throw new KeyNotFoundException();
}
}
catch (Exception ex)
{
// log or manage the exception
throw ex;
}
}
public static int SystemGroup_Insert(SystemGroup obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.SystemGroup_Insert(obj));
}
}
public void ImportItem(int packageId, int itemTypeId, Type itemType,
ResourceGroupInfo group, string itemName)
{
// get service id
int serviceId = PackageController.GetPackageServiceId(packageId, group.GroupName);
if (serviceId == 0)
{
return;
}
if (itemType == typeof(SystemUser))
{
// import user
SystemUser user = new SystemUser();
user.ServiceId = serviceId;
user.PackageId = packageId;
user.Name = itemName;
user.Password = "";
user.GroupName = group.GroupName;
PackageController.AddPackageItem(user);
}
else if (itemType == typeof(SystemGroup))
{
// import group
SystemGroup spGroup = new SystemGroup();
spGroup.ServiceId = serviceId;
spGroup.PackageId = packageId;
spGroup.Name = itemName;
spGroup.GroupName = group.GroupName;
PackageController.AddPackageItem(spGroup);
}
}
public static int SystemGroup_UpdateByg_gid(SystemGroup obj)
{
using (SystemDAL access = new SystemDAL())
{
return(access.SystemGroup_UpdateByg_gid(obj));
}
}
internal void DoConstruct()
{
this.systemGroup = new SystemGroup(this.world, this.GetType().Name);
Filter.RegisterInject(this.InjectFilter);
this.OnConstruct();
Filter.UnregisterInject(this.InjectFilter);
}
public int BackupItem(string tempFolder, System.Xml.XmlWriter writer, ServiceProviderItem item, ResourceGroupInfo group)
{
if (item is SystemUser)
{
// backup system user
SharePointServer sps = GetSharePoint(item.ServiceId);
// read user info
SystemUser user = sps.GetUser(item.Name);
user.Password = ((SystemUser)item).Password;
XmlSerializer serializer = new XmlSerializer(typeof(SystemUser));
serializer.Serialize(writer, user);
}
else if (item is SystemGroup)
{
// backup system group
SharePointServer sps = GetSharePoint(item.ServiceId);
// read site info
SystemGroup sysGroup = sps.GetGroup(item.Name);
XmlSerializer serializer = new XmlSerializer(typeof(SystemGroup));
serializer.Serialize(writer, group);
}
return(0);
}
public void Test_SystemGroupWithDataIsValid()
{
SystemGroup sys = new SystemGroup();
sys.created = DateTime.Now;
sys.title = "My System Title";
sys.description = "This is my System description for all items.";
sys.numberOfChecklists = 3;
sys.nessusFilename = "myfileservers.nessus";
sys.rawNessusFile = "<xml></xml>";
sys.updatedOn = DateTime.Now;
sys.lastComplianceCheck = DateTime.Now;
// test things out
Assert.True(sys != null);
Assert.True(!string.IsNullOrEmpty(sys.created.ToShortDateString()));
Assert.True(!string.IsNullOrEmpty(sys.title));
Assert.True(!string.IsNullOrEmpty(sys.description));
Assert.True(!string.IsNullOrEmpty(sys.nessusFilename));
Assert.True(!string.IsNullOrEmpty(sys.rawNessusFile));
Assert.True(sys.numberOfChecklists == 3);
Assert.True(sys.updatedOn.HasValue);
Assert.True(!string.IsNullOrEmpty(sys.updatedOn.Value.ToShortDateString()));
Assert.True(sys.lastComplianceCheck.HasValue);
Assert.True(!string.IsNullOrEmpty(sys.lastComplianceCheck.Value.ToShortDateString()));
}
public void Test_NewSystemGroupIsValid()
{
SystemGroup sys = new SystemGroup();
Assert.True(sys != null);
Assert.True(sys.numberOfChecklists == 0);
Assert.False(sys.updatedOn.HasValue);
Assert.False(sys.lastComplianceCheck.HasValue);
}
public PartialViewResult SystemDetails(int Id)
{
AuleaseEntities db = new AuleaseEntities();
SystemGroup group = db.SystemGroups.Where(n => n.Id == Id).Single();
ViewBag.Group = group;
return(PartialView());
}
public int RestoreItem(string tempFolder, System.Xml.XmlNode itemNode, int itemId, Type itemType, string itemName, int packageId, int serviceId, ResourceGroupInfo group)
{
if (itemType == typeof(SystemUser))
{
SharePointServer sps = GetSharePoint(serviceId);
// extract meta item
XmlSerializer serializer = new XmlSerializer(typeof(SystemUser));
SystemUser user = (SystemUser)serializer.Deserialize(
new XmlNodeReader(itemNode.SelectSingleNode("SystemUser")));
// create user if required
if (!sps.UserExists(itemName))
{
user.Password = CryptoUtils.Decrypt(user.Password);
sps.CreateUser(user);
// restore password
user.Password = CryptoUtils.Encrypt(user.Password);
}
// add meta-item if required
if (PackageController.GetPackageItemByName(packageId, itemName, typeof(SystemUser)) == null)
{
user.PackageId = packageId;
user.ServiceId = serviceId;
PackageController.AddPackageItem(user);
}
}
else if (itemType == typeof(SystemGroup))
{
SharePointServer sps = GetSharePoint(serviceId);
// extract meta item
XmlSerializer serializer = new XmlSerializer(typeof(SystemGroup));
SystemGroup sysGroup = (SystemGroup)serializer.Deserialize(
new XmlNodeReader(itemNode.SelectSingleNode("SystemGroup")));
// create user if required
if (!sps.GroupExists(itemName))
{
sps.CreateGroup(sysGroup);
}
// add meta-item if required
if (PackageController.GetPackageItemByName(packageId, itemName, typeof(SystemGroup)) == null)
{
sysGroup.PackageId = packageId;
sysGroup.ServiceId = serviceId;
PackageController.AddPackageItem(sysGroup);
}
}
return(0);
}
/// <summary>
/// Return a list of checklists based on the system.
/// </summary>
/// <param name="system">The system ID for all the checklists to return.</param>
/// <returns></returns>
public static SystemGroup GetSystemGroup(string system)
{
SystemGroup sg = new SystemGroup();
// Create a new connection factory to create a connection.
ConnectionFactory cf = new ConnectionFactory();
// add the options for the server, reconnecting, and the handler events
Options opts = ConnectionFactory.GetDefaultOptions();
opts.MaxReconnect = -1;
opts.ReconnectWait = 1000;
opts.Name = "openrmf-api-compliance";
opts.Url = Environment.GetEnvironmentVariable("NATSSERVERURL");
opts.AsyncErrorEventHandler += (sender, events) =>
{
Console.WriteLine(string.Format("NATS client error. Server: {0}. Message: {1}. Subject: {2}", events.Conn.ConnectedUrl, events.Error, events.Subscription.Subject));
};
opts.ServerDiscoveredEventHandler += (sender, events) =>
{
Console.WriteLine(string.Format("A new server has joined the cluster: {0}", events.Conn.DiscoveredServers));
};
opts.ClosedEventHandler += (sender, events) =>
{
Console.WriteLine(string.Format("Connection Closed: {0}", events.Conn.ConnectedUrl));
};
opts.ReconnectedEventHandler += (sender, events) =>
{
Console.WriteLine(string.Format("Connection Reconnected: {0}", events.Conn.ConnectedUrl));
};
opts.DisconnectedEventHandler += (sender, events) =>
{
Console.WriteLine(string.Format("Connection Disconnected: {0}", events.Conn.ConnectedUrl));
};
// Creates a live connection to the NATS Server with the above options
IConnection c = cf.CreateConnection(opts);
// publish to get this list of Artifact checklists back via system
Msg reply = c.Request("openrmf.system", Encoding.UTF8.GetBytes(system), 30000);
c.Flush();
// save the reply and get back the system group record
if (reply != null)
{
sg = JsonConvert.DeserializeObject <SystemGroup>(Compression.DecompressString(Encoding.UTF8.GetString(reply.Data)));
c.Close();
return(sg);
}
c.Close();
return(sg);
}
public static int UpdateSharePointGroup(SystemGroup item)
{
// check account
int accountCheck = SecurityContext.CheckAccount(DemandAccount.NotDemo | DemandAccount.IsActive);
if (accountCheck < 0)
{
return(accountCheck);
}
// load original meta item
SystemGroup origItem = (SystemGroup)PackageController.GetPackageItem(item.Id);
if (origItem == null)
{
return(BusinessErrorCodes.ERROR_SHAREPOINT_GROUPS_PACKAGE_ITEM_NOT_FOUND);
}
// check package
int packageCheck = SecurityContext.CheckPackage(origItem.PackageId, DemandPackage.IsActive);
if (packageCheck < 0)
{
return(packageCheck);
}
// place log record
TaskManager.StartTask("SHAREPOINT", "UPDATE_GROUP", origItem.Name);
TaskManager.ItemId = item.Id;
try
{
// get service
SharePointServer sps = GetSharePoint(origItem.ServiceId);
item.Description = "WebsitePanel System Group";
// update service item
sps.UpdateGroup(item);
return(0);
}
catch (Exception ex)
{
throw TaskManager.WriteError(ex);
}
finally
{
TaskManager.CompleteTask();
}
}
public async Task <IActionResult> ExecuteAsync(string all, CancellationToken cancellationToken)
{
if (all == "1")
{
var listSystemSettingGroup = await _systemSettingGroupRepository.GetAll(cancellationToken);
var systemSettings = await _systemSettingRepository.GetAll(cancellationToken);
var systemGroupViewModels = new List <SystemGroup>();
foreach (var systemSettingGroup in listSystemSettingGroup)
{
var systemGroupViewModel = new SystemGroup();
var systemSettingGroupViewModel = _systemSettingGroupMapper.Map(systemSettingGroup);
systemGroupViewModel.Id = systemSettingGroupViewModel.Id;
systemGroupViewModel.Name = systemSettingGroupViewModel.Name;
systemGroupViewModel.Description = systemSettingGroupViewModel.Description;
systemGroupViewModel.Order = systemSettingGroupViewModel.Order;
systemGroupViewModel.Url = systemSettingGroupViewModel.Url;
var listSystemSetting = new List <SystemSetting>();
foreach (var systemSetting in systemSettings)
{
if (systemSetting.GroupId != systemSettingGroup.Id)
{
continue;
}
var systemSettingViewModel = _systemSettingMapper.Map(systemSetting);
listSystemSetting.Add(systemSettingViewModel);
}
systemGroupViewModel.ListSystemSetting = listSystemSetting;
systemGroupViewModels.Add(systemGroupViewModel);
}
return(new OkObjectResult(systemGroupViewModels));
}
var systemSettingGroups = await _systemSettingGroupRepository.GetAll(cancellationToken);
var systemSettingGroupViewModels = new List <SystemSettingGroup>();
foreach (var systemSettingGroup in systemSettingGroups)
{
var systemSettingGroupViewModel = _systemSettingGroupMapper.Map(systemSettingGroup);
systemSettingGroupViewModels.Add(systemSettingGroupViewModel);
}
return(new OkObjectResult(systemSettingGroupViewModels));
}
public void UpdateGroup(SystemGroup group)
{
try
{
Log.WriteStart("'{0}' UpdateGroup", ProviderSettings.ProviderName);
SPS.UpdateGroup(group);
Log.WriteEnd("'{0}' UpdateGroup", ProviderSettings.ProviderName);
}
catch (Exception ex)
{
Log.WriteError(String.Format("'{0}' UpdateGroup", ProviderSettings.ProviderName), ex);
throw;
}
}
public async Task <SystemGroup> AddSystemGroup(SystemGroup item)
{
try
{
await _context.SystemGroups.InsertOneAsync(item);
return(item);
}
catch (Exception ex)
{
// log or manage the exception
throw ex;
}
}
public ActionResult FormCreate(string html, string tag)
{
AuleaseEntities db = new AuleaseEntities();
Component comp = db.Components.Where(n => n.LeaseTag == tag).Single();
SystemGroup group = comp.Leases.OrderByDescending(n => n.EndDate).FirstOrDefault().SystemGroup;
Form form = new Form();
form.HTML = html;
group.Forms.Add(form);
db.SaveChanges();
return(View());
}
public SystemGroup GetGroup(string groupName)
{
try
{
Log.WriteStart("'{0}' GetGroup", ProviderSettings.ProviderName);
SystemGroup result = SPS.GetGroup(groupName);
Log.WriteEnd("'{0}' GetGroup", ProviderSettings.ProviderName);
return(result);
}
catch (Exception ex)
{
Log.WriteError(String.Format("'{0}' GetGroup", ProviderSettings.ProviderName), ex);
throw;
}
}
public static SystemGroup GetSharePointGroup(int itemId)
{
// load meta item
SystemGroup item = (SystemGroup)PackageController.GetPackageItem(itemId);
// load service item
SharePointServer sps = GetSharePoint(item.ServiceId);
SystemGroup group = sps.GetGroup(item.Name);
// add common properties
group.Id = item.Id;
group.PackageId = item.PackageId;
group.ServiceId = item.ServiceId;
return(group);
}
public async Task <bool> UpdateSystemGroup(string id, SystemGroup body)
{
var filter = Builders <SystemGroup> .Filter.Eq(s => s.InternalId, GetInternalId(id));
try
{
body.InternalId = GetInternalId(id);
var actionResult = await _context.SystemGroups.ReplaceOneAsync(filter, body);
return(actionResult.IsAcknowledged && actionResult.ModifiedCount > 0);
}
catch (Exception ex)
{
// log or manage the exception
throw ex;
}
}
public ActionResult GroupEditView()
{
string g_gid = Request["g_gid"] ?? string.Empty;
SystemGroup info = null;
if (string.IsNullOrEmpty(g_gid))
{
info = new SystemGroup();
}
else
{
info = SystemSeviceClass.SystemGroup_SelectByg_gid(g_gid);
}
ViewData["window"] = Request["window"] ?? string.Empty;
ViewData["info"] = info;
return(View());
}
public void WorldSerialization()
{
World CreateWorld()
{
World world = null;
WorldUtilities.CreateWorld <TestState>(ref world, 0.033f);
{
world.AddModule <TestStatesHistoryModule>();
world.AddModule <FakeNetworkModule>();
world.SetState <TestState>(WorldUtilities.CreateState <TestState>());
//components
{
ref var sc = ref world.GetStructComponents();
ComponentsInitializerWorld.Setup(e => e.ValidateData <TestStructComponent>());
CoreComponentsInitializer.Init(ref sc);
sc.Validate <TestStructComponent>();
}
//settings
{
world.SetSettings(new WorldSettings {
useJobsForSystems = false,
useJobsForViews = false,
turnOffViews = false,
viewsSettings = new WorldViewsSettings()
});
world.SetDebugSettings(WorldDebugSettings.Default);
}
var group = new SystemGroup(world, "GroupName");
group.AddSystem <TestSystem>();
}
var ent = new Entity("Test Entity");
ent.SetPosition(UnityEngine.Vector3.zero);
ent.SetData(new TestStructComponent());
world.SaveResetState <TestState>();
return(world);
}
public static int DeleteSharePointGroup(int itemId)
{
// check account
int accountCheck = SecurityContext.CheckAccount(DemandAccount.NotDemo);
if (accountCheck < 0)
{
return(accountCheck);
}
// load original meta item
SystemGroup origItem = (SystemGroup)PackageController.GetPackageItem(itemId);
if (origItem == null)
{
return(BusinessErrorCodes.ERROR_SHAREPOINT_GROUPS_PACKAGE_ITEM_NOT_FOUND);
}
// place log record
TaskManager.StartTask("SHAREPOINT", "DELETE_GROUP", origItem.Name);
TaskManager.ItemId = itemId;
try
{
// get service
SharePointServer sps = GetSharePoint(origItem.ServiceId);
// delete service item
sps.DeleteGroup(origItem.Name);
// delete meta item
PackageController.DeletePackageItem(origItem.Id);
return(0);
}
catch (Exception ex)
{
throw TaskManager.WriteError(ex);
}
finally
{
TaskManager.CompleteTask();
}
}
private void BindItem()
{
if (PanelRequest.ItemID == 0)
{
usernameControl.SetPackagePolicy(PanelSecurity.PackageId, UserSettings.SHAREPOINT_POLICY, "GroupNamePolicy");
BindUsers(PanelSecurity.PackageId);
return;
}
// load item
SystemGroup item = null;
try
{
item = ES.Services.SharePointServers.GetSharePointGroup(PanelRequest.ItemID);
}
catch (Exception ex)
{
ShowErrorMessage("SHAREPOINT_GET_GROUP", ex);
return;
}
if (item == null)
{
RedirectToBrowsePage();
}
BindUsers(item.PackageId);
usernameControl.SetPackagePolicy(item.PackageId, UserSettings.SHAREPOINT_POLICY, "GroupNamePolicy");
usernameControl.Text = item.Name;
usernameControl.EditMode = true;
foreach (string user in item.Members)
{
ListItem li = dlUsers.Items.FindByValue(user);
if (li != null)
{
li.Selected = true;
}
}
}
public int SystemGroup_UpdateByg_gid(SystemGroup obj)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemGroup_UpdateByg_gid");
db.AddInParameter(dbCmd, "@g_id", DbType.Int32, obj.g_id);
db.AddInParameter(dbCmd, "@g_gid", DbType.String, obj.g_gid);
db.AddInParameter(dbCmd, "@g_name", DbType.String, obj.g_name);
db.AddInParameter(dbCmd, "@g_picCover", DbType.String, obj.g_picCover);
db.AddInParameter(dbCmd, "@g_createTime", DbType.DateTime, obj.g_createTime);
db.AddInParameter(dbCmd, "@g_createUser", DbType.String, obj.g_createUser);
db.AddInParameter(dbCmd, "@g_sort", DbType.Int32, obj.g_sort);
try
{
int returnValue = db.ExecuteNonQuery(dbCmd);
return(returnValue);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult UnFinalizePage(string SerialNumber)
{
AuleaseEntities db = new AuleaseEntities();
SystemGroup group = db.Components.Where(n => n.SerialNumber == SerialNumber).Single().Leases.OrderByDescending(n => n.EndDate).First().SystemGroup;
PO po = group.PO;
List <Lease> leases = po.SystemGroups.SelectMany(n => n.Leases).ToList();
string message = "";
foreach (var lease in leases)
{
lease.MonthlyCharge = null;
lease.BeginDate = null;
lease.EndDate = null;
lease.ContractNumber = null;
message += lease.Component.SerialNumber + " has been unfinalized from the database. <br /> ";
}
db.SaveChanges();
ViewBag.message = message;
return(View());
}
public SystemGroup SystemGroup_SelectByg_gid(string g_gid)
{
DbCommand dbCmd = db.GetStoredProcCommand("Proc_SystemGroup_SelectByg_gid");
db.AddInParameter(dbCmd, "@g_gid", DbType.String, g_gid);
SystemGroup obj = null;
try
{
using (IDataReader reader = db.ExecuteReader(dbCmd))
{
while (reader.Read())
{
obj = Obj2Model <SystemGroup>(reader);
}
}
return(obj);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public async Task <ViewResultBase> Edit(SystemGroupEditViewModel viewModel)
{
var group = new SystemGroup();
//如果为编辑
if (!viewModel.GroupId.IsNullOrEmptyGuid())
{
group = await _groupLogic.GetByIdAsync(viewModel.GroupId);
ViewData["OrganizationName"] = (await _organizationLogic.GetByIdAsync(group.OrganizationId)).Name;
}
//新增
else
{
group.CreateTime = DateTime.Now;
if (!viewModel.OrganizationId.IsNullOrEmptyGuid())
{
viewModel.OrganizationId = (Guid)viewModel.OrganizationId;
ViewData["OrganizationName"] = (await _organizationLogic.GetByIdAsync(viewModel.OrganizationId)).Name;
}
}
return(View(group));
}
