public IHttpActionResult post([FromBody] ledger ledgers) { try { if (string.IsNullOrEmpty(ledgers.name)) { ModelState.AddModelError("name", "Name is Required"); } if (ModelState.IsValid) { using (Count10_DevEntities entities = new Count10_DevEntities()) { ledgers.system = ledgers.system.HasValue ? ledgers.system : false; ledgers.managed = ledgers.managed.HasValue ? ledgers.managed : false; ledgers.active = ledgers.active.HasValue ? ledgers.active : true; ledgers.archived = ledgers.archived.HasValue ? ledgers.archived : false; ledgers.updated_by = ledgers.updated_by.HasValue ? ledgers.updated_by : 1; ledgers.created_by = ledgers.created_by.HasValue ? ledgers.created_by : 1; ledgers.created_at = DateTime.Now; ledgers.updated_at = DateTime.Now; entities.ledgers.Add(ledgers); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, ledgers); } return(Ok(ledgers)); } return(BadRequest(ModelState)); } catch (Exception) { return(BadRequest(ModelState)); } }
private List <ledger> getLedgerDetails() { ledger ldg = new ledger(); List <ledger> VDetails = new List <ledger>(); try { for (int i = 0; i < grdList.Rows.Count - 2; i++) { ldg = new ledger(); ldg.DocumentID = grdList.Rows[i].Cells["gDocumentID"].Value.ToString(); ldg.VoucherNo = Convert.ToInt32(grdList.Rows[i].Cells["VoucherNo"].Value.ToString()); ldg.VoucherDate = Convert.ToDateTime(grdList.Rows[i].Cells["VoucherDate"].Value); ldg.TransactionACName = grdList.Rows[i].Cells["TransactionACName"].Value.ToString(); ldg.Narration = grdList.Rows[i].Cells["Narration"].Value.ToString(); ldg.DebitAmnt = Convert.ToDecimal(grdList.Rows[i].Cells["DrAmt"].Value.ToString()); ldg.CreditAmnt = Convert.ToDecimal(grdList.Rows[i].Cells["CrAmt"].Value); VDetails.Add(ldg); } } catch (Exception EX) { } return(VDetails); }
public override global::System.Data.DataSet Clone() { ledger cln = ((ledger)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
private void grdRadioSelectWiseList_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } string columnName = grdRadioSelectWiseList.Columns[e.ColumnIndex].Name; try { if (columnName.Equals("Details") && e.RowIndex != grdRadioSelectWiseList.Rows.Count - 1) { grdRadioSelectWiseList.Rows[rowIndex].DefaultCellStyle.BackColor = c; c = grdRadioSelectWiseList.Rows[e.RowIndex].DefaultCellStyle.BackColor; grdRadioSelectWiseList.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.CornflowerBlue; rowIndex = e.RowIndex; btnClose2ndGrid.Visible = true; grdDocumentWiseList.Visible = true; int opt; ledger ldg = new ledger(); string HText = grdRadioSelectWiseList.Columns["SelectedType"].HeaderText; if (HText.Equals("Account Code")) { opt = 1; //string str = grdRadioSelectWiseList.Rows[e.RowIndex].Cells["SelectedType"].Value.ToString(); ldg.AccountCode = grdRadioSelectWiseList.Rows[e.RowIndex].Cells["SelectedType"].Value.ToString(); ldg.AccountName = grdRadioSelectWiseList.Rows[e.RowIndex].Cells["SelectedName"].Value.ToString(); } else if (HText.Equals("Party Code")) { opt = 2; //string str = grdRadioSelectWiseList.Rows[e.RowIndex].Cells["SelectedType"].Value.ToString(); ldg.SLCode = grdRadioSelectWiseList.Rows[e.RowIndex].Cells["SelectedType"].Value.ToString(); ldg.SLName = grdRadioSelectWiseList.Rows[e.RowIndex].Cells["SelectedName"].Value.ToString(); } else { opt = 3; string str = grdRadioSelectWiseList.Rows[e.RowIndex].Cells["SelectedType"].Value.ToString(); str = Utilities.convertDateStringToAnsi(str); ldg.VoucherDate = Convert.ToDateTime(str); ////DateTime tDate = Convert.ToDateTime("30-01-2018",); ////DateTime tDate = DateTime.ParseExact("2018-01-30 00:00:00", "yyyy-MM-dd HH:mm", null); //ldg.VoucherDate = DateTime.Parse(str); } List <ledger> ledgList = ReceiptAndPaymentDB.getDocumentWiseDetail(ldg, opt, dtFromDate.Value, dtToDate.Value); btnDocWiseExportToExcel.Visible = true; showDocumentWiseDetailGrid(ledgList); } } catch (Exception ex) { MessageBox.Show("grdRadioSelectWiseList_CellContentClick() : Error - " + ex.ToString()); } }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { ledger ds = new ledger(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public static List <ledger> gFillSalesLedger(long vlngSLedgerType = 0, long vlngPLedgerType = 0, long vlngCash = 0) { string strSQL; List <ledger> ooStr = new List <ledger>(); using (SqlConnection gcnmain = new SqlConnection(Utility.SQLConnstring())) { if (gcnmain.State == System.Data.ConnectionState.Open) { gcnmain.Close(); } try { gcnmain.Open(); SqlDataReader dr; SqlCommand cmd = new SqlCommand(); strSQL = "SELECT LEDGER_NAME FROM ACC_LEDGER "; if (vlngSLedgerType != 0) { strSQL = strSQL + "WHERE LEDGER_GROUP = " + vlngSLedgerType + " "; strSQL = strSQL + "AND LEDGER_STATUS = 0 "; } strSQL = strSQL + "ORDER BY LEDGER_NAME"; cmd.Connection = gcnmain; cmd.CommandText = strSQL; dr = cmd.ExecuteReader(); while (dr.Read()) { ledger ostr = new ledger(); ostr.LedgerName = dr["LEDGER_NAME"].ToString(); ooStr.Add(ostr); } dr.Close(); return(ooStr); } finally { gcnmain.Close(); } } }
private List <ledger> getLedgerDetails() { ledger ldg = new ledger(); List <ledger> VDetails = new List <ledger>(); try { for (int i = 0; i < grdRadioSelectWiseList.Rows.Count - 2; i++) { ldg = new ledger(); ldg.DocumentID = grdRadioSelectWiseList.Rows[i].Cells["SelectedType"].Value.ToString(); // For Storing Selected Type of radio button ldg.DebitAmnt = Convert.ToDecimal(grdRadioSelectWiseList.Rows[i].Cells["Payment"].Value.ToString()); ldg.CreditAmnt = Convert.ToDecimal(grdRadioSelectWiseList.Rows[i].Cells["Receipt"].Value); VDetails.Add(ldg); } } catch (Exception EX) { } return(VDetails); }
private List <ledger> getLedgerDetails() { ledger ldg = new ledger(); List <ledger> VDetails = new List <ledger>(); try { for (int i = 0; i < grdTrialBalance.Rows.Count - 1; i++) { ldg = new ledger(); ldg.AccountCode = grdTrialBalance.Rows[i].Cells["AccountCode"].Value.ToString(); ldg.AccountName = grdTrialBalance.Rows[i].Cells["AccountName"].Value.ToString(); ldg.DebitAmnt = Convert.ToDecimal(grdTrialBalance.Rows[i].Cells["DrAmt"].Value.ToString()); ldg.CreditAmnt = Convert.ToDecimal(grdTrialBalance.Rows[i].Cells["CrAmt"].Value); VDetails.Add(ldg); } } catch (Exception EX) { } return(VDetails); }
private List <ledger> getDocumetnWiseLedgerDetails() { ledger ldg = new ledger(); List <ledger> VDetails = new List <ledger>(); try { for (int i = 0; i < grdDocumentWiseList.Rows.Count - 2; i++) { ldg = new ledger(); ldg.VoucherNo = Convert.ToInt32(grdDocumentWiseList.Rows[i].Cells["VoucherNo"].Value.ToString()); ldg.VoucherDate = Convert.ToDateTime(grdDocumentWiseList.Rows[i].Cells["VoucherDate"].Value.ToString()); ldg.Narration = grdDocumentWiseList.Rows[i].Cells["VoucherType"].Value.ToString(); // For Storing Voucher Type ldg.DebitAmnt = Convert.ToDecimal(grdDocumentWiseList.Rows[i].Cells["gPayment"].Value.ToString()); ldg.CreditAmnt = Convert.ToDecimal(grdDocumentWiseList.Rows[i].Cells["gReceipt"].Value); VDetails.Add(ldg); } } catch (Exception EX) { } return(VDetails); }
public HttpResponseMessage put(int id, [FromBody] ledger ledgers) { try { using (Count10_DevEntities entities = new Count10_DevEntities()) { var entity = entities.ledgers.FirstOrDefault(e => e.id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Ledger with Id = " + id.ToString() + " not found to edit")); } else { entity.name = ledgers.name; entity.alt_name = ledgers.alt_name; entity.parent_id = ledgers.parent_id; entity.chart_of_account_id = ledgers.chart_of_account_id; entity.organization_id = ledgers.organization_id; entity.cost_centre_id = ledgers.cost_centre_id; entity.currency_id = ledgers.currency_id; entity.position = ledgers.position; entity.opening_balance = ledgers.opening_balance; entity.opening_cr_dr = ledgers.opening_cr_dr; entity.current_balance = ledgers.current_balance; entity.current_cr_dr = ledgers.current_cr_dr; entity.notes = ledgers.notes; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
private void btnVieDetails_Click(object sender, EventArgs e) { //-------- try { if (cmbFYID.SelectedIndex == -1) { MessageBox.Show("Select Financial Year"); return; } string[] str = cmbFYID.SelectedItem.ToString().Split(':'); string s = str[0]; string ss = str[1]; string sss = str[2]; DateTime FYstartDate = Convert.ToDateTime(ss.Trim()); DateTime FYEndDate = Convert.ToDateTime(sss.Trim()); if (dtFromDate.Value.Date < FYstartDate.Date || dtToDate.Value.Date > FYEndDate.Date || dtToDate.Value.Date < FYstartDate.Date || dtFromDate.Value.Date > FYEndDate.Date) { MessageBox.Show("Dates should be within the FY"); return; } if (dtFromDate.Value.Date > dtToDate.Value.Date) { MessageBox.Show("From / To Date mismatch"); return; } balance = ""; grdList.Visible = true; grdList.Rows.Clear(); btnExportToExcel.Visible = true; TxtSearchNamr.Text = ""; lblSearch.Visible = true; TxtSearchNamr.Visible = true; btnCancel.Visible = true; btnClose.PerformClick(); List <string> testList = new List <string>(); btnExportToExcel.Visible = true; // btnExportToPDF.Visible = true; btnCancel.Visible = true; LedgerDB ldb = new LedgerDB(); //get all OB for all account at FY start List <AccountOBdetail> accObList = AccountOBDB.getAccountOBListForPericualrFY(s); //10 rows //Accountwise debit total and credit total till from date List <ledger> ledgerListFromdt = LedgerDB.getAccountWiseDrCrTotTillFromDate(FYstartDate, dtFromDate.Value); //12rows foreach (ledger ldg in ledgerListFromdt) { AccountOBdetail accList = accObList.FirstOrDefault(acc => acc.AccountCode == ldg.AccountCode); if (accList == null) //If New Account found { AccountOBdetail accNew = new AccountOBdetail(); accNew.AccountCode = ldg.AccountCode; accNew.AccountName = ldg.AccountName; accNew.OBValue = (ldg.DebitAmnt - ldg.CreditAmnt); accObList.Add(accNew); testList.Add(ldg.AccountCode); } } foreach (AccountOBdetail acc in accObList) { ledger ldg = ledgerListFromdt.FirstOrDefault(ldger => ldger.AccountCode == acc.AccountCode); if (ldg != null && !testList.Contains(ldg.AccountCode)) { acc.OBValue = acc.OBValue + (ldg.DebitAmnt - ldg.CreditAmnt); //updating new ob value till from date } } List <ledger> ledgerListwithinperiod = LedgerDB.getAccountWiseDrCrTotWithinPeriod(dtFromDate.Value, dtToDate.Value); //List<ledger> LedgerList = ldb.getFilteredledger(FYstartDate, dtFromDate.Value, dtToDate.Value, txtBankAccountCode.Text); TotDrAmntBal = 0; TotCrAmntBal = 0; TotOBValue = 0; TotDebAmnt = 0; TotCredAmnt = 0; int i = 0; //List<AccountOBdetail> acclIst = accObList.OrderBy(acc => acc.AccountName).ToList(); foreach (AccountOBdetail acc in accObList) { i++; grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["SerialNo"].Value = grdList.RowCount; grdList.Rows[grdList.RowCount - 1].Cells["AccountCode"].Value = acc.AccountCode; grdList.Rows[grdList.RowCount - 1].Cells["AccountName"].Value = acc.AccountName; grdList.Rows[grdList.RowCount - 1].Cells["OpeningBalance"].Value = acc.OBValue; TotOBValue = TotOBValue + acc.OBValue; ledger ldgInPeriod = ledgerListwithinperiod.FirstOrDefault(ldgr => ldgr.AccountCode == acc.AccountCode); if (ldgInPeriod != null) { grdList.Rows[grdList.RowCount - 1].Cells["DebitAmount"].Value = ldgInPeriod.DebitAmnt; //withing period total debit amount grdList.Rows[grdList.RowCount - 1].Cells["CreditAmout"].Value = ldgInPeriod.CreditAmnt; ////withing period total credit amount TotDebAmnt = TotDebAmnt + ldgInPeriod.DebitAmnt; TotCredAmnt = TotCredAmnt + ldgInPeriod.CreditAmnt; grdList.Rows[grdList.RowCount - 1].Cells["gBalance"].Value = acc.OBValue + (ldgInPeriod.DebitAmnt - ldgInPeriod.CreditAmnt); } else { //No transaction found within time period grdList.Rows[grdList.RowCount - 1].Cells["DebitAmount"].Value = Convert.ToDecimal(0); grdList.Rows[grdList.RowCount - 1].Cells["CreditAmout"].Value = Convert.ToDecimal(0); grdList.Rows[grdList.RowCount - 1].Cells["gBalance"].Value = acc.OBValue; } decimal balancetst = Convert.ToDecimal(grdList.Rows[grdList.RowCount - 1].Cells["gBalance"].Value); if (balancetst > 0) { grdList.Rows[grdList.RowCount - 1].Cells["DebitBalance"].Value = balancetst; grdList.Rows[grdList.RowCount - 1].Cells["CreditBalance"].Value = Convert.ToDecimal(0); } else { grdList.Rows[grdList.RowCount - 1].Cells["CreditBalance"].Value = balancetst * (-1); grdList.Rows[grdList.RowCount - 1].Cells["DebitBalance"].Value = Convert.ToDecimal(0); } TotDrAmntBal = TotDrAmntBal + Convert.ToDecimal(grdList.Rows[grdList.RowCount - 1].Cells["DebitBalance"].Value); TotCrAmntBal = TotCrAmntBal + Convert.ToDecimal(grdList.Rows[grdList.RowCount - 1].Cells["CreditBalance"].Value); } foreach (ledger ldgrnew in ledgerListwithinperiod) { AccountOBdetail accList = accObList.FirstOrDefault(acc => acc.AccountCode == ldgrnew.AccountCode); if (accList == null) //If New Account found OB is nill { i++; grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["SerialNo"].Value = grdList.RowCount; grdList.Rows[grdList.RowCount - 1].Cells["AccountCode"].Value = ldgrnew.AccountCode; grdList.Rows[grdList.RowCount - 1].Cells["AccountName"].Value = ldgrnew.AccountName; grdList.Rows[grdList.RowCount - 1].Cells["OpeningBalance"].Value = Convert.ToDecimal(0); grdList.Rows[grdList.RowCount - 1].Cells["DebitAmount"].Value = ldgrnew.DebitAmnt; //withing period total debit amount grdList.Rows[grdList.RowCount - 1].Cells["CreditAmout"].Value = ldgrnew.CreditAmnt; ////withing period total credit amount //TotOBValue = TotOBValue + acc.OBValue; TotDebAmnt = TotDebAmnt + ldgrnew.DebitAmnt; TotCredAmnt = TotCredAmnt + ldgrnew.CreditAmnt; grdList.Rows[grdList.RowCount - 1].Cells["gBalance"].Value = (ldgrnew.DebitAmnt - ldgrnew.CreditAmnt); decimal balancetst = Convert.ToDecimal(grdList.Rows[grdList.RowCount - 1].Cells["gBalance"].Value); if (balancetst > 0) { grdList.Rows[grdList.RowCount - 1].Cells["DebitBalance"].Value = balancetst; grdList.Rows[grdList.RowCount - 1].Cells["CreditBalance"].Value = Convert.ToDecimal(0); } else { grdList.Rows[grdList.RowCount - 1].Cells["CreditBalance"].Value = balancetst * (-1); grdList.Rows[grdList.RowCount - 1].Cells["DebitBalance"].Value = Convert.ToDecimal(0); } TotDrAmntBal = TotDrAmntBal + Convert.ToDecimal(grdList.Rows[grdList.RowCount - 1].Cells["DebitBalance"].Value); TotCrAmntBal = TotCrAmntBal + Convert.ToDecimal(grdList.Rows[grdList.RowCount - 1].Cells["CreditBalance"].Value); } } if (i == grdList.Rows.Count) { grdList.Rows.Add(); grdList.Rows[grdList.RowCount - 1].Cells["AccountName"].Value = "Total"; grdList.Rows[grdList.RowCount - 1].Cells["OpeningBalance"].Value = TotOBValue; grdList.Rows[grdList.RowCount - 1].Cells["DebitAmount"].Value = TotDebAmnt; grdList.Rows[grdList.RowCount - 1].Cells["CreditAmout"].Value = TotCredAmnt; grdList.Rows[grdList.RowCount - 1].Cells["CreditBalance"].Value = TotCrAmntBal < 0 ? TotCrAmntBal * (-1) : TotCrAmntBal; grdList.Rows[grdList.RowCount - 1].Cells["DebitBalance"].Value = TotDrAmntBal < 0 ? TotDrAmntBal * (-1) : TotDrAmntBal; } chktransacted.Checked = false; chktransacted.Checked = true; } catch (Exception ex) { MessageBox.Show("Check All "); } }