public AddModel(VehicleStore vehicleStore, CustomerStore customerStore)
{
VehicleStore = vehicleStore;
CustomerStore = customerStore;
Customers = new List <Customer>();
Customers = CustomerStore.GetCustomers();
}
{// doi t ty co ty viec o tiep di coppy het ah umh het roi
public IList <CustomerModel> GetListCustomer(string name, string status)
{
try
{
var datas = new List <CustomerModel>();
var CustomerStore = new CustomerStore();
var dt = CustomerStore.GetListCustomer(name, status);
for (int i = 0; i < dt.Rows.Count; i++)
{
var model = new CustomerModel()
{
Id = int.Parse(dt.Rows[i]["CUS_ID"].ToString()),
Name = dt.Rows[i]["CUS_NAME"].ToString(),
Type = dt.Rows[i]["CUS_TYPE"].ToString(),
Status = dt.Rows[i]["CUS_STATUS"].ToString()
// CREATED_DATE = DateTime.Parse(dt.Rows[i]["CREATED_DATE"].ToString())
};
datas.Add(model);
}
return(datas);
}
catch (Exception)
{
return(null);
}
}
public IndexModel(CarStore carStore, CustomerStore customerStore)
{
CarStore = carStore;
Cars = CarStore.GetCars();
CustomerStore = customerStore;
Customers = CustomerStore.GetCustomers();
}
public void OnGet(Guid carid)
{
Car = CarStore.GetCarById(carid);
Customer = CustomerStore.GetCustomerById(Car.CustomerId);
CarId = carid;
CustomerId = Car.CustomerId;
double PrecioBase = 1000000;
double Incrementociudad = 0; //Aplica un incremento del 10% si es medellín
double IncrementoModelo = 0; //aplica un incremento del 5% si el modelo del carro es mayor de 10 años
double IncrementoEdad1 = 0; //Aplica un incremeto del 30% si la edad esta entre los 16 y 25 años
double IncrementoEdad2 = 0; //Aplica un incremeto del 30% si la edad esta entre los 25 y 40 años
if (Customer.City == "Medellin")
{
Incrementociudad = PrecioBase * 0.1;
}
if (DateTime.Today.Year - 10 > Car.Year)
{
IncrementoModelo = PrecioBase * 0.05;
}
if (DateTime.Today.AddTicks(-Customer.BirthDay.Ticks).Year - 1 > 16 && DateTime.Today.AddTicks(-Customer.BirthDay.Ticks).Year - 1 < 25)
{
IncrementoEdad1 = PrecioBase * 0.3;
}
if (DateTime.Today.AddTicks(-Customer.BirthDay.Ticks).Year - 1 > 25 && DateTime.Today.AddTicks(-Customer.BirthDay.Ticks).Year - 1 < 40)
{
IncrementoEdad2 = PrecioBase * 0.1;
}
TotalAPagar = PrecioBase + Incrementociudad + IncrementoModelo + IncrementoEdad1 + IncrementoEdad2;
}
public Insurance GetPrice(Guid idCustomer, Guid idVehicle)
{
double IncreaseByAge1 = 0.30;
double IncreaseByAge2 = 0.10;
double IncreaseByCity = 0.10;
double IncreaseByCar = 0.05;
Vehicle Vehicle = VehicleStore.GetVehiclesById(idVehicle);
Customer Customer = CustomerStore.GetCustomerById(idCustomer);
Insurance = new Insurance();
Insurance.CustomerId = idCustomer;
Insurance.VehicleId = idVehicle;
Insurance.City = Customer.City;
int Age = DateTime.Today.AddTicks(-Customer.BornDate.Ticks).Year - 1;
if (Customer.City == "Medellín")
{
Insurance.IncreaseByCity = Insurance.Baseprice * IncreaseByCity;
}
if (Vehicle.Year < (DateTime.Today.Year - 10))
{
Insurance.IncreaseByCar = Insurance.Baseprice * IncreaseByCar;
}
if (Age >= 16 && Age < 25)
{
Insurance.IncreaseByAge = Insurance.Baseprice * IncreaseByAge1;
}
else if (Age >= 25 && Age < 40)
{
Insurance.IncreaseByAge = Insurance.Baseprice * IncreaseByAge2;
}
Insurance.Total = Insurance.Baseprice + Insurance.IncreaseByAge + Insurance.IncreaseByCar + Insurance.IncreaseByCity;
return(Insurance);
}
//First call to populate the list of customers
async void Get()
{
// Local data
IsLoading = true;
var result = await CustomerStore.GetItemsAsync(FilterWeight, FilterGrade == null?null : GradeValues[FilterGrade], false);
// Server refresh
if (result == null || !result.Any())
{
if (FilterWeight == null && string.IsNullOrWhiteSpace(FilterGrade))
{
LoadingText = AppResources.FetchingData;
result = await CustomerStore.GetItemsAsync(FilterWeight, FilterGrade == null?null : GradeValues[FilterGrade], true);
CreateGroupedCollection(result);
LoadingText = AppResources.FetchingData;
}
else
{
CreateGroupedCollection(result);
}
}
else
{
CreateGroupedCollection(result);
}
IsLoading = false;
}
public decimal GetOrdersTotal(CustomerStore store, DateTime begin, DateTime end)
{
var orders = from order in store.Customer.Orders
where order.StoreId == store.Id && order.OrderDate >= begin && order.OrderDate <= end
select order;
return(orders.CustomSum(order => order.TotalAmount));
}
public EditModel(CustomerStore customerStore, DniStore dniStore, CityStore cityStore)
{
this.CustomerStore = customerStore;
this.DniStore = dniStore;
this.CityStore = cityStore;
Cities = CityStore.GetCities();
DocTypes = DniStore.GetDniTypes();
}
public void OnGet(Guid customerid)
{
CustomerId = customerid;
Vehicles = VehicleStore.GetVehiclesByCustomer(customerid);
Customer = CustomerStore.GetCustomerById(customerid);
Age = DateTime.Today.AddTicks(-Customer.BornDate.Ticks).Year - 1;
MaxYear = DateTime.Today.Year + 1;
}
public AddModel(VehicleStore vehicleStore, CustomerStore customerStore, InsuranceStore insuranceStore,
InsurancesRules insurancesRules)
{
VehicleStore = vehicleStore;
CustomerStore = customerStore;
InsuranceStore = insuranceStore;
InsurancesRules = insurancesRules;
}
public IndexModel(VehicleStore vehicleStore, CustomerStore customerStore, InsuranceStore insuranceStore)
{
VehicleStore = vehicleStore;
CustomerStore = customerStore;
InsuranceStore = insuranceStore;
Vehicles = VehicleStore.GetVehicles();
Customers = CustomerStore.GetCustomers();
Insurances = InsuranceStore.GetInsurances();
}
//SIGNALR:
private async void InitSignalR()
{
SignalRService.OnCustomerChanged(action =>
{
CustomerStore.Dispath(action);
});
await JoinGroup();
}
public IActionResult OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
//Add
CustomerStore.EditCustomer(Customer);
return(RedirectToPage("./Index"));
}
public void OnGet(Guid vehicleid)
{
Vehicle = VehicleStore.GetVehiclesById(vehicleid);
Customer = CustomerStore.GetCustomerById(Vehicle.CustomerId);
idCustomer = Customer.Id;
idVehicle = Vehicle.Id;
City = Customer.City;
Insurance = InsurancesRules.GetPrice(idCustomer, idVehicle);
Age = DateTime.Today.AddTicks(-Customer.BornDate.Ticks).Year - 1;
}
public IActionResult OnPostAsync()
{
//Add Customer
if (!ModelState.IsValid) //Hace la validacion inversa... si no es valido el modelo
{
return(Page()); //Permanece en la pagina
}
CustomerStore.AddCustomer(Customer);
return(RedirectToPage("./Index"));
}
public IActionResult OnPostAsync()
{
//Edit
if (!ModelState.IsValid)
{
return(Page());
}
Customer.BornDate = Convert.ToDateTime(BornDate);
CustomerStore.EditCustomer(Customer);
return(RedirectToPage("./Index"));
}
private void xrTableCell23_SummaryGetResult(object sender, SummaryGetResultEventArgs e)
{
if (storeSales.Count == 0)
{
e.Result = " - ";
}
else
{
CustomerStore topStore = storeSales.Aggregate((x, y) => x.Value > y.Value ? x : y).Key;
e.Result = topStore.City + " Store (" + topStore.CustomerName + ")";
}
e.Handled = true;
}
private void xrTableCell23_SummaryRowChanged(object sender, EventArgs e)
{
CustomerStore currentStore = ((Order)GetCurrentColumnValue("Order")).Store;
decimal total = (decimal)GetCurrentColumnValue("Total");
if (storeSales.ContainsKey(currentStore))
{
storeSales[currentStore] += total;
}
else
{
storeSales.Add(currentStore, total);
}
}
public PersistenceStore(string connectionString)
{
var connection = new SqlConnection(connectionString);
_dbUtility = new DatabaseUtility(connection);
Customers = new CustomerStore(_dbUtility);
CustomerAuthentications = new CustomerAuthenticationStore(_dbUtility);
EventEntries = new EventEntriesStore(_dbUtility);
Server = new ServerStore(_dbUtility);
Users = new UserStore(_dbUtility);
UserAuthentications = new UserAuthenticationStore(_dbUtility);
UserSessions = new UserSessionStore(_dbUtility);
Views = new ViewStore(_dbUtility);
}
private void AddDemoCustomerData()
{
CustomerStore.Add(new CustomerEntity()
{
CustomerUId = "CUID1-JW", FirstName = "John", LastName = "Wick"
});
CustomerStore.Add(new CustomerEntity()
{
CustomerUId = "CUID2-MS", FirstName = "Michael", LastName = "Stonebridge"
});
CustomerStore.Add(new CustomerEntity()
{
CustomerUId = "CUID3-MW", FirstName = "Michael", LastName = "Weston"
});
}
public IndexModel(VehicleStore vehicleStore, CustomerStore customerStore)
{
VehicleStore = vehicleStore;
CustomerStore = customerStore;
Customer = new Customer();
Vehicle = new Vehicle();
Insurance = new Insurance();
Customers = new List <Customer>();
Vehicles = new List <Vehicle>();
Vehicles = VehicleStore.GetVehicles();
Customers = CustomerStore.GetCustomers();
}
public AccountController(
IIdentityServerInteractionService interaction,
IClientStore clientStore,
IAuthenticationSchemeProvider schemeProvider,
IEventService events,
CustomerStore users = null)
{
// if the CustomerStore is not in DI, then we'll just use the global users collection
// this is where you would plug in your own custom identity management library (e.g. ASP.NET Identity)
_users = users ?? new CustomerStore(null);
_interaction = interaction;
_clientStore = clientStore;
_schemeProvider = schemeProvider;
_events = events;
}
async Task ExecuteLoadCustomersCommand()
{
IsBusy = true;
try
{
var items = await CustomerStore.ListAsync(q => q.OrderBy(x => x.CompanyName));
Customers.SetItems(items);
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
finally
{
IsBusy = false;
}
}
public CustomersController(CustomerStore store)
{
this.store = store;
}
public void OnGet(Guid id) //llega de la pagina id
{
Customer = CustomerStore.GetCustomerById(id);
}
public EditModel(CustomerStore customerStore)
{
CustomerStore = customerStore;
}
public static void Execute (Atom parent){
Task v= new Task( ()=> Firebug.Console.Log("hello"));
v.Start ();
var store = new UserStore ();
var grid = new UserGrid (parent, store);
store.Read ();
var form = new UserForm (parent);
form.ButtonCreate.Disabled = false;
form.ButtonCreate.Clicked+= (e) => {
grid.ClearSelection();
form.Clear();
};
form.ButtonDestroy.Clicked+= (e) => {
form.Clear();
var u = store.First(r=>r.Id== int.Parse( grid.SelectedRow.RecordId ));
store.Remove(u);
};
form.Changed+= (e) => {
form.ButtonSave.Disabled= !form.HasChanges();
};
form.Updated += (fr, ac) => {
form.ButtonDestroy.Disabled= ac == FormUpdatedAction.Clear;
form.ButtonSave.Disabled=true;
};
form.SubmitHandler = fr => SubmitHandler (grid, form, store);
grid.RowSelected += (g, row) => {
var u = store.First(r=>r.Id== int.Parse( row.RecordId));
form.PopulateFrom(u);
};
parent.Append("Paged Tables".Header (3));
var cu = new CustomerStore ();
new CustomerGrid(parent, cu);
parent.Append (new StorePager<Customer>(cu));
cu.Read ();
parent.Append ("Filters".Header (3));
var cu2 = new CustomerStore ();
new TextInput (parent, i=> {
i.Placeholder="Country";
i.On("keyup", evt=>{
var st = i.Value.ToUpper();
cu2.Filter( f=>f.Country.ToUpper().StartsWith(st));
});
});
new CustomerGrid (parent, cu2);
parent.Append (new StorePager<Customer>(cu2));
cu2.Read ();
parent.Append ("C# code".Header(3));
var rq =jQuery.GetData<string> ("code/demotables.html");
rq.Done (s=> {
var code=new Div();
code.InnerHTML= s;
parent.Append(code);
});
}
public void OnGet(Guid id)
{
Customer = CustomerStore.GetCustomerById(id);
BornDate = Customer.BornDate.ToString("dd/MM/yyyy");
}
public void TestInsertCustomer1()
{
var usoEntities = new USOEntities();
//法人
var customerLegal = new CustomerLegal
{
LegalNumber = "0000001",
CustomerName = "邛崃市正大电器公司",
LegalPerson = "张三",
BisinessLicense = "00000000000000001",
Contact = "028-88888888"
};
usoEntities.CustomerLegals.Add(customerLegal);
var org = usoEntities.Organizations.Find(8);
//法人组织
var customerLegalOrg = new CustomerLegalOrg
{
CustomerLegal = customerLegal,
Organization = org,
};
usoEntities.CustomerLegalOrgs.Add(customerLegalOrg);
//门店1
var customerStore = new CustomerStore
{
CustomerLegal = customerLegal,
StoreName = "邛崃东街经营部",
StoreAddress = "邛崃市东街101号",
StoreType = usoEntities.Dictionaries.Where(p => p.FieldName == "StoreType" && p.FieldValue == "1").FirstOrDefault().Id
};
usoEntities.CustomerStores.Add(customerStore);
//法人集团关系
var r3ProductCompany1 =
usoEntities.Organizations.FirstOrDefault(p => p.OrganizationType == OrganizationType.Head);
var r3CustomerLegal = new R3CustomerLegal
{
CustomerLegal = customerLegal,
Organization = r3ProductCompany1,
R3CustomerCode = "000001",
};
usoEntities.R3CustomerLegals.Add(r3CustomerLegal);
//法人门店集团关系
//var r3ProductCompany2 = usoEntities.R3ProductCompanys.Find(1);
// var r3CustomerStore = new R3CustomerStore
// {
// CustomerStore = customerStore,
// R3ProductCompany = r3ProductCompany2,
// R3CustomerCode = "000001001"
// };
// usoEntities.R3CustomerStores.Add(r3CustomerStore);
//法人账号（管理员）
var customerUserAdmin = new CustomerUser
{
CustomerLegal = customerLegal,
UserName = "******",
Password = "******",
CustomerRole = CustomerRole.Administrator,
CustomerUserStatus = CustomerUserStatus.Valid,
};
usoEntities.CustomerUsers.Add(customerUserAdmin);
//法人账号（产品经理）
var customerUserProductManager = new CustomerUser
{
CustomerLegal = customerLegal,
UserName = "******",
Password = "******",
CustomerRole = CustomerRole.ProductManager,
CustomerUserStatus = CustomerUserStatus.Valid,
};
usoEntities.CustomerUsers.Add(customerUserProductManager);
//法人账号(店员)
var customerUserShopAssistant = new CustomerUser
{
CustomerLegal = customerLegal,
UserName = "******",
Password = "******",
CustomerRole = CustomerRole.ShopAssistant,
CustomerUserStatus = CustomerUserStatus.Valid,
};
usoEntities.CustomerUsers.Add(customerUserShopAssistant);
usoEntities.SaveChanges();
}
public StoreProductSale(CustomerStore store)
{
this.store = store;
}
public IndexModel(CustomerStore customerStore)
{
this.CustomerStore = customerStore;
Customers = customerStore.GetCustomers();
}
