public void CreateTest()
{
CustomersVM vm = _controller.Wtm.CreateVM <CustomersVM>();
Customers v = new Customers();
v.CusName = "FnN6ZV7";
v.CusGrade = SCMSupplyChain.Model.CusGrade.VIP1;
v.CusCompany = "32bio";
v.CusMan = "B7358aReV";
v.CusTelephone = "uohl9Ebf";
v.CusDesc = "FIpOlvhn";
vm.Entity = v;
var rv = _controller.Add(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <Customers>().Find(v.ID);
Assert.AreEqual(data.CusName, "FnN6ZV7");
Assert.AreEqual(data.CusGrade, SCMSupplyChain.Model.CusGrade.VIP1);
Assert.AreEqual(data.CusCompany, "32bio");
Assert.AreEqual(data.CusMan, "B7358aReV");
Assert.AreEqual(data.CusTelephone, "uohl9Ebf");
Assert.AreEqual(data.CusDesc, "FIpOlvhn");
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
public async Task <int?> InsertUpdateCustomerDependence(Object obj)
{
var jsonString = obj.ToString();
var jsonObject = (JObject)JsonConvert.DeserializeObject(jsonString);
if (jsonObject["obj"] == null)
{
}
CustomerDependences result = JsonConvert.DeserializeObject <CustomerDependences>(jsonObject["obj"].ToString());
CustomersVM customer = result.customer;
string base64 = customer.Cust_Photo_Base64;
if (base64 != null)
{
customer.Cust_Photo_Base64 = String.Format(base64);
base64 = base64.Remove(0, base64.IndexOf("base64,") + 7);
customer.CUST_PHOTO = Convert.FromBase64String(base64);
}
List <TelephoneVM> telephones = result.telephones;
List <CustomerBranchesVM> customerBran = result.customerBran;
char transaction = result.transaction;
var FinalResult = customerService.InsertUpdateCustomerDependence(customer, telephones, customerBran, transaction);
await LogData("&" + FinalResult + "&" + customer.CUST_CODE, FinalResult.ToString());
return(FinalResult);
}
public ActionResult Customers()
{
ViewBag.Message = "Registered customeres list.";
CustomersVM customers = new CustomersVM();
return(View("Customers", customers));
}
public async Task <IHttpActionResult> update([FromBody] CustomersVM entity)
{
var result = await customerService.UpdateAsync(entity);
await LogData("&" + entity.ACC_ID + "&" + entity.CUST_CODE, entity.ACC_ID.ToString());
return(Ok(result));
}
public NewCustomerCommand(CustomersVM customerVM,
ICustomerRepository repository,
IAddressRepository addressRepository,
User user)
{
_customerVM = customerVM;
_repository = repository;
_addressRepository = addressRepository;
_user = user;
}
public void EditTest()
{
Customers v = new Customers();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.CusName = "FnN6ZV7";
v.CusGrade = SCMSupplyChain.Model.CusGrade.VIP1;
v.CusCompany = "32bio";
v.CusMan = "B7358aReV";
v.CusTelephone = "uohl9Ebf";
v.CusDesc = "FIpOlvhn";
context.Set <Customers>().Add(v);
context.SaveChanges();
}
CustomersVM vm = _controller.Wtm.CreateVM <CustomersVM>();
var oldID = v.ID;
v = new Customers();
v.ID = oldID;
v.CusName = "3TkrCGcR";
v.CusGrade = SCMSupplyChain.Model.CusGrade.VIP4;
v.CusCompany = "hNL3";
v.CusMan = "ZS4IJLc0";
v.CusTelephone = "xXR6AgyP";
v.CusDesc = "R41Wk";
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.CusName", "");
vm.FC.Add("Entity.CusGrade", "");
vm.FC.Add("Entity.CusCompany", "");
vm.FC.Add("Entity.CusMan", "");
vm.FC.Add("Entity.CusTelephone", "");
vm.FC.Add("Entity.CusDesc", "");
var rv = _controller.Edit(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <Customers>().Find(v.ID);
Assert.AreEqual(data.CusName, "3TkrCGcR");
Assert.AreEqual(data.CusGrade, SCMSupplyChain.Model.CusGrade.VIP4);
Assert.AreEqual(data.CusCompany, "hNL3");
Assert.AreEqual(data.CusMan, "ZS4IJLc0");
Assert.AreEqual(data.CusTelephone, "xXR6AgyP");
Assert.AreEqual(data.CusDesc, "R41Wk");
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
// Adds a new customer and calls to make a VM model for it, then adds it to list of customers and updates UI
public void AddCustomer()
{
CustomerEventArgs e = OnNewCustomerRequested();
if (e != null)
{
SelectedVMCustomer = new VMCustomer(ct.AddCustomer(e.Name, e.Company));
CustomersVM.Add(SelectedVMCustomer);
OnItemsChanged(SelectedVMCustomer);
}
}
public IHttpActionResult Create([FromBody] CustomersVM customerVM)
{
if (customerVM == null)
{
return(BadRequest());
}
var customer = Mapper.Map <CustomersVM, Customer>(customerVM);
applicationDB.Customers.Add(customer);
applicationDB.SaveChanges();
return(Created(customer.CustomerId.ToString(), customer));
}
public UpdateCustomerCommand(CustomersVM customerVM,
ICustomerRepository repository,
IAddressRepository addressRepository,
User user)
{
_customerVM = customerVM;
_repository = repository;
_addressRepository = addressRepository;
_user = user;
_customerVM.PropertyChanged += CustomerChanged;
}
public async Task <IHttpActionResult> add([FromBody] CustomersVM entity)
{
var result = await customerService.InsertAsync(entity);
await LogData("&" + entity.ACC_ID + "&" + entity.CUST_CODE, result.ToString());
if (result != 0)
{
return(Ok(true));
}
return(Ok(false));
}
public IHttpActionResult Put(int Id, [FromBody] CustomersVM customerVM)
{
if (Id == 0)
{
return(BadRequest());
}
var customer = applicationDB.Customers.FirstOrDefault(x => x.CustomerId == Id);
if (customer == null)
{
return(NotFound());
}
Mapper.Map <CustomersVM, Customer>(customerVM, customer);
applicationDB.Entry(customer).State = EntityState.Modified;
applicationDB.SaveChanges();
return(Ok());
}
public IActionResult Edit(CustomersVM vm)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
vm.DoEdit(false);
if (!ModelState.IsValid)
{
return(BadRequest(ModelState.GetErrorJson()));
}
else
{
return(Ok(vm.Entity));
}
}
}
public async Task <IHttpActionResult> delete([FromBody] CustomersVM entity)
{
var q1 = entryMasterService.getByCust(entity.ACC_ID);
var q = billMasterService.getByCust(entity.ACC_ID);
if (q.Count == 0 && q1.Count == 0)
{
var result = await customerService.DeleteAsync(entity);
await LogData("&" + entity.ACC_ID + "&" + entity.CUST_CODE, entity.ACC_ID.ToString());
return(Ok(result));
}
else
{
return(Ok(false));
}
//return Ok(await customerService.DeleteAsync(entity));
}
public ActionResult List(CustomersVM model)
{
DataAccess.NORTHWNDEntities entities = new DataAccess.NORTHWNDEntities();
var customerQry = entities.Customers.AsQueryable();
if (!string.IsNullOrWhiteSpace(model.SearchText))
{
customerQry = customerQry.Where(w => w.ContactName.Contains(model.SearchText) || w.Phone.Contains(model.SearchText));
}
model.Customers = customerQry.Select(cust => new CustometItemVM
{
Company = cust.CompanyName,
Address = cust.Address + " " + cust.City + " " + cust.Country,
Phone = cust.Phone,
CustomerName = cust.ContactName
}).ToList();
return(View(model));
}
public SearchCustomersCommand(CustomersVM customerVM)
{
_customerVM = customerVM;
}
public CustomersPage()
{
InitializeComponent();
DataContext = new CustomersVM();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DataContext = new CustomersVM();
}
