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;
}
}
