private void btnNew_Click(object sender, EventArgs e) { //mClear(); frmMpoCommManualList objfrm = new frmMpoCommManualList(); objfrm.onAddAllButtonClicked = new frmMpoCommManualList.AddAllClick(DisplayVoucherList); objfrm.lngFormPriv = lngFormPriv; objfrm.Show(); objfrm.MdiParent = this.MdiParent; }
private void btnSave_Click(object sender, EventArgs e) { string strmsg = "", strkey = "", strBranchID = "", strSQL = ""; string connstring = Utility.SQLConnstringComSwitch(strComID); double dblAmount = 0; DataTable dt1 = new DataTable(); dt1.Columns.Add(new DataColumn("Key")); dt1.Columns.Add(new DataColumn("MonthId")); dt1.Columns.Add(new DataColumn("BranhID")); dt1.Columns.Add(new DataColumn("LedgerName")); dt1.Columns.Add(new DataColumn("Headname")); dt1.Columns.Add(new DataColumn("Amount")); dt1.Columns.Add(new DataColumn("col")); dt1.Columns.Add(new DataColumn("row")); if (m_action == 1) { if (chkStatus.Checked) { strmsg = Utility.mCheckManual(strComID, strMonthID + "A"); } else { strmsg = Utility.mCheckManual(strComID, strMonthID + "I"); } if (strmsg != "") { MessageBox.Show(strmsg); return; } } if (Utility.gblnAccessControl) { if (!Utility.glngGetPriviliges(strComID, Utility.gstrUserName, lngFormPriv, m_action)) { MessageBox.Show("You have no Permission to Access", "Privileges", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } var strResponseInsert = MessageBox.Show("Do You want to Save?", "Save Button", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (strResponseInsert == DialogResult.Yes) { try { strBranchID = lstBranch.SelectedValue.ToString(); if (chkStatus.Checked) { strkey = uctxtMonthID.Text + strBranchID + "A"; } else { strkey = uctxtMonthID.Text + strBranchID + "I"; } strmsg = "1"; if (strmsg == "1") { for (int intcol = 2; intcol <= DG.Columns.Count - 1; intcol++) { string strHead = DG.Columns[intcol].HeaderText; for (int i = 0; i < DG.Rows.Count; i++) { if (DG[intcol, i].Value != null) { dblAmount = Convert.ToDouble(DG[intcol, i].Value.ToString()); } else { dblAmount = 0; } dt1.Rows.Add(strkey, uctxtMonthID.Text, strBranchID, DG[1, i].Value.ToString(), strHead, dblAmount, intcol, i); //strmsg = accms.mInsertMpoManual(strComID, strkey, uctxtMonthID.Text, strBranchID, DG[1, i].Value.ToString(), strHead, dblAmount, 0, intcol, i); } } if (dt1.Rows.Count > 0) { //strmsg = objWois.mInsertMpoManual(strComID, strkey, uctxtMonthID.Text, strBranchID, "", "", 0, 1, 0, 0, dt1); using (SqlConnection gcnMain = new SqlConnection(connstring)) { if (gcnMain.State == ConnectionState.Open) { gcnMain.Close(); } gcnMain.Open(); SqlCommand cmdInsert = new SqlCommand(); SqlTransaction myTrans; myTrans = gcnMain.BeginTransaction(); cmdInsert.Connection = gcnMain; cmdInsert.Transaction = myTrans; strSQL = "DELETE FROM MPO_COMM_MAN_PARENT_CHILD "; strSQL = strSQL + " WHERE "; strSQL = strSQL + " COMM_MANUAL_KEY ='" + strkey.Replace("'", "''") + "' "; cmdInsert.CommandText = strSQL; cmdInsert.ExecuteNonQuery(); strSQL = "DELETE FROM MPO_COMM_MAN_PARENT "; strSQL = strSQL + " WHERE "; strSQL = strSQL + " COMM_MANUAL_KEY ='" + strkey.Replace("'", "''") + "' "; cmdInsert.CommandText = strSQL; cmdInsert.ExecuteNonQuery(); strSQL = "INSERT INTO MPO_COMM_MAN_PARENT(COMM_MANUAL_KEY,MONTH_ID,BRANCH_ID)"; strSQL = strSQL + "VALUES("; strSQL = strSQL + "'" + strkey.Replace("'", "''") + "' "; strSQL = strSQL + ",'" + strMonthID.Replace("'", "''") + "' "; strSQL = strSQL + ",'" + strBranchID.Replace("'", "''") + "' "; strSQL = strSQL + ")"; cmdInsert.CommandText = strSQL; cmdInsert.ExecuteNonQuery(); if (dt1.Rows.Count > 0) { progressBar1.Value = 0; progressBar1.Maximum = dt1.Rows.Count; foreach (DataRow dr in dt1.Rows) { strSQL = "INSERT INTO MPO_COMM_MAN_PARENT_CHILD(COMM_MANUAL_KEY,LEDGER_NAME,HEAD_NAME,AMOUNT,COLS,ROWPOS)"; strSQL = strSQL + "VALUES("; strSQL = strSQL + "'" + strkey.Replace("'", "''") + "' "; strSQL = strSQL + ",'" + dr["LedgerName"].ToString().Replace("'", "''") + "' "; strSQL = strSQL + ",'" + dr["Headname"].ToString().Replace("'", "''") + "' "; strSQL = strSQL + "," + Utility.Val(dr["Amount"].ToString()) + " "; strSQL = strSQL + "," + Utility.Val(dr["col"].ToString()) + " "; strSQL = strSQL + "," + Utility.Val(dr["row"].ToString()) + " "; strSQL = strSQL + ")"; cmdInsert.CommandText = strSQL; cmdInsert.ExecuteNonQuery(); progressBar1.Value += 1; } } cmdInsert.Transaction.Commit(); } } if (strmsg == "1") { if (Utility.gblnAccessControl) { string strAudit = Utility.gblnAuditTrail(Utility.gstrUserName, DateTime.Now.ToString("dd/MM/yyyy"), "Draft MPO Commsiion", strkey, m_action, 0, (int)Utility.MODULE_TYPE.mtACCOUNT, "0001"); } MessageBox.Show("Record Saved.."); progressBar1.Value = 0; chkStatus.Enabled = true; if (m_action == 2) { m_action = 1; this.Hide(); frmMpoCommManualList objfrm = new frmMpoCommManualList(); objfrm.onAddAllButtonClicked = new frmMpoCommManualList.AddAllClick(DisplayVoucherList); objfrm.lngFormPriv = lngFormPriv; objfrm.Show(); objfrm.MdiParent = this.MdiParent; } } } } catch (Exception EX) { MessageBox.Show(EX.ToString()); } } }