public IActionResult CreateCustomer(customerDetails customer) { _log4net.Info("New Customer Creation Initiated"); string token = TokenInfo.StringToken; client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", token); string data = JsonConvert.SerializeObject(customer); StringContent content = new StringContent(data, Encoding.UTF8, "application/json"); HttpResponseMessage response = client.PostAsync("https://localhost:44377/api/Customer/createCustomer", content).Result; if (response.IsSuccessStatusCode) { string data1 = response.Content.ReadAsStringAsync().Result; CustomerCreationStatus ob4 = JsonConvert.DeserializeObject <CustomerCreationStatus>(data1); if (ob4 != null) { return(RedirectToAction("CreationStatus", ob4)); } else { return(RedirectToAction("Error")); } } return(BadRequest()); }
//Send print notification to front-end : Avar protected internal void sendPrintNotifications(string customerID) { System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(); DataTable dtable = new DataTable(); OleDbCommand command = new OleDbCommand(); OleDbDataReader reader; connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=PrimaryDB.mdb"; command.Connection = connection; connection.Open(); string query = "SELECT * from Customers where [ID] =" + customerID; command.CommandText = query; reader = command.ExecuteReader(); customerDetails details = new customerDetails(); if (reader.HasRows) { while (reader.Read()) { if (reader["ID"].ToString() == customerID) { details.fname = reader["CustomerFirstName"].ToString(); } } reader.Close(); } connection.Close(); }
public customerDetails getCustomerDetails(int customerId) { var ob = new customerDetails(); return(customers.Where(c => c.customerId == customerId).FirstOrDefault()); // var x = customers.Find(x => x.customerId == customerId); // return x; }
public static int addCustomerDetails(customerDetails customer) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@customerId", customer.customerId)); parameter.Add(new KeyValuePair <string, object>("@customerName", customer.customerName)); parameter.Add(new KeyValuePair <string, object>("@customerAddress", customer.customerAddress)); parameter.Add(new KeyValuePair <string, object>("@CustomerGSTNo", customer.CustomerGSTNo)); parameter.Add(new KeyValuePair <string, object>("@isCustomerRetailer", customer.isCustomerRetailer)); parameter.Add(new KeyValuePair <string, object>("@DOB", customer.DOB)); parameter.Add(new KeyValuePair <string, object>("@genderId", customer.genderId)); parameter.Add(new KeyValuePair <string, object>("@villageId", customer.villageId)); parameter.Add(new KeyValuePair <string, object>("@customerMobileNo", customer.customerMobileNo)); parameter.Add(new KeyValuePair <string, object>("@MobileTwo", customer.MobileTwo)); parameter.Add(new KeyValuePair <string, object>("@MobileThree", customer.MobileThree)); parameter.Add(new KeyValuePair <string, object>("@emailId", customer.emailId)); parameter.Add(new KeyValuePair <string, object>("@contactPerson", customer.contactPerson)); parameter.Add(new KeyValuePair <string, object>("@contactNo", customer.contactNo)); parameter.Add(new KeyValuePair <string, object>("@isCreditDebit", customer.isCreditDebit)); parameter.Add(new KeyValuePair <string, object>("@openigBalanace", customer.openigBalanace)); parameter.Add(new KeyValuePair <string, object>("@OtherNote", customer.OtherNote)); parameter.Add(new KeyValuePair <string, object>("@adharNo", customer.adharNo)); if (customer.isCreditDebit == "जमा रक्कम") { customer.drAmount = customer.openigBalanace; customer.crAmount = 0; } if (customer.isCreditDebit == "नावे रक्कम") { customer.crAmount = customer.openigBalanace; customer.drAmount = 0; } parameter.Add(new KeyValuePair <string, object>("@billDate", customer.fromDate)); parameter.Add(new KeyValuePair <string, object>("@crAmount", customer.crAmount)); parameter.Add(new KeyValuePair <string, object>("@drAmount", customer.drAmount)); parameter.Add(new KeyValuePair <string, object>("@isActive", 1)); parameter.Add(new KeyValuePair <string, object>("@addedBy", customer.addedBy)); parameter.Add(new KeyValuePair <string, object>("@addedOn", customer.addedOn)); parameter.Add(new KeyValuePair <string, object>("@discount", customer.discount)); parameter.Add(new KeyValuePair <string, object>("@limitationAmount", customer.limitationAmount)); parameter.Add(new KeyValuePair <string, object>("@FinancialYearID", customer.FinancialYearID)); parameter.Add(new KeyValuePair <string, object>("@salesmanId", customer.SalesmanId)); parameter.Add(new KeyValuePair <string, object>("@pancardNo", customer.CustomerPANNo)); SqlHandler sqlH = new SqlHandler(); int i = sqlH.ExecuteNonQueryI("[dbo].[Usp_addCustomerDetails]", parameter); return(i); } catch (Exception ae) { throw ae; } }
public static int addCustomerDetails(customerDetails customer) { try { int i = customerProvider.addCustomerDetails(customer); return(i); } catch (Exception ex) { throw ex; } }
public IActionResult createCustomer([FromBody] customerDetails customer) { _log4net.Info("Creation of customer is initiated"); try { var result = customerRepository.createCustomer(customer); if (result == null) { return(NotFound()); } _log4net.Info("New Customer account is created"); return(Ok(result)); } catch (Exception) { return(BadRequest()); } }
public static int addCustomerDetails(customerDetails customer) { try { List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >(); parameter.Add(new KeyValuePair <string, object>("@customerId", customer.customerId)); parameter.Add(new KeyValuePair <string, object>("@customerName", customer.customerName)); parameter.Add(new KeyValuePair <string, object>("@customerAddress", customer.customerAddress)); parameter.Add(new KeyValuePair <string, object>("@DOB", customer.DOB)); parameter.Add(new KeyValuePair <string, object>("@genderId", customer.genderId)); parameter.Add(new KeyValuePair <string, object>("@villageId", customer.villageId)); parameter.Add(new KeyValuePair <string, object>("@customerMobileNo", customer.customerMobileNo)); parameter.Add(new KeyValuePair <string, object>("@alterNateCustomerMobileNo", customer.alterNateCustomerMobileNo)); parameter.Add(new KeyValuePair <string, object>("@emailId", customer.emailId)); parameter.Add(new KeyValuePair <string, object>("@contactPerson", customer.contactPerson)); parameter.Add(new KeyValuePair <string, object>("@contactPersonMobileNo", customer.contactPersonMobileNo)); parameter.Add(new KeyValuePair <string, object>("@isCreditDebit", customer.isCreditDebit)); parameter.Add(new KeyValuePair <string, object>("@openigBalanace", customer.openigBalanace)); if (customer.isCreditDebit == "जमा रक्कम") { customer.crAmount = customer.openigBalanace; customer.drAmount = 0; } if (customer.isCreditDebit == "नावे रक्कम") { customer.drAmount = customer.openigBalanace; customer.crAmount = 0; } parameter.Add(new KeyValuePair <string, object>("@crAmount", customer.crAmount)); parameter.Add(new KeyValuePair <string, object>("@drAmount", customer.drAmount)); parameter.Add(new KeyValuePair <string, object>("@orjId", customer.orjId)); parameter.Add(new KeyValuePair <string, object>("@isActive", 1)); parameter.Add(new KeyValuePair <string, object>("@addedBy", customer.addedBy)); parameter.Add(new KeyValuePair <string, object>("@addedOn", customer.addedOn)); SqlHandler sqlH = new SqlHandler(); int i = sqlH.ExecuteNonQueryI("[dbo].[Usp_addCustomerDetails]", parameter); return(i); } catch (Exception ae) { throw ae; } }
public CustomerCreationStatus createCustomer(customerDetails customer) { customers.Add(customer); string JsonData = JsonConvert.SerializeObject(customer.customerId); StringContent content = new StringContent(JsonData, Encoding.UTF8, "application/json"); HttpResponseMessage response = client.PostAsync(client.BaseAddress + "/createAccount/", content).Result; if (response.IsSuccessStatusCode) { string responseData = response.Content.ReadAsStringAsync().Result; customerAccount createStatus = JsonConvert.DeserializeObject <customerAccount>(responseData); var result = new CustomerCreationStatus(); result.customerId = customer.customerId; result.Message = "Success. Current and Savings account also created"; result.currentAccountId = createStatus.currentAccountId; result.savingsAccountId = createStatus.savingsAccountId; return(result); } return(null); }
private void btnSave_Click(object sender, EventArgs e) { try { customerDetails customers = new customerDetails(); if (txtCustomerName.Text == string.Empty) { if (Utility.Langn == "English") { MessageBox.Show("Please Add Customer name ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("कृपया ग्राहकाचे नाव भरा ...!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } txtCustomerName.Focus(); return; } if (cmbVillage.SelectedIndex == 0) { if (Utility.Langn == "English") { MessageBox.Show(" Please add or select village name ..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show(" कृपया गावाचे नाव भरा किंवा निवडा ..!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } cmbVillage.Focus(); return; } if (cmbCustomerRetailer.Text == "") { if (Utility.Langn == "English") { MessageBox.Show("Please Select Customer /Retailer!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("कृपया ग्राहक/ कीरकोळ विक्रेता निवडा !", "त्रुटी", MessageBoxButtons.OK, MessageBoxIcon.Warning); } cmbCustomerRetailer.Focus(); return; } if (txtOpeningBalance.Text == string.Empty) { txtOpeningBalance.Text = "0"; } customers.customerId = customerId; customers.customerName = txtCustomerName.Text.Trim(); customers.SalesmanId = Convert.ToInt64(cmbSalesmanName.SelectedValue); customers.CustomerGSTNo = txtGSTNo.Text.Trim(); customers.CustomerPANNo = txtpancardno.Text.Trim(); customers.isCustomerRetailer = cmbCustomerRetailer.SelectedItem.ToString(); customers.customerAddress = txtAdd1.Text.Trim(); if (txtMobileNo.Text == string.Empty) { customers.customerMobileNo = ""; } else { customers.customerMobileNo = Utility.ParseValueI(txtMobileNo.Text).ToString(); } if (txtMobileTwo.Text == string.Empty) { customers.MobileTwo = ""; } else { customers.MobileTwo = Utility.ParseValueI(txtMobileTwo.Text).ToString(); } if (txtMobileThree.Text == string.Empty) { customers.MobileThree = ""; } else { customers.MobileThree = Utility.ParseValueI(txtMobileThree.Text).ToString(); } customers.DOB = dtpDOB.Value; customers.genderId = cmbGender.Text; string vi = cmbVillage.Text; if (cmbVillage.SelectedValue == null) { int i = villageDetailsController.addVillageDetails(0, cmbVillage.Text); BindComboBoxVillageDetails(); cmbVillage.Text = vi; } customers.villageId = Convert.ToInt32(cmbVillage.SelectedValue); customers.emailId = txtEmailID.Text.Trim(); customers.OtherNote = txtOtherIformation.Text.Trim(); customers.addedOn = Utility.firstDate; if (txtDiscount.Text == string.Empty) { customers.discount = 0.0; } else { customers.discount = Utility.ParseValue(txtDiscount.Text); } if (txtlimitationAmount.Text == string.Empty) { customers.limitationAmount = 0.0; } else { customers.limitationAmount = Utility.ParseValue(txtlimitationAmount.Text); } if (txtOpeningBalance.Text == string.Empty) { customers.openigBalanace = 0; } else { customers.openigBalanace = Utility.ParseValue(txtOpeningBalance.Text); } customers.fromDate = dateBill.Value; customers.isCreditDebit = cmbCreditDebit.Text; customers.contactPerson = txtContactPerson.Text; customers.contactNo = txtContactPersonMobileno.Text; customers.adharNo = txtAdharNo.Text.Trim(); customers.addedBy = Utility.LoginID; customers.FinancialYearID = Utility.FinancilaYearId; if (customers.customerId > 0) { DialogResult ShowReport = DialogResult.No; if (Utility.Langn == "English") { ShowReport = MessageBox.Show("Do you want to update....?", "", MessageBoxButtons.YesNo); } else { ShowReport = MessageBox.Show("तु्म्हाला अपडेट करायचं का ....?", "", MessageBoxButtons.YesNo); } if (ShowReport == DialogResult.Yes) { int i = customerController.addCustomerDetails(customers); if (i > 0) { if (Utility.Langn == "English") { MessageBox.Show("Information saved successfully ..!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("माहिती यशस्वीरित्या साठवली गेली ..!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } btnnew_Click(sender, e); } if (i < 0) { if (Utility.Langn == "English") { MessageBox.Show("Customer Name already exists in list..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("ग्राहकाचे नाव आधीच उपलब्ध आहे ..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } else { ShowReport = DialogResult.No; btnnew_Click(sender, e); } } else { int i = customerController.addCustomerDetails(customers); if (i > 0) { if (Utility.Langn == "English") { MessageBox.Show("Information saved successfully ..!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("माहिती यशस्वीरित्या साठवली गेली ..!", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information); } btnnew_Click(sender, e); } if (i < 0) { if (Utility.Langn == "English") { MessageBox.Show("Customer Name already exists in list..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { MessageBox.Show("ग्राहकाचे नाव आधीच उपलब्ध आहे ..!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }