Пример #1
0
        public IHttpActionResult PutPartyLedger(long id, PartyLedger partyLedger)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != partyLedger.ID)
            {
                return(BadRequest());
            }

            db.Entry(partyLedger).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!PartyLedgerExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Пример #2
0
        public IHttpActionResult GetPartyLedger(long id)
        {
            PartyLedger partyLedger = db.PartyLedgers.Find(id);

            if (partyLedger == null)
            {
                return(NotFound());
            }

            return(Ok(partyLedger));
        }
Пример #3
0
        public IHttpActionResult PostPartyLedger(PartyLedger partyLedger)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.PartyLedgers.Add(partyLedger);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = partyLedger.ID }, partyLedger));
        }
Пример #4
0
        public IHttpActionResult DeletePartyLedger(long id)
        {
            PartyLedger partyLedger = db.PartyLedgers.Find(id);

            if (partyLedger == null)
            {
                return(NotFound());
            }

            db.PartyLedgers.Remove(partyLedger);
            db.SaveChanges();

            return(Ok(partyLedger));
        }
        private void BtnLoad_Click(object sender, EventArgs e)
        {
            try
            {
                Cursor.Current = Cursors.WaitCursor;
                StartDate      = _RangeSelector.DtFrom.DateTime.Date;
                EndDate        = _RangeSelector.DtEnd.DateTime.Date;
                DataRow Currentrow = HelpGrid.GetDataRow(HelpGrid.FocusedRowHandle);


                switch (GlobalVariables.ProgCode)
                {
                case "PROG143":
                    DataSet      Ds      = ProjectFunctions.GetDataSet(string.Format("Exec [Sp_CashBookRpt] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}'", StartDate.Date, EndDate.Date));
                    rpt_CashBook RptDoc1 = new rpt_CashBook();
                    (RptDoc1.ReportDefinition.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc1.ReportDefinition.ReportObjects["txtReportHead"] as TextObject).Text  = "CASH BOOK";
                    (RptDoc1.ReportDefinition.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc1.SetDataSource(Ds.Tables[0]);
                    lbl.Text = string.Format(Title + " ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    crystalReportViewer1.ReportSource = RptDoc1;
                    _RangeSelector.Hide();
                    break;

                case "PROG144":
                    HelpGrid.CloseEditor();
                    HelpGrid.UpdateCurrentRow();
                    DataSet      DsRecoBank = ProjectFunctions.GetDataSet(string.Format("Exec [SP_RecoBank] '{0:yyyy-MM-dd}', '253'", EndDate.Date));
                    rpt_BankReco RptDoc2    = new rpt_BankReco();
                    (RptDoc2.ReportDefinition.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc2.ReportDefinition.ReportObjects["txtReportName"] as TextObject).Text  = "Bank Reco";
                    (RptDoc2.ReportDefinition.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc2.SetDataSource(DsRecoBank.Tables[0]);
                    lbl.Text = string.Format(Title + " ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    crystalReportViewer1.ReportSource = RptDoc2;
                    crystalReportViewer1.Show();
                    crystalReportViewer1.BringToFront();
                    _RangeSelector.Hide();
                    HelpGridCtrl.Hide();
                    break;

                case "PROG145":
                    DataSet     dsDayBook = ProjectFunctions.GetDataSet(string.Format("[Sp_PrepareDayBook] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}'", StartDate.Date, EndDate.Date));
                    rpt_DayBook RptDoc3   = new rpt_DayBook();
                    (RptDoc3.ReportDefinition.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc3.ReportDefinition.ReportObjects["txtReportHead"] as TextObject).Text  = "Day Book";
                    (RptDoc3.ReportDefinition.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc3.SetDataSource(dsDayBook.Tables[0]);
                    lbl.Text = string.Format(Title + " ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    crystalReportViewer1.ReportSource = RptDoc3;
                    crystalReportViewer1.Show();
                    crystalReportViewer1.BringToFront();
                    _RangeSelector.Hide();
                    break;

                case "PROG147":
                    DataSet      ds     = ProjectFunctions.GetDataSet(string.Format("[Sp_PrepareBankBook] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}'", StartDate.Date, EndDate.Date));
                    Rpt_BankBook RptDoc = new Rpt_BankBook();
                    (RptDoc.Section2.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                    (RptDoc.Section2.ReportObjects["txtReportName"] as TextObject).Text  = "Bank Book";
                    (RptDoc.Section2.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    lbl.Text = string.Format(Title + " ({0} to {1})", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                    RptDoc.SetDataSource(ds.Tables[0]);
                    crystalReportViewer1.ReportSource = RptDoc;
                    crystalReportViewer1.Show();
                    crystalReportViewer1.BringToFront();
                    _RangeSelector.Hide();
                    break;

                case "PROG165":
                    if (Currentrow != null)
                    {
                        DataSet     dsLedger  = ProjectFunctions.GetDataSet(string.Format("[sp_ZoomPartyAct] '{0:yyyy-MM-dd}', '{1:yyyy-MM-dd}','{2}'", StartDate.Date, EndDate.Date, Currentrow["AccCode"].ToString()));
                        PartyLedger RptLedger = new PartyLedger();
                        (RptLedger.Section2.ReportObjects["txtCompanyName"] as TextObject).Text = GlobalVariables.CompanyName;
                        (RptLedger.Section2.ReportObjects["txtReportName"] as TextObject).Text  = "Party Ledger";
                        (RptLedger.Section2.ReportObjects["txtDateRange"] as TextObject).Text   = string.Format("From ({0} to {1}) ", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                        lbl.Text = string.Format(Title + " ({0} to {1})", StartDate.Date.ToString("dd-MM-yyyy"), EndDate.Date.ToString("dd-MM-yyyy"));
                        RptLedger.SetDataSource(dsLedger.Tables[0]);
                        crystalReportViewer1.ReportSource = RptLedger;
                        crystalReportViewer1.Show();
                        crystalReportViewer1.BringToFront();
                        _RangeSelector.Hide();
                    }
                    else
                    {
                        ProjectFunctions.SpeakError("Plz Select Party First");
                    }
                    break;

                default:
                    break;
                }
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.Message);
            }
        }