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