public ImportPolicy(DtoPolicyExport export)
{
_export = export;
_policyService = new ServicePolicy();
_policy = new EntityPolicy();
_uow = new UnitOfWork();
}
public EntityPolicy Insert(EntityPolicy Poliza)
{
var objRepository = new RepositoryPolicy();
EntityPolicy data = new EntityPolicy()
{
PK_PolicyID = 0,
FK_OrderID = Poliza.FK_OrderID,
FK_ClientID = Poliza.FK_ClientID,
FK_EmployeeID = Poliza.FK_EmployeeID,
FK_QuotationID = Poliza.FK_QuotationID,
FK_ProductID = Poliza.FK_ProductID,
FK_ShopPlace = Poliza.FK_ShopPlace,
IDPolicy = Poliza.IDPolicy,
PolicyPrice = Poliza.PolicyPrice,
Coin = Poliza.Coin,
SalesOrg = Poliza.SalesOrg,
ccGroup = Poliza.ccGroup,
SerialNumber = Poliza.SerialNumber,
PriceList = Poliza.PriceList,
MaterialGroup4 = Poliza.MaterialGroup4,
GuarantyStart = Poliza.GuarantyStart,
GuarantyEnd = Poliza.GuarantyEnd,
PolicyDate = Poliza.PolicyDate,
Status = true,
CreateDate = DateTime.UtcNow.ToLocalTime(),
ModifyDate = DateTime.UtcNow.ToLocalTime()
};
data = objRepository.Insert(data);
return(data);
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
RequiresAuthorization(AuthorizationStrings.PolicyRead);
Policy = !string.IsNullOrEmpty(Request.QueryString["policyId"])
? Call.PolicyApi.Get(Convert.ToInt32(Request.QueryString["policyId"]))
: null;
}
public void TestCustomersIncludeOrders()
{
var policy = new EntityPolicy();
policy.IncludeWith <Customer>(c => c.Orders);
Northwind nw = new Northwind(this.GetProvider().WithPolicy(policy));
TestQuery(
nw.Customers
);
}
public void TestCustomersIncludeOrdersDeferred()
{
var policy = new EntityPolicy();
policy.IncludeWith <Customer>(c => c.Orders, true);
Northwind nw = new Northwind(this.provider.New(policy));
TestQuery(
nw.Customers
);
}
public void TestCustomersIncludeOrdersAndDetails()
{
var policy = new EntityPolicy();
policy.IncludeWith <Customer>(c => c.Orders);
policy.IncludeWith <Order>(o => o.Details);
Northwind nw = new Northwind(this.provider.New(policy));
TestQuery(
nw.Customers
);
}
public DtoPolicyExport Export(DtoPolicyExportGeneral exportInfo)
{
_policy = _policyService.GetPolicy(exportInfo.PolicyId);
if (_policy == null)
{
return(null);
}
var validationResult = new ValidatePolicy().Validate(exportInfo.PolicyId);
if (!validationResult.Success)
{
return(null);
}
CopyPolicy(exportInfo);
var policyModules = _policyService.SearchAssignedPolicyModules(exportInfo.PolicyId, _filter);
foreach (var policyModule in policyModules.OrderBy(x => x.Name))
{
if (policyModule.ModuleType == EnumModule.ModuleType.Command)
{
CopyCommandModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.FileCopy)
{
CopyFileCopyModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Script)
{
CopyScriptModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Printer)
{
CopyPrinterModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Software)
{
CopySoftwareModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Wupdate)
{
CopyWuModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Message)
{
CopyMessageModule(policyModule);
}
}
return(_policyExport);
}
public void TestCustomersIncludeOrdersViaConstructorOnly()
{
var mapping = new AttributeMapping(typeof(NorthwindX));
var policy = new EntityPolicy();
policy.IncludeWith <CustomerX>(c => c.Orders);
NorthwindX nw = new NorthwindX(this.provider.New(policy).New(mapping));
TestQuery(
nw.Customers
);
}
public void TestCustomersWhereIncludeOrders()
{
var policy = new EntityPolicy();
policy.IncludeWith <Customer>(c => c.Orders);
Northwind nw = new Northwind(this.provider.New(policy));
TestQuery(
from c in nw.Customers
where c.City == "London"
select c
);
}
public void TestCustomersWhereIncludeOrdersAndDetails()
{
var policy = new EntityPolicy();
policy.IncludeWith <Customer>(c => c.Orders);
policy.IncludeWith <Order>(o => o.Details);
Northwind nw = new Northwind(this.GetProvider().WithPolicy(policy));
TestQuery(
from c in nw.Customers
where c.City == "London"
select c
);
}
public DtoClientPolicy Create(int policyId)
{
_policy = _policyService.GetPolicy(policyId);
Policy();
DtoModuleSearchFilter filter = new DtoModuleSearchFilter();
filter.IncludeCommand = true;
filter.IncludeFileCopy = true;
filter.IncludePrinter = true;
filter.IncludeScript = true;
filter.IncludeSoftware = true;
filter.IncludeWu = true;
filter.IncludeMessage = true;
filter.Limit = Int32.MaxValue;
var policyModules = _policyService.SearchAssignedPolicyModules(policyId, filter);
foreach (var policyModule in policyModules.OrderBy(x => x.Name))
{
if (policyModule.ModuleType == EnumModule.ModuleType.Command)
{
CommandModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.FileCopy)
{
FileCopyModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Script)
{
ScriptModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Printer)
{
PrinterModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Software)
{
SoftwareModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Wupdate)
{
WuModule(policyModule);
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Message)
{
MessageModule(policyModule);
}
}
return(_clientPolicy);
}
public DtoActionResult Post(EntityPolicy policy)
{
var result = _policyServices.AddPolicy(policy);
if (result.Success)
{
var auditLog = new EntityAuditLog();
auditLog.ObjectType = "Policy";
auditLog.ObjectId = result.Id;
auditLog.ObjectName = policy.Name;
auditLog.ObjectJson = JsonConvert.SerializeObject(policy);
auditLog.UserId = _userId;
auditLog.AuditType = EnumAuditEntry.AuditType.Create;
_auditLogService.AddAuditLog(auditLog);
}
return(result);
}
public DtoActionResult AddPolicy(EntityPolicy policy)
{
policy.Guid = Guid.NewGuid().ToString();
var validationResult = ValidatePolicy(policy, true);
var actionResult = new DtoActionResult();
if (validationResult.Success)
{
_uow.PolicyRepository.Insert(policy);
_uow.Save();
actionResult.Success = true;
actionResult.Id = policy.Id;
}
else
{
actionResult.ErrorMessage = validationResult.ErrorMessage;
}
return(actionResult);
}
public DtoActionResult UpdatePolicy(EntityPolicy policy)
{
var u = GetPolicy(policy.Id);
if (u == null)
{
return new DtoActionResult {
ErrorMessage = "Policy Not Found", Id = 0
}
}
;
var activePolicy = GetActivePolicy(policy.Id);
if (activePolicy != null)
{
return new DtoActionResult()
{
ErrorMessage = "Active Policies Cannot Be Updated. You Must Deactivate It First."
}
}
;
var validationResult = ValidatePolicy(policy, false);
var actionResult = new DtoActionResult();
if (validationResult.Success)
{
_uow.PolicyRepository.Update(policy, policy.Id);
_uow.Save();
actionResult.Success = true;
actionResult.Id = policy.Id;
}
else
{
actionResult.ErrorMessage = validationResult.ErrorMessage;
}
return(actionResult);
}
public DtoActionResult Put(int id, EntityPolicy policy)
{
policy.Id = id;
var result = _policyServices.UpdatePolicy(policy);
if (result == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
if (result.Success)
{
var auditLog = new EntityAuditLog();
auditLog.ObjectType = "Policy";
auditLog.ObjectId = result.Id;
auditLog.ObjectName = policy.Name;
auditLog.ObjectJson = JsonConvert.SerializeObject(policy);
auditLog.UserId = _userId;
auditLog.AuditType = EnumAuditEntry.AuditType.Update;
_auditLogService.AddAuditLog(auditLog);
}
return(result);
}
private DtoValidationResult ValidatePolicy(EntityPolicy policy, bool isNew)
{
var validationResult = new DtoValidationResult {
Success = true
};
if (string.IsNullOrEmpty(policy.Name) || !policy.Name.All(c => char.IsLetterOrDigit(c) || c == '_' || c == '-' || c == ' ' || c == '.'))
{
validationResult.Success = false;
validationResult.ErrorMessage = "Policy Name Is Not Valid";
return(validationResult);
}
if (isNew)
{
if (_uow.PolicyRepository.Exists(h => h.Name == policy.Name))
{
validationResult.Success = false;
validationResult.ErrorMessage = "A Policy With This Name Already Exists";
return(validationResult);
}
}
else
{
var originalPolicy = _uow.PolicyRepository.GetById(policy.Id);
if (originalPolicy.Name != policy.Name)
{
if (_uow.PolicyRepository.Exists(h => h.Name == policy.Name))
{
validationResult.Success = false;
validationResult.ErrorMessage = "A Policy With This Name Already Exists";
return(validationResult);
}
}
}
return(validationResult);
}
public string SetPolicyQuotation(ModelViewUserG objCred, ModelViewBilling obj)
{
var NegocioOrders = new BusinessOrder();
var objAlerta = new BusinessNotification();
var NegocioUsuario = new BusinessUsers();
var NegocioCliente = new BusinessClient();
var NegocioProducto = new BusinessProduct();
var NegocioCotizacion = new BusinessQuotation();
var NegocioEmpleado = new BusinessEmployee();
var NegocioMonitor = new BusinessVisit();
var NegocioPayment = new BusinessPayment();
var NegocioInvoice = new BusinessInvoice();
var dataUsuario = NegocioUsuario.GetUserByToken(objCred.TokenUser);
if (objCred.TokenApp != GlobalConfiguration.TokenWEB)
{
if (objCred.TokenApp != GlobalConfiguration.TokenMobile)
{
throw new Exception("TokenInvalid");
}
}
if (dataUsuario == null)
{
throw new Exception("UserPasswordInvalid");
}
var empleado = NegocioEmpleado.GetByUserID(dataUsuario.UserID);
var orden = NegocioOrders.GetByOrderID(obj.ODS);
var cliente = NegocioCliente.GetByID(orden.FK_ClientID);
var pro = NegocioProducto.GetByID(obj.FK_ProductID.Value);
string Folio = obj.Policies.Folio;
var cotizacion = NegocioCotizacion.GetByOrderFolio(orden.PK_OrderID, Folio);
var Payment = NegocioPayment.GetPolicyPayment(orden.PK_OrderID, Folio);
var Invoice = NegocioInvoice.GetPolicyInvoice(orden.PK_OrderID, Folio);
var LsPolicy = GetByFolio(orden.PK_OrderID, Folio);
SpreadsheetInfo.SetLicense("EQU2-3K5L-UZDC-SDYN");
string Origin = GlobalConfiguration.MabeAttachmentsLocal + "FormatoPolizas.xlsx";
List <string> result = obj.EMails.Split(new char[] { ';' }).ToList();
ExcelFile ef = ExcelFile.Load(Origin);
ExcelWorksheet ws = ef.Worksheets[0];
ws.Cells["L6"].Value = Folio;
//ws.Cells["L7"].Value = obj.ODS;
ws.Cells["L9"].Value = cliente.ClientID;
ws.Cells["L11"].Value = cliente.FirstName.ToUpper() + " " + cliente.LastName.ToUpper();
ws.Cells["L13"].Value = pro.Model + " / " + pro.ProductName.ToUpper();
ws.Cells["U13"].Value = DateTime.Today.ToString("dd-MM-yyyy");
ws.Cells["L79"].Value = Folio;
//ws.Cells["L80"].Value = obj.ODS;
int cantidad = 30;
int cantidad1 = 31;
ws.Cells["L" + cantidad1.ToString()].Value = obj.Policies.PolicyDescription;
ws.Cells["L" + cantidad.ToString()].Value = "Venta de Poliza";
ws.Cells["J" + cantidad.ToString()].Value = 1;
ws.Cells["V" + cantidad.ToString()].Value = Convert.ToDouble(obj.SubTotal);
double subtotal = Convert.ToDouble(obj.SubTotal.Substring(0));
double iva = Convert.ToDouble(obj.IVA.Substring(0));
double total = Convert.ToDouble(obj.Total.Substring(0));
double subtotalref = subtotal;
string totalletras = NegocioOrders.enletras(total.ToString());
ws.Cells["M17"].Value = subtotal;
ws.Cells["M18"].Value = iva;
ws.Cells["U16"].Value = total;
ws.Cells["M19"].Value = totalletras;
string file = "CotizaciónPoliza_" + Folio + ".pdf";
string quotion = "CotizacionesPoliza_" + DateTime.Today.ToString("yyyyMMdd");
string Destiny = GlobalConfiguration.MabeAttachmentsLocal + quotion + "/" + file;
if (obj.BillingDetails.Count < 11)
{
ws.NamedRanges.SetPrintArea(ws.Cells.GetSubrange("J1", "W74"));
}
string Cotizaciones = new DirectoryInfo(GlobalConfiguration.MabeAttachmentsLocal).ToString() + quotion;
if (!(Directory.Exists(Cotizaciones)))
{
Directory.CreateDirectory(Cotizaciones);
}
ef.Save(Destiny);
string URL = GlobalConfiguration.urlRequest + "Content/Attachments/" + quotion + "/" + file;
if (obj.EMails != "")
{
if (cotizacion == null)
{
cotizacion = NegocioCotizacion.Insert(orden.PK_OrderID, subtotal.ToString(), iva.ToString(), total.ToString(), Folio, URL, obj.EstimatedTipe, empleado[0].PK_EmployeeID);
}
else
{
cotizacion.Folio = Folio;
cotizacion.IVA = iva.ToString();
cotizacion.SubTotal = subtotal.ToString();
cotizacion.Total = total.ToString();
cotizacion.URL = URL;
cotizacion.ModifyDate = DateTime.UtcNow;
cotizacion.TypeQuotation = obj.EstimatedTipe;
cotizacion.FK_EmployeeID = empleado[0].PK_EmployeeID;
NegocioCotizacion.Update(cotizacion);
}
string sb = File.ReadAllText(GlobalConfiguration.LocateBodyMail + "NotificationPoliza.txt");
string lugCom = obj.ShopDate != null ? obj.ShopDate : "";
sb = sb.Replace("#%Nombre%#", cliente.FirstName + " " + cliente.LastName);
sb = sb.Replace("#%OrderID%#", obj.ODS);
sb = sb.Replace("#%Folio%#", Folio);
sb = sb.Replace("#%Modelo%#", pro.Model);
sb = sb.Replace("#%Descripcion%#", pro.ProductName.ToUpper());
sb = sb.Replace("#%Fecha%#", obj.Policies.PolicyDate);
sb = sb.Replace("#%Vigencia1%#", obj.Policies.PolicyDescription);
sb = sb.Replace("#%Precio%#", obj.Total);
objAlerta.SendMailExchange(GlobalConfiguration.exchangeUserCotiza, GlobalConfiguration.exchangePwdCotiza, result, "Cotización ServiPlus", sb.ToString(), Destiny);
}
else
{
if (LsPolicy.PK_PolicyID == 0)
{
if (cotizacion == null)
{
cotizacion = NegocioCotizacion.Insert(orden.PK_OrderID, subtotal.ToString(), iva.ToString(), total.ToString(), Folio, URL, obj.EstimatedTipe, empleado[0].PK_EmployeeID);
}
else
{
cotizacion.Folio = Folio;
cotizacion.IVA = iva.ToString();
cotizacion.SubTotal = subtotal.ToString();
cotizacion.Total = total.ToString();
cotizacion.URL = URL;
cotizacion.ModifyDate = DateTime.UtcNow;
cotizacion.TypeQuotation = obj.EstimatedTipe;
cotizacion.FK_EmployeeID = empleado[0].PK_EmployeeID;
NegocioCotizacion.Update(cotizacion);
}
var NewPolicy = new EntityPolicy();
var NuevaPoliza = new EntityPolicy();
NewPolicy.FK_OrderID = orden.PK_OrderID;
NewPolicy.FK_ClientID = cliente.PK_ClientID;
NewPolicy.FK_EmployeeID = empleado[0].PK_EmployeeID;
NewPolicy.FK_PaymentID = Payment.PK_PaymentID;
NewPolicy.FK_Invoice_ID = Invoice.InvoicingID;
NewPolicy.FK_QuotationID = cotizacion.PK_QuotationID;
NewPolicy.FK_ProductID = pro.PK_ProductID;
NewPolicy.FK_ShopPlace = obj.FK_ShopPlaceID.Value;
NewPolicy.IDPolicy = obj.Policies.Folio;
NewPolicy.SerialNumber = obj.SerialNumber;
NewPolicy.PriceList = obj.Policies.PriceList;
NewPolicy.PolicyPrice = obj.Policies.PolicyPrice;
NewPolicy.Coin = obj.Policies.Coin;
NewPolicy.SalesOrg = obj.Policies.SalesOrg;
NewPolicy.ccGroup = obj.Policies.ccGroup;
NewPolicy.MaterialGroup4 = obj.Policies.MaterialGroup4;
NewPolicy.GuarantyStart = Convert.ToDateTime(obj.Policies.GuarantyStart);
NewPolicy.GuarantyEnd = Convert.ToDateTime(obj.Policies.GuarantyEnd);
NewPolicy.PolicyDate = obj.Policies.PolicyDate;
NuevaPoliza = Insert(NewPolicy);
}
else
{
LsPolicy.FK_OrderID = orden.PK_OrderID;
LsPolicy.FK_ClientID = cliente.PK_ClientID;
LsPolicy.FK_EmployeeID = empleado[0].PK_EmployeeID;
LsPolicy.FK_PaymentID = Payment.PK_PaymentID;
LsPolicy.FK_Invoice_ID = Invoice.InvoicingID;
LsPolicy.FK_QuotationID = LsPolicy.FK_QuotationID;
LsPolicy.FK_ProductID = obj.Policies.ProductID;
LsPolicy.FK_ShopPlace = obj.FK_ShopPlaceID.Value;
LsPolicy.IDPolicy = obj.Policies.Folio;
LsPolicy.PolicyPrice = obj.Policies.PolicyPrice;
LsPolicy.Coin = obj.Policies.Coin;
LsPolicy.SalesOrg = obj.Policies.SalesOrg;
LsPolicy.PriceList = obj.Policies.PriceList;
LsPolicy.SerialNumber = obj.SerialNumber;
LsPolicy.ccGroup = obj.Policies.ccGroup;
LsPolicy.MaterialGroup4 = obj.Policies.MaterialGroup4;
LsPolicy.GuarantyEnd = Convert.ToDateTime(obj.Policies.GuarantyEnd);
LsPolicy.GuarantyStart = Convert.ToDateTime(obj.Policies.GuarantyStart);
LsPolicy.PolicyDate = obj.Policies.PolicyDate;
Update(LsPolicy);
if (cotizacion == null)
{
cotizacion = NegocioCotizacion.Insert(orden.PK_OrderID, subtotal.ToString(), iva.ToString(), total.ToString(), Folio, URL, obj.EstimatedTipe, empleado[0].PK_EmployeeID);
}
else
{
cotizacion.Folio = Folio;
cotizacion.IVA = iva.ToString();
cotizacion.SubTotal = subtotal.ToString();
cotizacion.Total = total.ToString();
cotizacion.URL = URL;
cotizacion.ModifyDate = DateTime.UtcNow;
cotizacion.TypeQuotation = obj.EstimatedTipe;
cotizacion.FK_EmployeeID = empleado[0].PK_EmployeeID;
NegocioCotizacion.Update(cotizacion);
}
}
var Refacciones = new BusinessMabe().Orden_Venta(obj.ODS, obj.ServiceTypes, Folio);
}
return(obj.ODS);
}
public void TestCustomersIncludeThenAssociateOrders()
{
var policy = new EntityPolicy();
policy.IncludeWith<Customer>(c => c.Orders);
policy.AssociateWith<Customer>(c => c.Orders.Where(o => (o.OrderID & 1) == 0));
Northwind nw = new Northwind(this.provider.New(policy));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI").ToList();
AssertValue(1, custs.Count);
AssertNotValue(null, custs[0].Orders);
AssertValue(3, custs[0].Orders.Count);
}
protected void btnAdd_OnClick(object sender, EventArgs e)
{
var policy = new EntityPolicy();
policy.Name = txtName.Text;
policy.Description = txtDescription.Text;
policy.Trigger =
(EnumPolicy.Trigger)Enum.Parse(typeof(EnumPolicy.Trigger), ddlTrigger.SelectedValue);
policy.Frequency = (EnumPolicy.Frequency)Enum.Parse(typeof(EnumPolicy.Frequency), ddlFrequency.SelectedValue);
if (policy.Frequency == EnumPolicy.Frequency.OncePerWeek)
{
policy.SubFrequency = Convert.ToInt16((EnumCalendar.DayOfWeek)Enum.Parse(typeof(EnumCalendar.DayOfWeek), ddlWeekDay.SelectedValue));
}
else if (policy.Frequency == EnumPolicy.Frequency.OncePerMonth)
{
policy.SubFrequency = Convert.ToInt16(ddlMonthDay.SelectedValue);
}
else if (policy.Frequency == EnumPolicy.Frequency.EveryXdays)
{
policy.SubFrequency = Convert.ToInt16(txtDays.Text);
}
else if (policy.Frequency == EnumPolicy.Frequency.EveryXhours)
{
policy.SubFrequency = Convert.ToInt16(txtHours.Text);
}
else
{
policy.SubFrequency = 0;
}
policy.WindowStartScheduleId = Convert.ToInt32(ddlScheduleStart.SelectedValue);
policy.WindowEndScheduleId = Convert.ToInt32(ddlScheduleEnd.SelectedValue);
policy.ConditionId = Convert.ToInt32(ddlCondition.SelectedValue);
policy.ConditionFailedAction = (EnumCondition.FailedAction)Enum.Parse(typeof(EnumCondition.FailedAction), ddlConditionFailedAction.SelectedValue);
//utc is not used here because time is not used only date
policy.StartDate = string.IsNullOrEmpty(txtStartDate.Text) ? Convert.ToDateTime(DateTime.Now.ToShortDateString()) : Convert.ToDateTime(txtStartDate.Text);
policy.CompletedAction = (EnumPolicy.CompletedAction)Enum.Parse(typeof(EnumPolicy.CompletedAction), ddlCompletedAction.SelectedValue);
policy.RunInventory = (EnumPolicy.InventoryAction)Enum.Parse(typeof(EnumPolicy.InventoryAction), ddlInventory.SelectedValue);
policy.RunLoginTracker = chkLoginTracker.Checked;
policy.RemoveInstallCache = chkDeleteCache.Checked;
policy.MissedAction = (EnumPolicy.FrequencyMissedAction)Enum.Parse(typeof(EnumPolicy.FrequencyMissedAction), ddlMissed.SelectedValue);
policy.ExecutionType = (EnumPolicy.ExecutionType)Enum.Parse(typeof(EnumPolicy.ExecutionType), ddlExecType.SelectedValue);
policy.ErrorAction = (EnumPolicy.ErrorAction)Enum.Parse(typeof(EnumPolicy.ErrorAction), ddlErrorAction.SelectedValue);
policy.LogLevel = (EnumPolicy.LogLevel)Enum.Parse(typeof(EnumPolicy.LogLevel), ddlLogLevel.SelectedValue);
policy.WuType = (EnumPolicy.WuType)Enum.Parse(typeof(EnumPolicy.WuType), ddlWinUpdates.SelectedValue);
policy.SkipServerResult = chkSkipResult.Checked;
policy.RunApplicationMonitor = chkApplicationMonitor.Checked;
policy.AutoArchiveType = (EnumPolicy.AutoArchiveType)Enum.Parse(typeof(EnumPolicy.AutoArchiveType), ddlAutoArchive.SelectedValue);
policy.PolicyComCondition = (EnumPolicy.PolicyComCondition)Enum.Parse(typeof(EnumPolicy.PolicyComCondition), ddlComCondition.SelectedValue);
if (policy.AutoArchiveType == EnumPolicy.AutoArchiveType.AfterXdays)
{
policy.AutoArchiveSub = txtAutoArchiveDays.Text;
}
var result = Call.PolicyApi.Post(policy);
if (!result.Success)
{
EndUserMessage = result.ErrorMessage;
}
else
{
if (policy.PolicyComCondition != EnumPolicy.PolicyComCondition.Any)
{
var list = new List <EntityPolicyComServer>();
foreach (GridViewRow row in gvServers.Rows)
{
var cb = (CheckBox)row.FindControl("chkSelector");
if (cb == null || !cb.Checked)
{
continue;
}
var dataKey = gvServers.DataKeys[row.RowIndex];
if (dataKey == null)
{
continue;
}
var policyComServer = new EntityPolicyComServer();
policyComServer.ComServerId = Convert.ToInt32(dataKey.Value);
policyComServer.PolicyId = result.Id;
list.Add(policyComServer);
}
var z = Call.PolicyComServerApi.Post(list);
if (!z.Success)
{
EndUserMessage = z.ErrorMessage;
return;
}
}
EndUserMessage = "Successfully Created Policy";
Response.Redirect("~/views/policies/general.aspx?policyId=" + result.Id);
}
}
public QueryTranslator(QueryMapping mapping, EntityPolicy policy)
{
this.Mapper = mapping.CreateMapper(this);
this.Police = policy.CreatePolice(this);
}
public void TestCustomersIncludeOrdersViaConstructorOnly()
{
var mapping = new AttributeMapping(typeof(NorthwindX));
var policy = new EntityPolicy();
policy.IncludeWith<CustomerX>(c => c.Orders);
NorthwindX nw = new NorthwindX(this.provider.New(policy).New(mapping));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI").ToList();
AssertValue(1, custs.Count);
AssertNotValue(null, custs[0].Orders);
AssertValue(6, custs[0].Orders.Count);
}
public void TestCustomersAssociateOrders()
{
var policy = new EntityPolicy();
policy.AssociateWith<Customer>(c => c.Orders.Where(o => (o.OrderID & 1) == 0));
Northwind nw = new Northwind(this.provider.New(policy));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI")
.Select(c => new { CustomerID = c.CustomerID, FilteredOrdersCount = c.Orders.Count() }).ToList();
AssertValue(1, custs.Count);
AssertValue(3, custs[0].FilteredOrdersCount);
}
public EntityPolicy Update(EntityPolicy data)
{
return(new RepositoryPolicy().Update(data));
}
public void TestCustomersIncludeOrdersWhere()
{
var policy = new EntityPolicy();
policy.IncludeWith<Customer>(c => c.Orders.Where(o => (o.OrderID & 1) == 0));
Northwind nw = new Northwind(this.provider.New(policy));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI").ToList();
Assert.AreEqual(1, custs.Count);
Assert.IsNotNull(custs[0].Orders);
Assert.AreEqual(3, custs[0].Orders.Count);
}
public DtoActionResult Validate(int policyId)
{
_policy = _policyService.GetPolicy(policyId);
if (_policy == null)
{
_result.Success = false;
_result.ErrorMessage = "Could Not Find A Policy With Id: " + policyId;
return(_result);
}
string verifyResult;
verifyResult = VerifyPolicy();
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
var policyModules = _policyService.SearchAssignedPolicyModules(policyId, _filter);
foreach (var policyModule in policyModules.OrderBy(x => x.Name))
{
verifyResult = VerifyConditions(policyModule, policyModules);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
if (policyModule.ModuleType == EnumModule.ModuleType.Command)
{
verifyResult = VerifyCommand(policyModule);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
}
else if (policyModule.ModuleType == EnumModule.ModuleType.FileCopy)
{
verifyResult = VerifyFileCopy(policyModule);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Message)
{
verifyResult = VerifyMessage(policyModule);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Script)
{
verifyResult = VerifyScript(policyModule);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Printer)
{
verifyResult = VerifyPrinter(policyModule);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Software)
{
verifyResult = VerifySoftware(policyModule);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
}
else if (policyModule.ModuleType == EnumModule.ModuleType.Wupdate)
{
verifyResult = VerifyWindowsUpdate(policyModule);
if (verifyResult != null)
{
_result.Success = false;
_result.ErrorMessage = verifyResult;
return(_result);
}
}
}
_result.Success = true;
return(_result);
}
public void TestCustomersApplyComputedFilter()
{
string ci = "Lon";
string ty = "don";
var policy = new EntityPolicy();
policy.Apply<Customer>(seq => seq.Where(c => c.City == ci + ty));
Northwind nw = new Northwind(this.provider.New(policy));
var custs = nw.Customers.ToList();
AssertValue(6, custs.Count);
}
private RelationshipIncluder(QueryMapper mapper)
{
this.mapper = mapper;
this.policy = mapper.Translator.Police.Policy;
}
public void TestOrdersIncludeDetailsWithFirst()
{
EntityPolicy policy = new EntityPolicy();
policy.IncludeWith<Order>(o => o.Details);
var ndb = new Northwind(provider.New(policy));
var q = from o in ndb.Orders
where o.OrderID == 10248
select o;
Order so = q.Single();
AssertValue(3, so.Details.Count);
Order fo = q.First();
AssertValue(3, fo.Details.Count);
}
private ClientJoinedProjectionRewriter(EntityPolicy policy)
{
this.policy = policy;
}
public void TestCustomersIncludeOrdersAndDetails()
{
var policy = new EntityPolicy();
policy.IncludeWith<Customer>(c => c.Orders);
policy.IncludeWith<Order>(o => o.Details);
Northwind nw = new Northwind(this.provider.New(policy));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI").ToList();
AssertValue(1, custs.Count);
AssertNotValue(null, custs[0].Orders);
AssertValue(6, custs[0].Orders.Count);
AssertTrue(custs[0].Orders.Any(o => o.OrderID == 10643));
AssertNotValue(null, custs[0].Orders.Single(o => o.OrderID == 10643).Details);
AssertValue(3, custs[0].Orders.Single(o => o.OrderID == 10643).Details.Count);
}
public static Expression Rewrite(EntityPolicy policy, Expression expression)
{
return new ClientJoinedProjectionRewriter(policy).Visit(expression);
}
public void TestCustomersIncludeOrdersDeferred()
{
var policy = new EntityPolicy();
policy.IncludeWith<Customer>(c => c.Orders, true);
Northwind nw = new Northwind(this.provider.New(policy));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI").ToList();
AssertValue(1, custs.Count);
AssertNotValue(null, custs[0].Orders);
AssertValue(6, custs[0].Orders.Count);
}
public void TestCustomersApplyFilterTwice()
{
var policy = new EntityPolicy();
policy.Apply<Customer>(seq => seq.Where(c => c.City == "London"));
policy.Apply<Customer>(seq => seq.Where(c => c.Country == "UK"));
Northwind nw = new Northwind(this.provider.New(policy));
var custs = nw.Customers.ToList();
AssertValue(6, custs.Count);
}
public void TestInsertCustomersIncludeOrders()
{
var policy = new EntityPolicy();
policy.IncludeWith<Customer>(c => c.Orders);
policy.IncludeWith<Order>(o => o.Details);
Northwind nw = new Northwind(this.provider.New(policy));
var cust = new Customer
{
CustomerID = "XX1",
CompanyName = "Company1",
ContactName = "Contact1",
City = "Seattle",
Country = "USA"
};
var order = new Order
{
CustomerID = "XX1",
OrderDate = DateTime.Today,
};
cust.Orders = new List<Order> { order };
var custs = nw.Customers.Insert(cust);
var result = nw.Orders.Insert(order);
cust = nw.Customers.GetById(cust.CustomerID);
Assert.AreEqual(1, custs);
//TODO: Complete Assert
//Assert.IsNotNull(custs[0].Orders);
//Assert.AreEqual(6, custs[0].Orders.Count);
//Assert.IsTrue(custs[0].Orders.Any(o => o.OrderID == 10643));
//Assert.IsNotNull(custs[0].Orders.Single(o => o.OrderID == 10643).Details);
//Assert.AreEqual(3, custs[0].Orders.Single(o => o.OrderID == 10643).Details.Count);
}
public void TestOrdersIncludeDetailsWithGroupBy()
{
var policy = new EntityPolicy();
policy.IncludeWith<Order>(o => o.Details);
Northwind nw = new Northwind(this.provider.New(policy));
var list = nw.Orders.Where(o => o.CustomerID == "ALFKI").GroupBy(o => o.CustomerID).ToList();
AssertValue(1, list.Count);
var grp = list[0].ToList();
AssertValue(6, grp.Count);
var o10643 = grp.SingleOrDefault(o => o.OrderID == 10643);
AssertNotValue(null, o10643);
AssertValue(3, o10643.Details.Count);
}
public void TestCustomersApplyOrder()
{
var policy = new EntityPolicy();
policy.Apply<Customer>(seq => seq.OrderBy(c => c.ContactName));
Northwind nw = new Northwind(this.provider.New(policy));
var list = nw.Customers.Where(c => c.City == "London").ToList();
AssertValue(6, list.Count);
var sorted = list.OrderBy(c => c.ContactName).ToList();
AssertTrue(Enumerable.SequenceEqual(list, sorted));
}
