public ActionResult DeleteConfirmed(int id)
{
CustomerDM customer = serviceCustomers.GetCustomer(Convert.ToInt32(id));
serviceCustomers.DeleteCustomer(customer);
return(RedirectToAction("Index"));
}
public void AddCustomer(CustomerDM customer)
{
DBUtilities utility = new DBUtilities();
utility.cn.Open();
utility.cmd.CommandText = "sp_InsertCustomer";
utility.cmd.Parameters.Add("Name", customer.Name);
utility.cmd.Parameters.Add("Surname", customer.Surname);
utility.cmd.Parameters.Add("Title", customer.Title);
utility.cmd.Parameters.Add("Gender", customer.Gender);
utility.cmd.Parameters.Add("DateOfBirth", customer.DateOfBirth);
utility.cmd.Parameters.Add("TCNo", customer.TCNo);
utility.cmd.Parameters.Add("TaxNo", customer.TaxNo);
utility.cmd.Parameters.Add("TaxAdministration", customer.TaxAdministration);
utility.cmd.Parameters.Add("City", customer.City);
utility.cmd.Parameters.Add("Town", customer.Town);
utility.cmd.Parameters.Add("Address", customer.Address);
utility.cmd.Parameters.Add("HomePhone", customer.HomePhone);
utility.cmd.Parameters.Add("BusinessPhone", customer.BusinessPhone);
utility.cmd.Parameters.Add("CepPhone", customer.CepPhone);
utility.cmd.ExecuteScalar();
utility.endC();
}
public void UpdateCustomer(CustomerDM customerDM)
{
try
{
UOW.Customers.Update(customerDM.ToCustomer());
UOW.Save();
}
catch (Exception ex)
{
throw new DataException(ex.Message, "Error in updating Customer");
}
}
private async Task Register()
{
var customer = new CustomerDM
{
FirstName = Name.Value,
LastName = Name.Value,
PhoneNumber = Phone.Value
};
Model.Customer = customer;
Model.OrderTime = DateTime.Now;
await OrdersService.Create(Model, RequestPriority.UserInitiated);
}
public CustomerView(CustomerDM customer)
{
CustomerID = customer.CustomerID;
FirstName = customer.FirstName;
LastName = customer.LastName;
List <SaleView> sales = new List <SaleView>();
if (customer.Sales != null)
{
foreach (SaleDM s in customer.Sales)
{
sales.Add(new SaleView(s));
}
}
Sales = sales;
}
public void DeleteCustomer(CustomerDM customerDM)
{
try
{
Customer customer = UOW.Customers.Get(customerDM.CustomerID);
foreach (Sale s in UOW.Sales
.Find(s => s.CustomerID == customer.CustomerID))
{
UOW.Supplies.Delete(s.SaleID);
}
UOW.Save();
UOW.Customers.Delete(customer.CustomerID);
UOW.Save();
}
catch (Exception ex)
{
throw new DataException(ex.Message, "Error in deleting Customer");
}
}
public List <CustomerDM> getCustomerList()
{
List <CustomerDM> customerList = new List <CustomerDM>();
DBUtilities utility = new DBUtilities();
utility.cn.Open();
utility.cmd.CommandText = "sp_getCustomer";
utility.cmd.ExecuteScalar();
SqlDataReader dr = utility.cmd.ExecuteReader();
while (dr.Read())
{
CustomerDM cdm = new CustomerDM();
cdm.ID = Convert.ToInt32(dr["ID"]);
cdm.Name = dr["Name"].ToString();
cdm.Surname = dr["Surname"].ToString();
customerList.Add(cdm);
}
dr.Close();
utility.endC();
return(customerList);
}
public void AddCustomer(CustomerDM customerDM)
{
UOW.Customers.Create(customerDM.ToCustomerNoID());
UOW.Save();
}