public bool SaveCustomerBillInformation(CustomerBillInformation aBillInformation) { string query = "INSERT INTO BillInformation VALUES('" + aBillInformation.BillNumber + "','" + aBillInformation.BillStatus + "'," + aBillInformation.DueDate + ",'" + aBillInformation.CustomerMobileNumber + "'," + aBillInformation.TotalBillAmount + ");"; Command.CommandText = query; Connection.Open(); var rowsAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowsAffected > 0); }
public void SaveTotalBillAmount() { Random aRandom = new Random(); CustomerBillInformation aBillInformation = new CustomerBillInformation(); aBillInformation.BillNumber = string.Format("#" + DateTime.Now.ToString() + "BILL_{0}", aRandom.Next(100, 10000)); aBillInformation.BillStatus = "Unpaid"; aBillInformation.TotalBillAmount = Convert.ToDouble(totalTextBox.Text); aBillInformation.DueDate = "GetDate()"; aBillInformation.CustomerMobileNumber = mobileNumberTextBox.Text; entrySaveMessageLabel.Text = _aTestReuestManager.SaveCustomerBillInformation(aBillInformation); GeneratePdf(); }
public string SaveCustomerBillInformation(CustomerBillInformation aBillInformation) { return(_aTestRequestGateway.SaveCustomerBillInformation(aBillInformation)? "Saved BillInformation":"Save Failed BillInformation"); }