public CustomerMatchInfoDetails GetCustomerMatchDetails(int customerId, SuppressionOptions suppressionOptions) { CustomerMatchInfoDetails customerMatchInfoDetails = new CustomerMatchInfoDetails(); KeyValuePair <string, string> keyValuePair = new KeyValuePair <string, string>("PKEY", customerId.ToString()); CustomerInfoDetails customerInfo = _customerDetailsDataAccess.GetCustomerDetails(keyValuePair, AddressType.Correspondence, suppressionOptions); var keys = _customerDetailsDataAccess.GetCustomerAllIndexKeys("PKEY", customerId.ToString(), "All"); customerMatchInfoDetails.Title = customerInfo.Title; customerMatchInfoDetails.FirstName = customerInfo.FirstName; customerMatchInfoDetails.Surname = customerInfo.Surname; customerMatchInfoDetails.Dob = customerInfo.Dob; customerMatchInfoDetails.EmailAddress = customerInfo.Email; customerMatchInfoDetails.Homephone = customerInfo.HomePhone; customerMatchInfoDetails.MobilePhone = customerInfo.MobilePhone; customerMatchInfoDetails.SmsPhone = customerInfo.SmsPhone; customerMatchInfoDetails.Address = customerInfo.FullAddress; customerMatchInfoDetails.Postcode = ((CorrespondenceAddress)customerInfo.Address).Postcode; var firstOrDefault = keys.FirstOrDefault(x => x.SourceKey == "NUME"); if (firstOrDefault != null) { customerMatchInfoDetails.NumeroId = firstOrDefault.Keys; } var customerIndexResult = keys.FirstOrDefault(x => x.SourceKey == "TARS"); if (customerIndexResult != null) { customerMatchInfoDetails.TaurusId = customerIndexResult.Keys; } return(customerMatchInfoDetails); }
public void SellerEntry(string billNo, decimal sumTotal, CustomerInfoDetails custInfo) { var database = new InventoryEntities(); var billTypeIDList = (from c in database.BillTypes where c.BillTypeName == "Cash" select new { c.BillTypeID }).FirstOrDefault(); var custInfoTable = new CustomerInfo(); var billInfoTable = new BillInfo(); custInfoTable.CustomerName = custInfo.custName; custInfoTable.CustomerAddress = custInfo.custAddress; custInfoTable.Mobile = custInfo.custMobile; custInfoTable.Email = custInfo.custEmail; database.CustomerInfoes.Add(custInfoTable); billInfoTable.BillNumber = billNo; billInfoTable.BillTypeID = billTypeIDList.BillTypeID;//Cash or Credit Bill billInfoTable.TotalAmount = sumTotal; billInfoTable.Discount = custInfo.custDiscount; billInfoTable.BillDate = custInfo.billDate; billInfoTable.UpdatedOn = DateTime.Now; billInfoTable.CustomerInfo = custInfoTable; //database.CustomerInfoes.Add(custInfoTable); database.BillInfoes.Add(billInfoTable); database.SaveChanges(); }
public void CallBackFromReport(string billno, CustomerBillData cusBill, CustomerInfoDetails custInfo, ProductSale prodSale) { //MessageBox.Show("Please enter First Name!" + billno); customerBillData = cusBill; customerInfoDetails = custInfo; ProductFinalSale(billno); prodSale.dataGridViewSale.Rows.Clear(); }
private void btnOK_Click(object sender, EventArgs e) { decimal discount; if (txtDiscount.Text.Trim() == "") { discount = 0; } else { discount = Convert.ToDecimal(txtDiscount.Text.Trim()); } if (txtCustomerName.Text.Trim() == "" || ControlValidation.IsReserveWord(txtCustomerName.Text.Trim().ToLower())) { lblError.Text = "Please Enter Customer Name"; lblError.ForeColor = Color.Red; } else { var custDetails = new CustomerInfoDetails(); if (txtAddress.Text == "" || ControlValidation.IsReserveWord(txtAddress.Text.Trim().ToLower())) { custDetails.custAddress = "XXXX"; } else { custDetails.custAddress = txtAddress.Text; } custDetails.custName = txtCustomerName.Text; custDetails.custMobile = "9999999999"; custDetails.custEmail = "*****@*****.**"; custDetails.billDate = dateTimeBillDate.Value.Date; custDetails.custDiscount = discount; this.Hide(); if (sellerEntry == 1) { this.Hide(); var stockEntry = new StockEntry(); stockEntry.CalllbackFromCustDetails(_glStockEntry, custDetails, _billnumber); this.Close(); } else { CustomerBillForm cust = new CustomerBillForm(productSale); cust.showBill(custBillInfoData, custDetails); cust.ShowDialog(this); this.Close(); } } }
public object Process(KeyValueParameter keyValueParameter) { KeyValueParameter _parameter = keyValueParameter; NoAccessToCustomerDetails message = new NoAccessToCustomerDetails(); if (_parameter.AccessControl.ModuleAccess.Find(x => x.HasAccess && x.Key == GroupCode.GCUST) == null) { message.Message = "You dont' have access for CustomerDetails data."; return(message); } CustomerInfoDetails customerInfoDetails = _customerDetailsService.GetCustomerDetail( new KeyValuePair <string, string>(_parameter.KeyValue.Key, _parameter.KeyValue.Value), _parameter.ReturnMe.CustomerDetails.AddressType.Value, _parameter.SuppressionOptions ); return(customerInfoDetails); }
public void showBill(CustomerBillData cusBill, CustomerInfoDetails custInfo) { customerBillData = cusBill; customerInfoDetails = custInfo; rs.Name = "DataSetCustBillProd"; rs.Value = cusBill.billData; _billNo = cusBill.billNo; this.reportViewerCustBill.LocalReport.DataSources.Clear(); this.reportViewerCustBill.LocalReport.DataSources.Add(rs); this.reportViewerCustBill.LocalReport.ReportEmbeddedResource = "RawForms.Reports.CustomerBill.rdlc"; rp.Add(new ReportParameter("gstNumber", cusBill.gstn)); rp.Add(new ReportParameter("custName", custInfo.custName)); rp.Add(new ReportParameter("custAddress", custInfo.custAddress)); rp.Add(new ReportParameter("billDate", custInfo.billDate.ToString("dd-MM-yyyy"))); rp.Add(new ReportParameter("billNumber", cusBill.billNo)); rp.Add(new ReportParameter("shopName", cusBill.shopName)); rp.Add(new ReportParameter("shopAddress", cusBill.shopAddress)); rp.Add(new ReportParameter("discount", custInfo.custDiscount.ToString())); this.reportViewerCustBill.LocalReport.SetParameters(rp); this.reportViewerCustBill.RefreshReport(); }
public void CalllbackFromCustDetails(StockEntry lcstockentry, CustomerInfoDetails custInfo, string billNo) { StockUpdate(lcstockentry); SellerEntry(billNo, lcstockentry._grandTotal, custInfo); }
public void ReportBuilder(string lclbillNo) { List <CustomerBillProduct> billProdList = new List <CustomerBillProduct>(); billProdList.Clear(); var billedItems = (from c in database.TransactionDetails join d in database.ProductInfoes on c.ProductID equals d.ProductID where c.BillNumber == lclbillNo select new { c.Quantity, c.UnitPrice, c.TotalPrice, d.Description }); var billingInfo = (from c in database.BillInfoes join d in database.CustomerInfoes on c.CustomerID equals d.CustomerID where c.BillNumber == lclbillNo select new { c.BillDate, c.Discount, c.TotalAmount, d.CustomerName, d.CustomerAddress, d.Mobile, d.Email, }).FirstOrDefault(); var shopInfo = (from c in database.ShopInfoes select c).FirstOrDefault(); string shopAddress = shopInfo.ShopAddress + " " + shopInfo.City + " " + shopInfo.Dist + " " + shopInfo.State + " " + shopInfo.ZIP + " Tel :" + shopInfo.PhoneNo; foreach (var row in billedItems) { var custBillProduct = new CustomerBillProduct { Productdesc = Convert.ToString(row.Description), Productprice = Convert.ToDecimal(row.UnitPrice), Productunit = Convert.ToDecimal(row.Quantity), Totalprice = Convert.ToDecimal(row.TotalPrice), }; billProdList.Add(custBillProduct); } var customerBillData = new CustomerBillData(); customerBillData.gstn = shopInfo.Gstn; customerBillData.shopName = shopInfo.ShopName; customerBillData.shopAddress = shopAddress; customerBillData.billNo = lclbillNo; customerBillData.billData = billProdList; var custDetails = new CustomerInfoDetails(); custDetails.custAddress = billingInfo.CustomerAddress; custDetails.custName = billingInfo.CustomerName; custDetails.custMobile = billingInfo.Mobile; custDetails.custEmail = billingInfo.Email; custDetails.billDate = (DateTime)billingInfo.BillDate; custDetails.custDiscount = Convert.ToDecimal(billingInfo.Discount); int printonlyBill = 1; var printBill = new CustomerBillForm(printonlyBill); printBill.showBill(customerBillData, custDetails); printBill.ShowDialog(this); }
public CustomerInfoDetails GetCustomerDetails(KeyValuePair <string, string> kvPair, AddressType addressType, SuppressionOptions suppressionOptions ) { CustomerInfoDetails infoDetails = new CustomerInfoDetails(); using (var conn = new SqlConnection(MciCrDbConnectionString)) { using (var cmd = new SqlCommand("[dbo].[GetCustomerDetails]", conn)) { try { cmd.Connection.Open(); cmd.Parameters.Add( new SqlParameter("@key", SqlDbType.VarChar, 4).SetSqlValue(kvPair.Key) ); var param1Value = ""; if (!string.IsNullOrWhiteSpace(kvPair.Key)) { if (kvPair.Key.Equals(SourceKey.ACTI.ToString(), StringComparison.OrdinalIgnoreCase) || kvPair.Key.Equals(SourceKey.MEMB.ToString(), StringComparison.OrdinalIgnoreCase)) { var value = kvPair.Value; if (value.Contains(" ")) { value = value.Replace(" ", "+"); } param1Value = HttpUtility.UrlEncode(value); } else { param1Value = kvPair.Value; } } else { param1Value = kvPair.Value; } cmd.Parameters.Add(new SqlParameter("@value", SqlDbType.VarChar, 40).SetSqlValue(param1Value)); cmd.Parameters.Add(new SqlParameter("@addressFormat", SqlDbType.VarChar, 15).SetSqlValue(addressType)); // Suppression parameter cmd.Parameters.Add( new SqlParameter("@ignoreSuppression", SqlDbType.Bit).SetSqlValue(suppressionOptions.IgnoreSuppression.ToInt()) ); if (!IsCustomerExists(kvPair.Key, kvPair.Value, "PKEY")) { return(null); } cmd.CommandType = CommandType.StoredProcedure; var table = new DataTable(); var adapter = new SqlDataAdapter(cmd); var affectedRows = adapter.Fill(table); if (affectedRows == 0) { return(null); } infoDetails = BuildCustomerDetails(table.Rows, addressType); } catch (SqlException ex) { _logger.Error("CustomerDetailsDataAccess: " + "ErrorTag: " + ErrorTagProvider.ErrorTagDatabase + " -- " + ex.Message, ex); throw new Exception(string.Format(DatabaseMessage.DatabaseException, ErrorTagProvider.ErrorTagDatabase)); } catch (Exception ex) { _logger.Error("CustomerDetailsDataAccess: " + "ErrorTag: " + ErrorTagProvider.ErrorTagDatabase + " -- " + ex.Message, ex); throw new Exception(string.Format(DatabaseMessage.DatabaseException, ErrorTagProvider.ErrorTagDatabase)); } } } return(infoDetails); }
private CustomerInfoDetails BuildCustomerDetails(DataRowCollection rows, AddressType addressType) { CustomerInfoDetails infoDetails = new CustomerInfoDetails(); try { foreach (DataRow row in rows) { infoDetails.Title = row["title"]?.ToString(); infoDetails.FirstName = row["first_name"]?.ToString(); infoDetails.Surname = row["surname"]?.ToString(); DateTime dateVal; var isValidDate = DateTime.TryParse(row["DOB"].ToString(), out dateVal); if (!isValidDate) { infoDetails.Dob = null; } else { infoDetails.Dob = dateVal; } infoDetails.Gender = row["gender"]?.ToString(); infoDetails.SupStatus = row["suppression_status"]?.ToString(); infoDetails.Suffix = row["suffix"]?.ToString(); if (addressType == AddressType.Correspondence) { var correspondance = new CorrespondenceAddress { Address1 = row["address1"]?.ToString(), Address2 = row["address2"]?.ToString(), Address3 = row["address3"]?.ToString(), Address4 = row["address4"]?.ToString(), Address5 = row["address5"]?.ToString(), Address6 = row["address6"]?.ToString(), Address7 = row["address7"]?.ToString(), Postcode = row["postcode"]?.ToString() }; infoDetails.Address = correspondance; } else if (addressType == AddressType.Transactional) { var transactional = new TransactionalAddress { HouseNumber = row["housenumber"]?.ToString(), HouseName = row["housename"]?.ToString(), Street = row["street"]?.ToString(), Street1 = row["street1"]?.ToString(), City = row["city"]?.ToString(), County = row["county"]?.ToString(), Postcode = row["postcode"]?.ToString(), }; infoDetails.Address = transactional; } // GN-36 Fix null salutation fields on KeyValuePair calls infoDetails.Salutation = row["salutation"]?.ToString(); infoDetails.AddressSalutation = row["address_salutation"]?.ToString(); infoDetails.EmploymentStatus = row["employment_status"]?.ToString(); infoDetails.Occupation = row["occupation"]?.ToString(); infoDetails.MaritialStatus = row["marital_status"]?.ToString(); infoDetails.Email = row["email_address"]?.ToString(); infoDetails.MobilePhone = row["mobile_phone"]?.ToString(); infoDetails.HomePhone = row["home_phone"]?.ToString(); infoDetails.WorkPhone = row["work_phone"]?.ToString(); infoDetails.SmsPhone = row["sms_number"]?.ToString(); infoDetails.FullAddress = row["full_address"]?.ToString(); } } catch (Exception ex) { _logger.Error("CustomerDetailsDataAccess - GetCustomerDetails : " + "ErrorTag: " + ErrorTagProvider.ErrorTagDatabase + " -- " + ex.Message, ex); throw new Exception(ex.Message); } return(infoDetails); }