public void LoadByPK(string id) { string sSql = "SELECT * FROM [Ledger] WHERE sLedgerId = @id"; using (SqlCommand cmd = new SqlCommand(sSql, LocalAccess.l_Connection)) { cmd.Parameters.Add(new SqlParameter("id", id)); DataTable dt = new DataTable(); using (SqlDataAdapter adp = new SqlDataAdapter(cmd)) adp.Fill(dt); if (dt.Rows.Count > 0) { this.sLedgerId = "" + dt.Rows[0]["sLedgerId"]; this.sCompanyCode = "" + dt.Rows[0]["sCompanyCode"]; this.dtLedgerDate = Convert.ToDateTime(dt.Rows[0]["dtLedgerDate"]); this.sLedgerDocu = "" + dt.Rows[0]["sLedgerDocu"]; this.sLedgerDesc = "" + dt.Rows[0]["sLedgerDesc"]; this.LedgerRef = "" + dt.Rows[0]["sLedgerRef"]; dtls = new List <LedgerDtlBL>(); sSql = "SELECT * FROM [LedgerDtl] WHERE sLedgerId = @id"; using (SqlCommand cmd2 = new SqlCommand(sSql, LocalAccess.l_Connection)) { cmd2.Parameters.Add(new SqlParameter("id", id)); DataTable dt2 = new DataTable(); using (SqlDataAdapter adp = new SqlDataAdapter(cmd2)) adp.Fill(dt2); foreach (DataRow dr2 in dt2.Rows) { LedgerDtlBL dtl = new LedgerDtlBL(); dtl.LedgerId = "" + dr2["sLedgerId"]; dtl.AccountCode = "" + dr2["sAccountCode"]; dtl.LedgerDescription = "" + dr2["sLedgerDescription"]; dtl.LedgerDebit = Convert.ToDouble(dr2["nLedgerDebit"]); dtl.LedgerCredit = Convert.ToDouble(dr2["nLedgerCredit"]); dtl.LedgerAmount = Convert.ToDouble(dr2["nLedgerAmount"]); dtls.Add(dtl); } } } else { this.sLedgerId = ""; this.sCompanyCode = ""; this.dtLedgerDate = new DateTime(1900, 1, 1); this.sLedgerDocu = ""; this.sLedgerDesc = ""; this.LedgerRef = ""; dtls = new List <LedgerDtlBL>(); } } }
private void btnAdd_Click(object sender, EventArgs e) { if (!ValidateEntry()) { return; } Layer.LedgerBL BL = new Layer.LedgerBL(); if (this._IsAdd) { BL.LedgerId = DateTime.Now.ToString("yyyyMMddHHmmss"); } else { BL.LedgerId = this.sLedgerId; } BL.CompanyCode = LocalAccess.l_CompanyCode; BL.LedgerDate = Convert.ToDateTime(txtDate.Text); BL.LedgerDocu = txtDocu.Text.Trim(); BL.LedgerDesc = txtDesc.Text.Trim(); BL.LedgerRef = txtRef.Text.Trim(); BL.dtls = new List <Layer.LedgerDtlBL>(); foreach (DataGridViewRow dr in grdDetail.Rows) { if (dr.IsNewRow) { continue; } Layer.LedgerDtlBL dtl = new Layer.LedgerDtlBL(); dtl.LedgerId = BL.LedgerId; dtl.AccountCode = "" + dr.Cells["cAccount"].Value; dtl.LedgerDescription = "" + dr.Cells["cDescription"].Value; dtl.LedgerDebit = 0; dtl.LedgerCredit = 0; dtl.LedgerAmount = 0; try { dtl.LedgerDebit = Convert.ToDouble(dr.Cells["cDebit"].Value); } catch { } try { dtl.LedgerCredit = Convert.ToDouble(dr.Cells["cCredit"].Value); } catch { } try { dtl.LedgerAmount = Convert.ToDouble(dr.Cells["cAmount"].Value); } catch { } BL.dtls.Add(dtl); } if (this._IsAdd) { if (BL.Exist()) { MessageBox.Show("Document already exist.", "Add Ledger"); return; } BL.Insert(); frmList.LoadEntry(); //FormNew(); txtDate.Focus(); LoadDescriptionList(); MessageBox.Show("Record Saved"); } else { BL.UpdateByPK(); this.Close(); frmList.LoadEntry(); } }