private async Task <bool> UpdateEntity(Database.Customer entity, CustomerUpdateRequest request) { if (request.AreaId != 0) { entity.AreaId = request.AreaId; } if (request.Address != null) { entity.Address = request.Address; } if (request.CompanyName != null) { entity.CompanyName = request.CompanyName; } if (request.Email != null) { entity.Account.Email = request.Email; } if (request.PhoneNumber != null) { entity.Account.PhoneNumber = request.PhoneNumber; } if (request.Username != null) { entity.Account.Username = request.Username; } await _context.SaveChangesAsync(); return(true); }
protected void btnUpdate_Click(object sender, EventArgs e) { try { string CustomerID = hdnCustomerID.Value; if (!string.IsNullOrEmpty(CustomerID)) { int customerID = Convert.ToInt32(CustomerID); if (customerID > 0) { var CustomerObj = context.Customers.Where(x => x.CustomerID == customerID); if (CustomerObj.Count() > 0) { var customerCollection = context.Customers.Where(x => x.IsActive == true && x.CustomerName == txtCustomerName.Text && x.CustomerMobile == txtCustomerMobile.Text && x.CustomerID != customerID); if (customerCollection.Count() == 0) { Database.Customer customer = CustomerObj.FirstOrDefault(); customer.ModifiedBy = currentUserName; customer.ModifiedDate = DateTime.Now.Date; customer.CustomerAddress = txtCustomerAddress.Text; customer.CustomerMobile = txtCustomerMobile.Text; customer.CustomerName = txtCustomerName.Text; customer.CustomerEmail = txtEmail.Text; customer.IsActive = true; context.SaveChanges(); lblMessage.Text = "Customer Updated Successfully"; lblMessage.ForeColor = Color.Green; } else { lblMessage.Text = "Customer Already Exist Choose Diffrent Name Or Mobile"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer Not Found"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not Valid"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not in proper format"; lblMessage.ForeColor = Color.Red; } } catch (Exception ex) { Helper.LogError(ex); lblMessage.Text = "Something went Wrong kindly check log"; lblMessage.ForeColor = Color.Red; } }
public string CreateCustomer(Customer customer) { try { if (customer != null) { var res = _DbContext.Customers.Where(x => x.Email == customer.Email).FirstOrDefault(); if (res != null) { return("already"); } Database.Customer entity = new Database.Customer(); entity = AutoMapperConfig.CustomerMapper.Map <Database.Customer>(customer); _DbContext.Customers.Add(entity); _DbContext.SaveChanges(); return("created"); } return("null"); } catch (Exception ex) { return(ex.Message); } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { var customerCollection = context.Customers.Where(x => x.CustomerName == txtCustomerName.Text && x.CustomerMobile == txtCustomerMobile.Text && x.IsActive == true); if (customerCollection.Count() == 0) { Database.Customer customer = new Database.Customer(); customer.CreatedBy = currentUserName; customer.CreatedDate = DateTime.Now.Date; customer.CustomerAddress = txtCustomerAddress.Text; customer.CustomerMobile = txtCustomerMobile.Text; customer.CustomerName = txtCustomerName.Text; customer.CustomerEmail = txtEmail.Text; customer.IsActive = true; context.Customers.Add(customer); context.SaveChanges(); lblMessage.Text = "Customer Added Successfully"; lblMessage.ForeColor = Color.Green; ClearForm(); } else { lblMessage.Text = "Customer Already exist with same name and Mobile"; lblMessage.ForeColor = Color.Red; } } catch (Exception ex) { Helper.LogError(ex); lblMessage.Text = "Something went Wrong kindly check log"; lblMessage.ForeColor = Color.Red; } }
public string createCustomer(CustomerVM model) { try { if (model != null) { Database.Customer entity = new Database.Customer(); entity.Name = model.Name; entity.Address = model.Address; //entity.lo = model.Locality; entity.EmailId = model.EmailId; entity.MobileNo = model.MobileNo; entity.City = model.City; entity.State = model.State; entity.Password = model.Password; entity.Zipcode = model.Zipcode; _dbContext.Customers.Add(entity); _dbContext.SaveChanges(); return(""); } } catch (Exception ex) { return(ex.Message); } return(""); }
// POST: api/Unicorn public string Post(DTO obj) { var s = "r"; var db = new Database.Customer(); //db.Save(obj.FirstName, obj.LastName, obj.Nationality, obj.Age); return("done"); }
public Customers getCustomer(int CustomerId) { Database.Customer entity = new Database.Customer(); entity = dbcontext.Customers.Find(CustomerId); var config = new MapperConfiguration(cfg => cfg.CreateMap <Database.Customer, Customers>()); var mapper = new Mapper(config); Customers customer = mapper.Map <Customers>(entity); return(customer); }
public string DeleteCustomer(int CustomerId) { Database.Customer entity = new Database.Customer(); entity = dbcontext.Customers.Find(CustomerId); if (entity != null) { dbcontext.Customers.Remove(entity); dbcontext.SaveChanges(); return("Successfully Deleted"); } return("null"); }
protected void ddlBillNo_SelectedIndexChanged(object sender, EventArgs e) { try { if (ddlBillNo.SelectedValue != "0") { string orderType = ddlOrderType.SelectedValue; panelDetail.Visible = true; divPersonName.Visible = true; divmobile.Visible = true; //For Sale Order if (orderType == "1") { int saleOrderID = Convert.ToInt32(ddlBillNo.SelectedValue); var saleOrderCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == saleOrderID); if (saleOrderCollection.Count() > 0) { Database.SalesOrder saleOrder = saleOrderCollection.FirstOrDefault(); Database.Customer customer = context.Customers.Where(x => x.IsActive == true && x.CustomerID == saleOrder.CustomerID).SingleOrDefault(); txtMobile.Text = customer.CustomerMobile; txtPersonOrgName.Text = customer.CustomerName; txtRemainingAmt.Text = Convert.ToString(saleOrder.RemainingAmount); divSeller.Visible = false; } } //For Purchase Order if (orderType == "2") { int purchaseOrderID = Convert.ToInt32(ddlBillNo.SelectedValue); var purchaseOrderCollection = context.InventoryOrders.Where(x => x.IsActive == true && x.InventoryOrderID == purchaseOrderID); if (purchaseOrderCollection.Count() > 0) { Database.InventoryOrder invOrder = purchaseOrderCollection.FirstOrDefault(); Database.Seller seller = context.Sellers.Where(x => x.IsActive == true && x.SellerID == invOrder.SellerID).SingleOrDefault(); txtMobile.Text = seller.SellerMobile; txtPersonOrgName.Text = seller.SellerName; txtRemainingAmt.Text = Convert.ToString(invOrder.BalanceAmount); divcustomer.Visible = false; } } } } catch (Exception ex) { Helper.LogError(ex); lblMessage.Text = "Something went Wrong kindly check log"; lblMessage.ForeColor = Color.Red; } }
public Customer GetCustomer(int id) { Customer customer; Database.Customer entity = _DbContext.Customers.Find(id); if (entity != null) { customer = AutoMapperConfig.CustomerMapper.Map <Customer>(entity); } else { customer = new Customer(); } return(customer); }
public async Task <Model.Models.Customer> Insert(CustomerInsertRequest request) { if (request.Password != request.PasswordConfirm) { throw new UserException("Lozinke moraju biti iste"); } var salt = AccountService.GenerateSalt(); var hash = AccountService.GenerateHash(salt, request.Password); // Adding account for customer Database.Account customerAccount = new Database.Account() { DateCreated = DateTime.Now, Email = request.Email, PasswordSalt = salt, PasswordHash = hash, PhoneNumber = request.PhoneNumber, Username = request.Username }; await _context.Account.AddAsync(customerAccount); await _context.SaveChangesAsync(); // Adding customer var result = await _context.Account .Where(x => x.PasswordSalt == salt) .SingleOrDefaultAsync(); var accountId = result.Id; Database.Customer customer = new Database.Customer() { AccountId = accountId, Address = request.Address, AreaId = request.AreaId, CompanyName = request.CompanyName }; _context.Customer.Add(customer); _context.SaveChanges(); return(_mapper.Map <Model.Models.Customer>(customer)); }
public void FillForm() { try { string CustomerIDObj = Request.QueryString[Constants.queryCustomerID]; if (!string.IsNullOrEmpty(CustomerIDObj)) { int CustomerID = Convert.ToInt32(CustomerIDObj); if (CustomerID > 0) { var CustomerCollection = context.Customers.Where(x => x.IsActive == true && x.CustomerID == CustomerID); if (CustomerCollection.Count() > 0) { Database.Customer customer = CustomerCollection.FirstOrDefault(); txtCustomerAddress.Text = customer.CustomerAddress; txtCustomerMobile.Text = customer.CustomerMobile; txtCustomerName.Text = customer.CustomerName; txtEmail.Text = customer.CustomerEmail; hdnCustomerID.Value = Convert.ToString(customer.CustomerID); } else { lblMessage.Text = "Customer Not Found"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not Valid"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not in right format"; lblMessage.ForeColor = Color.Red; } } catch { throw; } }
protected void btnPopupAddCustomer_Click(object sender, EventArgs e) { try { var customerCollection = context.Customers.Where(x => x.CustomerName == txtPopupCustomerName.Text && x.CustomerMobile == txtPopupCustomerMobile.Text && x.IsActive == true); if (customerCollection.Count() == 0) { Database.Customer customer = new Database.Customer(); customer.CreatedBy = currentUserName; customer.CreatedDate = DateTime.Now.Date; customer.CustomerMobile = txtPopupCustomerMobile.Text; customer.CustomerName = txtPopupCustomerName.Text; customer.CustomerEmail = txtPopupEmail.Text; customer.IsActive = true; context.Customers.Add(customer); context.SaveChanges(); txtPopupCustomerMobile.Text = ""; txtPopupCustomerName.Text = ""; txtPopupEmail.Text = ""; ClearPopup(); txtAutoCustomerName.Text = customer.CustomerName; txtCustomerID.Text = Convert.ToString(customer.CustomerID); divAddCustomerScript.Visible = false; } else { lblPopupCustomerResult.Text = "Customer Already exist with same name and Mobile"; lblPopupCustomerResult.ForeColor = Color.Red; divAddCustomerScript.Visible = true; } } catch (Exception ex) { Helper.LogError(ex); lblPopupCustomerResult.Text = "Something went Wrong kindly check log"; lblPopupCustomerResult.ForeColor = Color.Red; divAddCustomerScript.Visible = true; } }
public string Post(Database.Customer entity) { if (entity != null) { if (entity != new Database.Customer()) { Logic.CustomerManager manager = new Logic.CustomerManager(new Database.CustomerDemoContext(config)); if (manager.AddUpdate(entity)) { return("{\"UpdateStatus\":\"COMPLETE\"}"); } else { return("{\"UpdateStatus\":\"FAIL\"}"); } } } return("{\"UpdateStatus\":\"INVALID\"}"); }
private Database.Customer CustomerToDbCustomer(Customer cust) { if (cust == null) return null; Database.Customer dbCust = new Database.Customer(); // Database.Customer.CreateCustomer(cust.ID, cust.FirstName, cust.LastName); if (cust.FirstName == null) cust.FirstName = ""; if (cust.LastName == null) cust.LastName = ""; if (cust.EmailAddress == null) cust.EmailAddress = ""; if (cust.Password == null) cust.Password = ""; if (cust.Address == null) cust.Address = ""; if (cust.Address2 == null) cust.Address2 = ""; if (cust.City == null) cust.City = ""; if (cust.State == null) cust.State = ""; if (cust.ZIPCode == null) cust.ZIPCode = ""; if (cust.FacebookAccessToken == null) cust.FacebookAccessToken = ""; if (cust.FacebookExpires == null) cust.FacebookExpires = ""; if (cust.FacebookUserID == null) cust.FacebookUserID = ""; if (cust.BillingID == null) cust.BillingID = ""; if (cust.BillingType == null) cust.BillingType = 0; if (cust.AvatarURL == null) cust.AvatarURL = ""; dbCust.FirstName = cust.FirstName; dbCust.LastName = cust.LastName; dbCust.EmailAddress = cust.EmailAddress; dbCust.Password = cust.Password; dbCust.Address1 = cust.Address; dbCust.Address2 = cust.Address2; dbCust.City = cust.City; dbCust.State = cust.State; dbCust.ZIPCode = cust.ZIPCode; dbCust.FacebookAccessToken = cust.FacebookAccessToken; dbCust.FacebookExpires = cust.FacebookExpires; dbCust.FacebookUserID = cust.FacebookUserID; dbCust.BillingID = cust.BillingID; dbCust.BillingType = cust.BillingType; dbCust.AvatarURL = cust.AvatarURL; return dbCust; }
public string AddCustomer(Customers customer) { try { if (customer != null) { Database.Customer entity = new Database.Customer(); var config = new MapperConfiguration(cfg => cfg.CreateMap <Customers, Database.Customer>()); var mapper = new Mapper(config); entity = mapper.Map <Database.Customer>(customer); dbcontext.SaveChanges(); return("created"); } return("null"); } catch (Exception ex) { return(ex.Message); } }
/// <summary> </summary> /// <param name="invoiceAdd">this is a test</param> /// <returns></returns> /// <remarks> /// /// /// </remarks> public async Task <ICustomerView> CustomerAdd(ICustomerAdd customerAdd) { try { var result = new CustomerView(); using (var db = new InvoiceContext()) { var customer = new Database.Customer(); if (!db.Entitys.Any(w => w.EntityId == customerAdd.EntityId)) { return new CustomerView() { __CQRSSuccessful = false, __CQRSErrorMessage = "Unable to find parent for Entity", __CQRSStatusCode = 404 } } ; var entity = db.Entitys.First(w => w.EntityId == customerAdd.EntityId); if (entity.Customers == null) { entity.Customers = new List <Database.Customer>(); } entity.Customers.Add(customer); customer.Active = customerAdd.Active; if (customerAdd.Address == null) { customer.Address = new Address(); } else { customer.Address = new Address() { AddresLine2 = customerAdd.Address.AddresLine2, AddressExternalRef = customerAdd.Address.AddressExternalRef, AddressLine1 = customerAdd.Address.AddressLine1, AddressLine3 = customerAdd.Address.AddressLine3, City = customerAdd.Address.City, Country = customerAdd.Address.Country, PostZipCode = customerAdd.Address.PostZipCode, StateCounty = customerAdd.Address.StateCounty, }; } customer.CustomerExteranlRef = customerAdd.CustomerExteranlRef; customer.EmailAddress = customerAdd.EmalAddress; customer.IsCompany = customerAdd.IsCompany; customer.Name = customerAdd.Name; customer.PhoneNumber = customerAdd.PhoneNumber; customer.TaxNo = customerAdd.TaxNo; //UserCodeBlockStart-PreSave //UserCodeBlockEnd-PreSave await db.SaveChangesAsync(); result.Active = customer.Active; result.CustomerExteranlRef = customer.CustomerExteranlRef; result.CustomerId = customer.CustomerId; result.EmalAddress = customer.EmailAddress; result.EntityId = entity.EntityId; result.IsCompany = customer.IsCompany; result.Name = customer.Name; result.PhoneNumber = customer.PhoneNumber; result.TaxNo = customer.TaxNo; //UserCodeBlockStart-PreResult //UserCodeBlockEnd-PreResult return(result); } } catch (Exception e) { LogFactory.GetLogger().Log(LogLevel.Error, e); return(new CustomerView() { __CQRSSuccessful = false, __CQRSErrorMessage = "Unable to create CustomerView", __CQRSStatusCode = 500 }); } }
public void FillForm() { try { string SaleOrderIDObj = Request.QueryString[Constants.querySaleOrderID]; if (!string.IsNullOrEmpty(SaleOrderIDObj)) { int SaleOrderID = Convert.ToInt32(SaleOrderIDObj); if (SaleOrderID > 0) { var SaleCollection = context.SalesOrders.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID); if (SaleCollection.Count() > 0) { Database.SalesOrder saleOrder = SaleCollection.FirstOrDefault(); txtBalance.Text = Convert.ToString(saleOrder.RemainingAmount); txtBillNo.Text = saleOrder.BillNo; txtClass.Text = saleOrder.ClassName; txtCustomerID.Text = Convert.ToString(saleOrder.CustomerID); txtPaidAmount.Text = Convert.ToString(saleOrder.PaidAmount); txtRemarks.Text = saleOrder.Remarks; txtSellingDate.Text = saleOrder.SaleOrderDate == null ? "" : saleOrder.SaleOrderDate.Value.ToString(Constants.DateFormatDatePicker); txtTotalOrderAmount.Text = Convert.ToString(saleOrder.TotalCost); ddlCustomerType.SelectedValue = Convert.ToString(saleOrder.CustomerTypeID); chkIsComplete.Checked = saleOrder.IsCompleted == null ? false : Convert.ToBoolean(saleOrder.IsCompleted); chkIsMakingRequired.Checked = saleOrder.IsMakingRequired == null ? false : Convert.ToBoolean(saleOrder.IsMakingRequired); int?customerID = saleOrder.CustomerID; if (customerID != null) { var customerCollection = context.Customers.Where(x => x.CustomerID == customerID); if (customerCollection.Count() > 0) { Database.Customer customer = customerCollection.FirstOrDefault(); txtAutoCustomerName.Text = customer.CustomerName; } } if (saleOrder.IsMakingRequired == true) { var devWorkCollection = context.DevelopmentWorks.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID); if (devWorkCollection.Count() > 0) { Database.DevelopmentWork devWork = devWorkCollection.FirstOrDefault(); txtAutoMakingInventoryType.Text = Convert.ToString(devWork.InventoryTypeID); txtBottomMeasurement.Text = devWork.BottomMeasurement; txtConfirmDate.Text = devWork.ConfirmDate == null ? "" : devWork.ConfirmDate.Value.ToString(Constants.DateFormatDatePicker); txtDeliveryDate.Text = devWork.DeliveryDate == null ? "" : devWork.DeliveryDate.Value.ToString(Constants.DateFormatDatePicker); txtMakingCost.Text = Convert.ToString(devWork.MakingCost); txtMakingInventoryType.Text = Convert.ToString(devWork.InventoryTypeID); txtTopMeasurement.Text = devWork.TopMeasurement; ddlWorkType.SelectedValue = Convert.ToString(devWork.WorkTypeID); int?invTypeID = devWork.InventoryTypeID; if (invTypeID != null) { var invCollection = context.InventoryTypes.Where(x => x.InventoryTypeId == invTypeID); if (invCollection.Count() > 0) { Database.InventoryType inventory = invCollection.FirstOrDefault(); txtAutoMakingInventoryType.Text = inventory.InventoryTypeName; } } } else { //Nothing to Do } } var saleDetailCollection = context.SaleOrderDetails.Where(x => x.IsActive == true && x.SaleOrderID == SaleOrderID).AsEnumerable(); var data = from saleDetail in saleDetailCollection join inv in context.InventoryTypes.Where(x => x.IsActive == true).AsEnumerable() on saleDetail.InventoryTypeID equals inv.InventoryTypeId select new rptrClass { ItemCode = inv.InventoryCode, ItemID = inv.InventoryTypeId.ToString(), ItemName = inv.InventoryTypeName, Quantity = saleDetail.Quantity.ToString(), SellingRate = saleDetail.SellingRate.ToString(), TotalAmount = saleDetail.TotalAmount.ToString(), VAT = saleDetail.VAT, SaleOrderDetailID = saleDetail.SaleOrderDetailID }; rptrData.DataSource = data.ToList(); rptrData.DataBind(); hdnSaleOrderID.Value = Convert.ToString(SaleOrderID); } else { lblMessage.Text = "Customer Not Found"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not Valid"; lblMessage.ForeColor = Color.Red; } } else { lblMessage.Text = "Customer ID Not in right format"; lblMessage.ForeColor = Color.Red; } } catch { throw; } }