public async Task <Tbl_Customer> AddCustomerAsync(Tbl_Customer tbl_Customer) { await _context.Tbl_Customer.AddAsync(tbl_Customer); await _context.SaveChangesAsync(); return(tbl_Customer); }
public bool RemoveCustomer(Tbl_Customer customer) { if (_context.Tbl_Customer.Any(x => x.Customer_ID == customer.Customer_ID)) { _context.Tbl_Customer.Remove(_context.Tbl_Customer.Where(x => x.Customer_ID == customer.Customer_ID).FirstOrDefault()); _context.SaveChanges(); } return(true); }
public async Task <Tbl_Customer> UpdateCustomerAsync(int id, Tbl_Customer tbl_Customer) { _context.Update(tbl_Customer); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { throw; } return(tbl_Customer); }
public bool EditCustomer(Tbl_Customer customer, int customer_id, int active_id, int field_id) { try { if (_context.Tbl_Customer.Any(x => x.Customer_ID == customer_id)) { // user already exists Tbl_Customer ToBeUpdatedCustomer = _context.Tbl_Customer.First(x => x.Customer_ID == customer_id); ToBeUpdatedCustomer.Address = customer.Address; ToBeUpdatedCustomer.CompanyRegistrationName = customer.CompanyRegistrationName; ToBeUpdatedCustomer.CustomerConnector = customer.CustomerConnector; ToBeUpdatedCustomer.CustomerName = customer.CustomerName; ToBeUpdatedCustomer.EconomicalNumber = customer.EconomicalNumber; ToBeUpdatedCustomer.Active = customer.Active; ToBeUpdatedCustomer.CustomerField_ID = customer.CustomerField_ID; ToBeUpdatedCustomer.Email = customer.Email; ToBeUpdatedCustomer.FaxNo = customer.FaxNo; ToBeUpdatedCustomer.MobileNo = customer.MobileNo; ToBeUpdatedCustomer.NationalID = customer.NationalID; ToBeUpdatedCustomer.PostalCode = customer.PostalCode; ToBeUpdatedCustomer.RegistrationNumber = customer.RegistrationNumber; //ToBeUpdatedCustomer.SubscriptionCode = customer.SubscriptionCode; ToBeUpdatedCustomer.TelNo = customer.TelNo; ToBeUpdatedCustomer.LastUpdateDate = customer.LastUpdateDate; ToBeUpdatedCustomer.LastUpdateTime = customer.LastUpdateTime; ToBeUpdatedCustomer.LastUpdateUser_ID = customer.LastUpdateUser_ID; if (_context.SaveChanges() > 0) { return(true); } else { return(false); } } else { return(false); } } catch (Exception ex) { return(false); } }
public static Customer MapFrom(this Tbl_Customer customer) { return(new Customer { Id = customer.Id, Name = customer.Name, PhoneNumber = customer.PhoneNumber, Email = customer.Email, CurrencyId = customer.CurrencyId, TaxNumber = customer.TaxNumber, Address = customer.Address, IsEnabled = customer.IsEnabled, Refrence = customer.Refrence, Created_At = customer.Created_At, Updated_At = customer.Updated_At, BranchId = customer.BranchId, Website = customer.Website, CanLogin = customer.CanLogin, AccountNumber = customer.AccountNumber, SadadNumber = customer.SadadNumber }); }
public int AddNewCustomer(Tbl_Customer customer, int customer_id, int active_id, int field_id) { try { Random generator = new Random(); int r = generator.Next(100000, 1000000); Tbl_Customer ToBeInsertedCustomer = new Tbl_Customer(); ToBeInsertedCustomer.Address = customer.Address; ToBeInsertedCustomer.CompanyRegistrationName = customer.CompanyRegistrationName; ToBeInsertedCustomer.CustomerConnector = customer.CustomerConnector; ToBeInsertedCustomer.CustomerName = customer.CustomerName; ToBeInsertedCustomer.EconomicalNumber = customer.EconomicalNumber; ToBeInsertedCustomer.Active = customer.Active; ToBeInsertedCustomer.CustomerField_ID = customer.CustomerField_ID; ToBeInsertedCustomer.Email = customer.Email; ToBeInsertedCustomer.FaxNo = customer.FaxNo; ToBeInsertedCustomer.MobileNo = customer.MobileNo; ToBeInsertedCustomer.NationalID = customer.NationalID; ToBeInsertedCustomer.PostalCode = customer.PostalCode; ToBeInsertedCustomer.RegistrationNumber = customer.RegistrationNumber; ToBeInsertedCustomer.SubscriptionCode = r.ToString(); ToBeInsertedCustomer.TelNo = customer.TelNo; ToBeInsertedCustomer.LastUpdateDate = customer.LastUpdateDate; ToBeInsertedCustomer.LastUpdateTime = customer.LastUpdateTime; ToBeInsertedCustomer.LastUpdateUser_ID = customer.LastUpdateUser_ID; _context.Tbl_Customer.Add(ToBeInsertedCustomer); _context.SaveChanges(); return(ToBeInsertedCustomer.Customer_ID); } catch (Exception ex) { return(0); } }
public async Task <ActionResult <Tbl_Customer> > CreateCustomer(Tbl_Customer tbl_Customer) { var result = await _customerService.AddCustomerAsync(tbl_Customer); return(CreatedAtAction("GetCustomer", new { id = result.id }, result)); }
public ActionResult InsertCustomer(CustomerModel model, string returnurl) { HttpSessionStateBase session = HttpContext.Session; try { if (model.Customer_ID == 0) { // update process Tbl_Customer tg = new Tbl_Customer(); tg.Address = model.Address; tg.CompanyRegistrationName = model.CompanyRegistrationName; tg.CustomerConnector = model.CustomerConnector; tg.CustomerField_ID = model.CustomerField_ID; tg.CustomerName = model.CustomerName; tg.EconomicalNumber = model.EconomicalNumber; tg.Email = model.Email; tg.FaxNo = model.FaxNo; tg.MobileNo = model.MobileNo; tg.NationalID = model.NationalID; tg.PostalCode = model.PostalCode; tg.RegistrationNumber = model.RegistrationNumber; tg.SubscriptionCode = model.SubscriptionCode; tg.TelNo = model.TelNo; tg.Active = model.IsActive_ID; tg.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]); tg.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd"); tg.LastUpdateTime = DateTime.Now.ToString("HH:mm"); int res = _customerService.AddNewCustomer(tg, model.Customer_ID, model.IsActive_ID, model.CustomerField_ID); if (res > 0) { var gridModel = new DataSourceResult { ExtraData = new CustomerListModel { Message = Message.OperationSuccessful, Customer_ID = res, SubscriptionCode = _customerService.GetCustomerById(res).SubscriptionCode, MessageColor = "green", }, Total = 1 }; return(Json(gridModel)); } else { var gridModel = new DataSourceResult { ExtraData = new CustomerListModel { Message = Message.OperationUnsuccessful, MessageColor = "red", }, Total = 1 }; return(Json(gridModel)); } } else { var gridModel = new DataSourceResult { ExtraData = new CustomerListModel { Message = Message.OperationUnsuccessful, MessageColor = "red", }, Total = 1 }; return(Json(gridModel)); } } catch (Exception ex) { var gridModel = new DataSourceResult { ExtraData = new CustomerListModel { Message = Message.OperationUnsuccessful, MessageColor = "red", }, Total = 1 }; return(Json(gridModel)); } }