private void btnSave_Click(object sender, EventArgs e)
{
string strSQl = string.Empty;
objData = new SQLDB();
int recCnt = 0;
try
{
if (CheckData())
{
recCnt = CreateDocMonth();
if (recCnt > 0)
{
CommonData.DocMonth = dtpMonth.Value.ToString("MMMyyyy").ToUpper();
CommonData.DocFDate = dtpFromDate.Value.ToString("dd/MM/yyyy");
CommonData.DocFDate = dtpTodate.Value.ToString("dd/MM/yyyy");
MDIParent mdi = new MDIParent();
mdi.statusStrip.Items[0].Text = "USER: "******" : " + CommonData.DocMonth.ToString();
mdi.statusStrip.Items["dmFromDate"].Text = " From: " + CommonData.DocFDate.ToString();
mdi.statusStrip.Items["dmToDate"].Text = " To: " + CommonData.DocTDate.ToString();
mdi.Refresh();
mdi = null;
}
else
{
strSQl = " UPDATE document_month set status = 'R'" +
" WHERE company_code = '" + CommonData.CompanyCode +
"' AND fin_year = '" + CommonData.FinancialYear +
"' AND UPPER(document_month) = '" + CommonData.DocMonth + "'";
recCnt = objData.ExecuteSaveData(strSQl);
strSQl = " DELETE FROM document_month WHERE company_code='" + CommonData.CompanyCode +
"' AND fin_year='" + CommonData.FinancialYear +
"' AND UPPER(document_month)='" + dtpMonth.Value.ToString("MMMyyyy").ToUpper() + "' ";
recCnt = objData.ExecuteSaveData(strSQl);
//strSQl = " DELETE FROM LevelGroup_map WHERE lgm_company_code ='" + CommonData.CompanyCode +
// "' AND UPPER(lgm_branch_code) ='" + CommonData.BranchCode +
// "' AND UPPER(lgm_doc_month) ='" + dtpMonth.Value.ToString("MMMyyyy").ToUpper() + "' ";
//recCnt = objData.ExecuteSaveData(strSQl);
//strSQl = " DELETE FROM LevelsSource_Dest_map " +
// " WHERE UPPER(lsdm_company_code) = '" + CommonData.CompanyCode +
// "' AND UPPER(lsdm_branch_code) = '" + CommonData.BranchCode +
// "' AND UPPER(lsdm_doc_month) = '" + CommonData.DocMonth + "'";
//recCnt = objData.ExecuteSaveData(strSQl);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Document Month", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
objData = null;
}
