public static void AddShortageDetail(ShortageDetails sd) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); SqlCommand command; connection.Open(); try { command = connection.CreateCommand(); command.CommandText = "INSERT INTO UnileverInvoiceTrackingSystem.dbo.shortagedetails (invoiceno, shortagedetails) VALUES (@IN,@SD);"; command.Parameters.AddWithValue("@IN", Convert.ToInt64(sd.InvoiceNo)); command.Parameters.AddWithValue("@SD", sd.SD); command.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Close(); } } }
protected void InvoiceRecordButton_Click(object sender, EventArgs e) { DateTime duedate; duedate = Convert.ToDateTime(InvoiceDateTextBox.Text); duedate = duedate.AddDays(40); InvoiceDetail invoiceentry = new InvoiceDetail(); InvoicePayment invoicepayment = new InvoicePayment(); ShortageDetails shortagedetail = new ShortageDetails(); invoiceentry.InvoiceNo = Convert.ToInt64(InvoiceNoTextBox.Text); invoiceentry.InvoiceTerritory = getterritory(); invoiceentry.InvoiceRegion = InvoiceRegionDropDownList.SelectedValue; invoiceentry.InvoiceDate = Convert.ToDateTime(InvoiceDateTextBox.Text).Date; invoiceentry.InvoiceDueDate = duedate.Date; invoiceentry.InvoiceAging = Convert.ToInt32((DateTime.Now.Date - Convert.ToDateTime(InvoiceDateTextBox.Text).Date).TotalDays); invoiceentry.NPA = Convert.ToDecimal(NetAmountTextBox.Text); invoiceentry.SC = ShortageCommentsDropDownList.SelectedValue; InvoiceDetailHandler.AddInvoiceDetail(invoiceentry); invoicepayment.InvoiceNo = Convert.ToInt64(InvoiceNoTextBox.Text); invoicepayment.PaymentStatus = "Non-Paid"; invoicepayment.AmountReceived = Convert.ToDecimal("0.00"); invoicepayment.Balance = Convert.ToDecimal("0.00"); invoicepayment.PaymentRemarks = "Under Progress"; InvoicePaymentHandler.AddInvoicePayment(invoicepayment); shortagedetail.InvoiceNo = Convert.ToInt64(InvoiceNoTextBox.Text); shortagedetail.SD = ShortageDetailsTextBox.Text; ShortageDetailHandler.AddShortageDetail(shortagedetail); cleardata(); }