private void saveButton_Click(object sender, EventArgs e) { try { DBManager manager6 = new DBManager(); SqlConnection connection6 = manager6.Connection(); string selectQuery6 = "insert into Due_Collection values(@pay,@empty,@payCollection,@date)"; SqlCommand cmd6 = new SqlCommand(selectQuery6, connection6); connection6.Open() ; cmd6.Parameters.Clear(); cmd6.Parameters.Add("@pay", "0"); cmd6.Parameters.Add("@empty", totalDuetextBox.Text); cmd6.Parameters.AddWithValue("@payCollection", "0"); cmd6.Parameters.Add("@date", DateTime.Now.ToShortDateString()); cmd6.ExecuteNonQuery(); connection6.Close(); RecordDue aRecordDue = new RecordDue(); aRecordDue.Name = cnameTextBox.Text; aRecordDue.Mobile = cMobileTextBox.Text; aRecordDue.Fbook = Convert.ToDouble(forBooktextBox.Text); aRecordDue.Fcopy = Convert.ToDouble(forphotocopytextBox.Text); aRecordDue.Fothers = Convert.ToDouble(forOThersTextBox.Text); aRecordDue.PreviousDue = Convert.ToDouble(previousDueTextBox.Text); RecordDueGateway gateway = new RecordDueGateway(); gateway.SaveDueRecord(aRecordDue); listView1.Items.Clear(); LoadAllBook(); GetAllDueRecord(); TempDueRecord aRecord=new TempDueRecord(); aRecord.CoustemerName = cnameTextBox.Text; aRecord.Mobile = cMobileTextBox.Text; aRecord.ForBook = Convert.ToDouble(forBooktextBox.Text); aRecord.ForCopy = Convert.ToDouble(forphotocopytextBox.Text); aRecord.ForOthers = Convert.ToDouble(forOThersTextBox.Text); aRecord.Total = Convert.ToDouble(totalDuetextBox.Text); if (previousDueTextBox.Text.Equals("")||previousDueTextBox.Text.Equals("0")) { aRecord.PreviousDue = 0; } else { aRecord.PreviousDue = Convert.ToDouble(previousDueTextBox.Text ); } aRecord.MemoNumber = memoNumver; TempDueRecordGateway DueRecordGateway=new TempDueRecordGateway(); DueRecordGateway.SaveTempDueRecord(aRecord); //DueReportUI dueReportUi=new DueReportUI(cnameTextBox.Text,cMobileTextBox.Text,forBooktextBox.Text,forphotocopytextBox.Text,forOThersTextBox.Text,totalDuetextBox.Text); //dueReportUi.ShowDialog(); //listView1.Items.Clear(); //LoadAllBook(); //ClearALLTextbox(); } catch (NullReferenceException exception) { MessageBox.Show("Please fill every fields properly. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void saveButton_Click(object sender, EventArgs e) { try { RecordDue aRecordDue = new RecordDue(); aRecordDue.Name = cnameTextBox.Text; aRecordDue.Mobile = cMobileTextBox.Text; aRecordDue.Fbook = Convert.ToDouble(forBooktextBox.Text); aRecordDue.Fcopy = Convert.ToDouble(forphotocopytextBox.Text); aRecordDue.Fothers = Convert.ToDouble(forOThersTextBox.Text); RecordDueGateway gateway = new RecordDueGateway(); gateway.SaveDueRecord(aRecordDue); listView1.Items.Clear(); LoadAllBook(); ClearALLTextbox(); } catch (FormatException) { MessageBox.Show("Please fill every fields properly. ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }