private void btnOK_Click(object sender, EventArgs e) { if (txtDate.Text.Trim() == "") { MessageBox.Show("Please input daily report date.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtDate.SelectAll(); txtDate.Focus(); return; } if (txtPOSCardSettlement.Text.Trim() == "") { MessageBox.Show("Please input POS card settlement amount.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtPOSCardSettlement.SelectAll(); txtPOSCardSettlement.Focus(); return; } if (CashDeposit > 0) { if (txtCashDepositDate.Text.Trim() == "") { MessageBox.Show("Please input cash deposit date.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCashDepositDate.SelectAll(); txtCashDepositDate.Focus(); return; } else { CashDepositDate = txtCashDepositDate.Text.Trim(); } } if (txtCashDepositDate.Text.Trim() != "") { if (CashDeposit == 0) { MessageBox.Show("Please input cash deposit amount.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtCashDepositDate.SelectAll(); txtCashDepositDate.Focus(); return; } } try { if (CashDeposit > 0) { cmd = new SqlCommand(sp_WithDeposit, parentForm1.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DSRStoreCode", SqlDbType.NVarChar).Value = parentForm1.StoreCode.ToUpper(); cmd.Parameters.Add("@DSRDate", SqlDbType.DateTime).Value = txtDate.Text.Trim(); cmd.Parameters.Add("@DSRDay", SqlDbType.NVarChar).Value = lblDay.Text.Trim(); cmd.Parameters.Add("@DSRPOSCardAmt", SqlDbType.Money).Value = POSCardPayment; cmd.Parameters.Add("@DSRSettleCardAmt", SqlDbType.Money).Value = POSCardSettlement; cmd.Parameters.Add("@DSRCardDiff", SqlDbType.Money).Value = CardPaymentDiff; cmd.Parameters.Add("@DSRPOSCashAmt", SqlDbType.Money).Value = POSCashPayment; cmd.Parameters.Add("@DSRSettleCashAmt", SqlDbType.Money).Value = POSCashSettlement; cmd.Parameters.Add("@DSRCashDiff", SqlDbType.Money).Value = CashPaymentdiff; cmd.Parameters.Add("@DSRCashWithdrawal", SqlDbType.Money).Value = CashWithdrawal; cmd.Parameters.Add("@DSRCashDepositAmt", SqlDbType.Money).Value = CashDeposit; cmd.Parameters.Add("@DSRCashDepositDate", SqlDbType.DateTime).Value = CashDepositDate; cmd.Parameters.Add("@DSRCashDepositInputDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@DSRCashInSafe", SqlDbType.Money).Value = NewCashBalance; cmd.Parameters.Add("@DSRCreateDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@DSRCreateID", SqlDbType.NVarChar).Value = parentForm1.employeeID.ToUpper(); cmd.Parameters.Add("@DSRNote", SqlDbType.NVarChar).Value = richTxtNote.Text.Trim(); cmd.Parameters.Add("@DSRType", SqlDbType.NVarChar).Value = "DAILY REPORT"; cmd.Parameters.Add("@DSRDeleted", SqlDbType.Bit).Value = false; parentForm1.conn.Open(); cmd.ExecuteNonQuery(); parentForm1.conn.Close(); } else { cmd = new SqlCommand(sp_WithoutDeposit, parentForm1.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DSRStoreCode", SqlDbType.NVarChar).Value = parentForm1.StoreCode.ToUpper(); cmd.Parameters.Add("@DSRDate", SqlDbType.DateTime).Value = txtDate.Text.Trim(); cmd.Parameters.Add("@DSRDay", SqlDbType.NVarChar).Value = lblDay.Text.Trim(); cmd.Parameters.Add("@DSRPOSCardAmt", SqlDbType.Money).Value = POSCardPayment; cmd.Parameters.Add("@DSRSettleCardAmt", SqlDbType.Money).Value = POSCardSettlement; cmd.Parameters.Add("@DSRCardDiff", SqlDbType.Money).Value = CardPaymentDiff; cmd.Parameters.Add("@DSRPOSCashAmt", SqlDbType.Money).Value = POSCashPayment; cmd.Parameters.Add("@DSRSettleCashAmt", SqlDbType.Money).Value = POSCashSettlement; cmd.Parameters.Add("@DSRCashDiff", SqlDbType.Money).Value = CashPaymentdiff; cmd.Parameters.Add("@DSRCashWithdrawal", SqlDbType.Money).Value = CashWithdrawal; //cmd.Parameters.Add("@DSRCashDepositAmt", SqlDbType.Money).Value = CashDeposit; //cmd.Parameters.Add("@DSRCashDepositDate", SqlDbType.DateTime).Value = CashDepositDate; //cmd.Parameters.Add("@DSRCashDepositInputDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@DSRCashInSafe", SqlDbType.Money).Value = CashInSafe + CashWithdrawal; cmd.Parameters.Add("@DSRCreateDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@DSRCreateID", SqlDbType.NVarChar).Value = parentForm1.employeeID.ToUpper(); cmd.Parameters.Add("@DSRNote", SqlDbType.NVarChar).Value = richTxtNote.Text.Trim(); cmd.Parameters.Add("@DSRType", SqlDbType.NVarChar).Value = "DAILY REPORT"; cmd.Parameters.Add("@DSRDeleted", SqlDbType.Bit).Value = false; parentForm1.conn.Open(); cmd.ExecuteNonQuery(); parentForm1.conn.Close(); } MessageBox.Show("Successfully created.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); parentForm2.btnSettlementReportOK_Click(null, null); } catch { MessageBox.Show("DB connection error.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); if (parentForm1.conn.State == ConnectionState.Open) { parentForm1.conn.Close(); } return; } }
private void btnOK_Click(object sender, EventArgs e) { if (txtDate.Text.Trim() == "") { MessageBox.Show("Please input date.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtDate.Select(); txtDate.Focus(); return; } if (txtAmount.Text.Trim() == "") { MessageBox.Show("Please input amount.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtAmount.Select(); txtAmount.Focus(); return; } if (double.TryParse(txtAmount.Text.Trim(), out DSRCashInSafe)) { if (DSRCashInSafe < 0) { MessageBox.Show("Invalid amount.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtAmount.SelectAll(); txtAmount.Focus(); return; } try { DSRNote = richTxtNote.Text.Trim().ToString(); cmd = new SqlCommand("Create_CashInSafe", parentForm1.conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DSRStoreCode", SqlDbType.NVarChar).Value = parentForm1.StoreCode.ToUpper(); cmd.Parameters.Add("@DSRDate", SqlDbType.DateTime).Value = txtDate.Text.Trim(); cmd.Parameters.Add("@DSRDay", SqlDbType.NVarChar).Value = lblDay.Text.Trim(); cmd.Parameters.Add("@DSRCashInSafe", SqlDbType.Money).Value = DSRCashInSafe; cmd.Parameters.Add("@DSRCreateDate", SqlDbType.DateTime).Value = DateTime.Now; cmd.Parameters.Add("@DSRCreateID", SqlDbType.NVarChar).Value = parentForm1.employeeID.ToUpper(); cmd.Parameters.Add("@DSRType", SqlDbType.NVarChar).Value = DSRType; cmd.Parameters.Add("@DSRNote", SqlDbType.NVarChar).Value = DSRNote; cmd.Parameters.Add("@DSRDeleted", SqlDbType.Bit).Value = false; parentForm1.conn.Open(); cmd.ExecuteNonQuery(); parentForm1.conn.Close(); MessageBox.Show("Successfully created.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); parentForm2.btnSettlementReportOK_Click(null, null); } catch { MessageBox.Show("DB connection error.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); if (parentForm1.conn.State == ConnectionState.Open) { parentForm1.conn.Close(); } txtAmount.SelectAll(); txtAmount.Focus(); return; } } else { MessageBox.Show("Invalid amount.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtAmount.SelectAll(); txtAmount.Focus(); return; } }