public ActionResult GetAnFAdvanceAdjustmentReport(int anfAdvanceId)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                AnFAdvance objAnfAdvance = _advanceListService.GetById(anfAdvanceId);

                HrmEmployee objHrmEmployee = _hrmEmployeeService.GetById(objAnfAdvance.HrmEmployeeId);

                string employeeName = objAnfAdvance.HrmEmployee.Name;
                string advance = objAnfAdvance.RefNo;

                List<ReportParameter> paramList = new List<ReportParameter>();

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Employee";
                objcmpName.Value = employeeName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "Advance";
                objcmpAddress.Value = advance;
                paramList.Add(objcmpAddress);

                #endregion ParameterListPreperation

               // AdvanceAdjustmentReport
                dt = _advanceListService.GetAnFAdvanceAdjustmentReport(anfAdvanceId);

                    filepath = GetReportPath("AnFAdvanceAdjustmentReport.rpt");

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("AdvanceAdjustmentReport");
                }
            }
            else
            {
                return RedirectToAction("AdvanceAdjustmentReport");
            }
        }
        public ActionResult GetCollectionReports(int? nmPartytype, int? nmParty, int? OfficeId, DateTime StartDate, DateTime EndDate)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                if (Session["companyId"] != null)
                {

                    int companyId = Convert.ToInt32(Session["companyId"]);

                    SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);

                    string companyName = objCmnCompany.Name;
                    string companyAddress = objCmnCompany.Address;
                    string reportName = "Collection Report";

                    List<ReportParameter> paramList = new List<ReportParameter>();

                    #region ParameterListPreperation

                    ReportParameter objcmpName = new ReportParameter();
                    objcmpName.Name = "Company";
                    objcmpName.Value = companyName;
                    paramList.Add(objcmpName);

                    ReportParameter objcmpAddress = new ReportParameter();
                    objcmpAddress.Name = "CompanyAddress";
                    objcmpAddress.Value = companyAddress;
                    paramList.Add(objcmpAddress);

                    ReportParameter objReportName = new ReportParameter();
                    objReportName.Name = "ReportName";
                    objReportName.Value = reportName;
                    paramList.Add(objReportName);

                    ReportParameter objDateFrom = new ReportParameter();
                    objDateFrom.Name = "DateFrom";
                    objDateFrom.Value = StartDate.ToString("dd-MMM-yyyy");
                    paramList.Add(objDateFrom);

                    ReportParameter objDateTo = new ReportParameter();
                    objDateTo.Name = "DateTo";
                    objDateTo.Value = EndDate.ToString("dd-MMM-yyyy");
                    paramList.Add(objDateTo);

                    #endregion ParameterListPreperation

                    dt = _objCollectionReportService.GetCollectionReport(nmPartytype, nmParty, OfficeId, StartDate, EndDate);

                    filepath = GetReportPath("CollectionReport1.rpt");

                    if (dt != null && filepath != string.Empty)
                    {
                        return new CrystalReportResult(filepath, dt, paramList);
                    }
                    else
                    {
                        return RedirectToAction("GetCollectionReports");
                    }
                }
                else
                {
                    return RedirectToAction("GetCollectionReports");
                }
                //
            }
            else
            {
                return RedirectToAction("GetCollectionReports");
            }
        }
        public ActionResult GetTargetNAchievementReport(int CompanyId, int MonthId, int YearId, int EmployeeId = 0)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;
                int companyId = Convert.ToInt32(Session["companyId"]);
                SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);
                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;
                string reportName = "Sales Target & Achievement Report";

                List<ReportParameter> paramList = new List<ReportParameter>();

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "companyName";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objReportName = new ReportParameter();
                objReportName.Name = "ReportName";
                objReportName.Value = reportName;
                paramList.Add(objReportName);

                ReportParameter objMonth = new ReportParameter();
                objMonth.Name = "Month";
                objMonth.Value = DisplayMonthName(MonthId);
                paramList.Add(objMonth);

                ReportParameter objYear = new ReportParameter();
                objYear.Name = "Year";
                String Year = YearId.ToString();
                objYear.Value = Year;
                paramList.Add(objYear);

                #endregion ParameterListPreperation

                dt = _objTargetNAchievementReportService.GetTargetNAchievementReport(CompanyId, MonthId, YearId, EmployeeId);

                filepath = GetReportPath("TargetNAchievement.rpt");

                if (dt != null && filepath != string.Empty)
                {

                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("TargetNAchievement");
                }
            }
            else
            {
                return RedirectToAction("TargetNAchievement");
            }
        }
        public ActionResult GetInvoiceReport(string invoiceNo)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                int CompanyId = Convert.ToInt32(Session["companyId"]);

                SecCompany objCmnCompany = _SecCompanyService.GetById(CompanyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;
                string reportName = "Invoice Report";

                List<ReportParameter> paramList = new List<ReportParameter>();

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "CompanyName";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "Address";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objReportName = new ReportParameter();
                objReportName.Name = "ReportName";
                objReportName.Value = reportName;
                paramList.Add(objReportName);

                #endregion ParameterListPreperation

                if (invoiceNo.Length > 0)
                {
                    dt = _objRptInvoiceService.GetInvoiceList(invoiceNo);

                    filepath = GetReportPath("RptInvoice.rpt");

                    if (dt != null && filepath != string.Empty)
                    {
                        return new CrystalReportResult(filepath, dt, paramList);
                    }
                    else
                    {
                        return null;
                    }
                }
                else
                {
                    return null;
                }
            }
            else
            {
                return null;
            }
        }
예제 #5
0
        public ActionResult GetAnFChartOfAccountReport()
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                string projectName = string.Empty;

                string costCenterName = string.Empty;

                string dateFrom = string.Empty;
                string dateTo = string.Empty;

                int CompanyId = Convert.ToInt32(Session["companyId"].ToString());

                // List<AnFChartOfAccount> list = _coaService.GetByCompanyId(CompanyId);

                SecCompany objCmnCompany = _CmnCompanyService.GetById(CompanyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;

                List<ReportParameter> paramList = new List<ReportParameter>();

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                #endregion ParameterListPreperation

                dt = _coaService.GetAnFChartAccountsForReportByCompanyId(CompanyId);

                filepath = GetReportPath("AnFChartsofAccount.rpt");

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("ChartOfAccount");
                }
            }
            else
            {
                return RedirectToAction("ChartOfAccount");
            }
        }
        public ActionResult GetPartyLedgerReport(DateTime dateFrom, DateTime dateTo, int type, int partyId)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);

                SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;
                string reportName = "Party Ledger Report";

                List<ReportParameter> paramList = new List<ReportParameter>();

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objReportName = new ReportParameter();
                objReportName.Name = "ReportName";
                objReportName.Value = reportName;
                paramList.Add(objReportName);

                ReportParameter objDateFrom = new ReportParameter();
                objDateFrom.Name = "DateFrom";
                objDateFrom.Value = dateFrom.ToString("dd/MM/yyyy");
                paramList.Add(objDateFrom);

                ReportParameter objDateTo = new ReportParameter();
                objDateTo.Name = "DateTo";
                objDateTo.Value = dateTo.ToString("dd/MM/yyyy");
                paramList.Add(objDateTo);

                #endregion ParameterListPreperation

                dt = _objPartyLedgerReportService.GetPartyLedgerReport(dateFrom, dateTo, type, partyId, companyId);

                filepath = GetReportPath("PartyLedger.rpt");

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("PartyLedgerReport");
                }
            }
            else
            {
                return RedirectToAction("PartyLedgerReport");
            }
        }
        public ActionResult GetAnfExpenseReport(ExpenseSearchViewModel objExpenseSearchViewModel)
        {
            if (ModelState.IsValid)
            {
                IEnumerable<ReportAnFExpenseViewModel> list = null;
                IList<AnFExpens> expList = null;
                List<ReportParameter> paramList = new List<ReportParameter>();
                string filepath = string.Empty;

                //string projectName = string.Empty;

                string costCenterName = string.Empty;

                string dateFrom = string.Empty;
                string dateTo = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);
                int financialYearId = Convert.ToInt32(Session["financialYear"]);

                SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;

                dateFrom = objExpenseSearchViewModel.DateFrom.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
                dateTo = objExpenseSearchViewModel.ToDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

                if (objExpenseSearchViewModel.CostcenterId != null)
                {
                    costCenterName = _ccService.GetById(objExpenseSearchViewModel.CostcenterId.GetValueOrDefault()).Name;
                }

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                //ReportParameter objCostCenter = new ReportParameter();
                //objCostCenter.Name = "CostCenter";
                //objCostCenter.Value = costCenterName;
                //paramList.Add(objCostCenter);

                ReportParameter objDateFrom = new ReportParameter();
                objDateFrom.Name = "DateFrom";
                objDateFrom.Value = dateFrom;
                paramList.Add(objDateFrom);

                ReportParameter objDateTo = new ReportParameter();
                objDateTo.Name = "DateTo";
                objDateTo.Value = dateTo;
                paramList.Add(objDateTo);

                //ReportParameter objAnfId = new ReportParameter();
                //objAnfId.Name = "anfId";
                //objAnfId.Value = objGeneralLedgerSearchViewModel.AnFChartOfAccountId.ToString();
                //paramList.Add(objAnfId);
                #endregion ParameterListPreperation

                expList = _anfExpenseService.Search(companyId, financialYearId, objExpenseSearchViewModel.DateFrom, objExpenseSearchViewModel.ToDate, null).ToList();
                                                                //objExpenseSearchViewModel.AnFChartOfAccountId,
                                                                //objExpenseSearchViewModel.Status);
                //var newlist = expList.Select(t => new
                //{
                //    Id = t.Id,
                //    RefNo = t.RefNo,
                //    Particular = t.Particular == null ? "" : t.Particular,
                //    AnFChartOfAccountId = t.AnFChartOfAccountId,
                //    AnFCostCenterId = t.AnFCostCenterId == null ? 0 : (int)t.AnFCostCenterId,
                //    Date = t.Date,
                //    BillNo = t.BillNo,
                //    Mode = t.Mode,
                //    Narration = t.Narration,
                //    FileLocation = t.FileLocation == null ? "" : t.FileLocation,
                //    CmnFinancialYearId = t.CmnFinancialYearId,
                //    SecCompanyId = t.SecCompanyId,
                //    AnFVoucherId = t.AnFVoucherId == null ? 0 : (int)t.AnFVoucherId,
                //    Amount = t.Amount.Value,
                //    IsPosted = t.IsPosted
                //}).ToList();
                foreach (var obj in expList)
                {

                }
                filepath = GetReportPath("ExpenseReport.rpt");

                if (list != null && filepath != string.Empty)
                {
                    //return RedirectToAction("ExpenseReport");
                    return new CrystalReportResult(filepath, list, paramList);
                }
                else
                {
                    return RedirectToAction("ExpenseReport");
                }
            }
            else
            {
                return RedirectToAction("ExpenseReport");
            }
        }
예제 #8
0
        public ActionResult GetNoteSchedule(NoteScheduleSearchViewModel objNoteScheduleSearchViewModel)
        {
            if (ModelState.IsValid)
            {
                List<ReportParameter> paramList = new List<ReportParameter>();
                string filepath = string.Empty;

                string costCenterName = string.Empty;

                string dateFrom = string.Empty;
                string dateTo = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);
                int financialYearId = Convert.ToInt32(Session["financialYear"]);
                SecCompany objCmnCompany = _CmnCompanyService.GetById(companyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;

                DataTable dt = null;
                dateFrom = objNoteScheduleSearchViewModel.DateFrom.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
                dateTo = objNoteScheduleSearchViewModel.ToDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

                if (objNoteScheduleSearchViewModel.CostcenterId != null)
                {
                    costCenterName = _ccService.GetById(objNoteScheduleSearchViewModel.CostcenterId.GetValueOrDefault()).Name;
                }

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objDateFrom = new ReportParameter();
                objDateFrom.Name = "DateFrom";
                objDateFrom.Value = dateFrom;
                paramList.Add(objDateFrom);

                ReportParameter objDateTo = new ReportParameter();
                objDateTo.Name = "DateTo";
                objDateTo.Value = dateTo;
                paramList.Add(objDateTo);

                #endregion ParameterListPreperation

                //if (objNoteScheduleSearchViewModel.Type == 1)
                //{
                dt = _coaService.GetReportForNoteSchedule(financialYearId, companyId,
                                                           objNoteScheduleSearchViewModel.DateFrom.ToString("dd/MMM/yyyy"),
                                                           objNoteScheduleSearchViewModel.ToDate.ToString("dd/MMM/yyyy"),
                                                           objNoteScheduleSearchViewModel.CostcenterId,
                                                           objNoteScheduleSearchViewModel.AnFChartOfAccountId);

                filepath = GetReportPath("AnFNoteSchedule.rpt");
                //}
                //else if (objNoteScheduleSearchViewModel.Type == 2)
                //{
                //    //dt = _coaService.GetReportForNoteScheduleProject(financialYear, companyId, objNoteScheduleSearchViewModel.DateFrom.ToString("dd/MMM/yyyy"),
                //    // objNoteScheduleSearchViewModel.ToDate.ToString("dd/MMM/yyyy"), objNoteScheduleSearchViewModel.AnFChartOfAccountId);

                //    #region Demo

                //    dt = _coaService.GetReportForNoteScheduleProject(financialYear, companyId,objNoteScheduleSearchViewModel.BusinessId, objNoteScheduleSearchViewModel.DateFrom.ToString("dd/MMM/yyyy"),
                //     objNoteScheduleSearchViewModel.ToDate.ToString("dd/MMM/yyyy"), objNoteScheduleSearchViewModel.AnFChartOfAccountId);

                //    #endregion Demo

                //    filepath = GetReportPath("AnFNoteScheduleProject.rpt");
                //}

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("NoteSchedule");
                }
            }
            else
            {
                return RedirectToAction("NoteSchedule");
            }
        }
예제 #9
0
        public ActionResult GetProfitLoss(ProfitLossSearchViewModel obj)
        {
            List<ReportParameter> paramList = new List<ReportParameter>();
                string filepath = string.Empty;
                int financilaYearId = Convert.ToInt32(Session["financialYear"].ToString());

                string companyName = string.Empty;
                int? CompanyId = obj.SecCompanyId;
                if (CompanyId != 0)
                {
                    SecCompany objCmnCompany = _CmnCompanyService.GetById(CompanyId.Value);
                    companyName = objCmnCompany.Name;
                    string companyAddress = objCmnCompany.Address;
                }
                else
                {
                    CompanyId = null;
                    companyName = "MEP Group";
                }
                DataTable dt = null;

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpDateTo = new ReportParameter();
                objcmpDateTo.Name = "dateto";
                objcmpDateTo.Value = obj.ToDate.ToString("dd/MM/yyyy");
                paramList.Add(objcmpDateTo);

                ReportParameter objcmpDateFrom = new ReportParameter();
                objcmpDateFrom.Name = "datefrom";
                objcmpDateFrom.Value = obj.FromDate.ToString("dd/MM/yyyy");
                paramList.Add(objcmpDateFrom);

                #endregion ParameterListPreperation

                dt = _anfVoucherService.GetProfitLossForReport(CompanyId, financilaYearId, obj.FromDate, obj.ToDate);

                filepath = GetReportPath("AnFProfitLoss.rpt");

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("ProfitLoss");
                }
        }
예제 #10
0
        public ActionResult GetAnFTrialBalanceDetailsReport(ReportAnFTrialBalanceDetalisSearchViewModel obj)
        {
            DataTable dt = null;
            string filepath = string.Empty;

            int CompanyId = Convert.ToInt32(Session["companyId"].ToString());
            //CompanyId = 1;
            int financilaYearId = Convert.ToInt32(Session["financialYear"].ToString());
            SecCompany objCmnCompany = _CmnCompanyService.GetById(CompanyId);

            AnFCostCenter costCenter = _ccService.GetCostCenterById(obj.AnFCostCeterId);

            string companyName = objCmnCompany.Name;
            string companyAddress = objCmnCompany.Address;

            List<ReportParameter> paramList = new List<ReportParameter>();

            #region ParameterListPreperation

            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "company";
            objcmpName.Value = companyName;
            paramList.Add(objcmpName);

            ReportParameter objPsID = new ReportParameter();
            objPsID.Name = "prmCostCenter";
            objPsID.Value = costCenter == null ? "" : costCenter.Name;
            paramList.Add(objPsID);

            ReportParameter objcmpDateTo = new ReportParameter();
            objcmpDateTo.Name = "toDate";
            objcmpDateTo.Value = obj.ToDate.ToString("dd/MM/yyyy");
            paramList.Add(objcmpDateTo);

            ReportParameter objcmpDateFrom = new ReportParameter();
            objcmpDateFrom.Name = "fromDate";
            objcmpDateFrom.Value = obj.FromDate.ToString("dd/MM/yyyy");
            paramList.Add(objcmpDateFrom);

            #endregion ParameterListPreperation

            dt = _ccService.GetTrialBalanceDetailsReport(CompanyId, financilaYearId, obj.FromDate, obj.ToDate,obj.AnFCostCeterId, false);

            filepath = GetReportPath("AnFTrialBalanceDetails.rpt");

            if (dt != null && filepath != string.Empty)
            {
                return new CrystalReportResult(filepath, dt, paramList);
            }
            else
            {
                return RedirectToAction("TrialBalanceDetails");
            }
        }
예제 #11
0
        public ActionResult GetAnFTrialBalanceProjectWiseReport(ReportAnFTrialbalanceProjectWiseSearchViewModel obj)
        {
            DataTable dt = null;
            string filepath = string.Empty;

            int CompanyId = Convert.ToInt32(Session["companyId"].ToString());
            CompanyId = 1;
            long financilaYearId = Convert.ToInt64(Session["financialYear"].ToString());
            SecCompany objCmnCompany = _CmnCompanyService.GetById(CompanyId);

            string companyName = objCmnCompany.Name;
            string companyAddress = objCmnCompany.Address;

            List<ReportParameter> paramList = new List<ReportParameter>();

            #region ParameterListPreperation

            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "Company";
            objcmpName.Value = companyName;
            paramList.Add(objcmpName);

            ReportParameter objcmpDateTo = new ReportParameter();
            objcmpDateTo.Name = "ToDate";
            objcmpDateTo.Value = obj.ToDate.ToString("dd/MM/yyyy");
            paramList.Add(objcmpDateTo);

            ReportParameter objcmpDateFrom = new ReportParameter();
            objcmpDateFrom.Name = "DateFrom";
            objcmpDateFrom.Value = obj.FromDate.ToString("dd/MM/yyyy");
            paramList.Add(objcmpDateFrom);

            #endregion ParameterListPreperation

            //dt = _ccService.GetCostOfGoodSoldReport(CompanyId, financilaYearId, obj.FromDate, obj.ToDate, obj.CmnProjectId);

            dt = _ccService.GetTrialBalanceProjectWiseReport(CompanyId, financilaYearId, obj.FromDate, obj.ToDate, obj.BusinessId);

            filepath = GetReportPath("AnFTrialBalanceProject.rpt");

            if (dt != null && filepath != string.Empty)
            {
                return new CrystalReportResult(filepath, dt, paramList);
            }
            else
            {
                return RedirectToAction("CostOfSoldGoods");
            }
        }
예제 #12
0
        public ActionResult GetAnfGeneralLedger(GeneralLedgerSearchViewModel objGeneralLedgerSearchViewModel)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                List<ReportParameter> paramList = new List<ReportParameter>();
                string filepath = string.Empty;

                //string projectName = string.Empty;

                string costCenterName = string.Empty;

                string dateFrom = string.Empty;
                string dateTo = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);
                int financialYearId = Convert.ToInt32(Session["financialYear"]);

                SecCompany objCmnCompany = _CmnCompanyService.GetById(companyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;

                dateFrom = objGeneralLedgerSearchViewModel.DateFrom.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
                dateTo = objGeneralLedgerSearchViewModel.ToDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

                //if (objGeneralLedgerSearchViewModel.Type == 1)
                //{
                //if (objGeneralLedgerSearchViewModel.ProjectId != null)
                //{
                //    projectName = _CmnProjectService.GetById(objGeneralLedgerSearchViewModel.ProjectId.GetValueOrDefault()).Name;
                //}
                if (objGeneralLedgerSearchViewModel.CostcenterId != null)
                {
                    costCenterName = _ccService.GetById(objGeneralLedgerSearchViewModel.CostcenterId.GetValueOrDefault()).Name;
                }

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                //ReportParameter objProjecName = new ReportParameter();
                //objProjecName.Name = "Project";
                //objProjecName.Value = projectName;
                //paramList.Add(objProjecName);

                ReportParameter objCostCenter = new ReportParameter();
                objCostCenter.Name = "CostCenter";
                objCostCenter.Value = costCenterName;
                paramList.Add(objCostCenter);

                ReportParameter objDateFrom = new ReportParameter();
                objDateFrom.Name = "DateFrom";
                objDateFrom.Value = dateFrom;
                paramList.Add(objDateFrom);

                ReportParameter objDateTo = new ReportParameter();
                objDateTo.Name = "DateTo";
                objDateTo.Value = dateTo;
                paramList.Add(objDateTo);

                ReportParameter objAnfId = new ReportParameter();
                objAnfId.Name = "anfId";
                objAnfId.Value = objGeneralLedgerSearchViewModel.AnFChartOfAccountId.ToString();
                paramList.Add(objAnfId);
                #endregion ParameterListPreperation

                dt = _anfVoucherService.GetGeneralLedgerForReport(financialYearId, companyId,
                                                                objGeneralLedgerSearchViewModel.DateFrom.ToString("dd/MMM/yyyy"),
                                                                objGeneralLedgerSearchViewModel.ToDate.ToString("dd/MMM/yyyy"),
                                                                objGeneralLedgerSearchViewModel.CostcenterId,
                                                                objGeneralLedgerSearchViewModel.AnFChartOfAccountId,
                                                                objGeneralLedgerSearchViewModel.Status);

                filepath = GetReportPath("AnFGeneralLedger.rpt");
                // }
                //else if (objGeneralLedgerSearchViewModel.Type == 2)
                //{
                //    ReportParameter objDateFrom = new ReportParameter();
                //    objDateFrom.Name = "DateFrom";
                //    objDateFrom.Value = dateFrom;
                //    paramList.Add(objDateFrom);

                //    ReportParameter objDateTo = new ReportParameter();
                //    objDateTo.Name = "DateTo";
                //    objDateTo.Value = dateTo;
                //    paramList.Add(objDateTo);

                //    ReportParameter objCompany = new ReportParameter();
                //    objCompany.Name = "Company";
                //    objCompany.Value = companyName;
                //    paramList.Add(objCompany);

                //    dt = _anfVoucherService.GetProjectGeneralLedgerForReport(financialYearId, companyId, objGeneralLedgerSearchViewModel.DateFrom.ToString("dd/MMM/yyyy"),
                //        objGeneralLedgerSearchViewModel.ToDate.ToString("dd/MMM/yyyy"), objGeneralLedgerSearchViewModel.BusinessId, objGeneralLedgerSearchViewModel.ProjectId,
                //        objGeneralLedgerSearchViewModel.AnFChartOfAccountId, objGeneralLedgerSearchViewModel.Status);

                //    filepath = GetReportPath("AnFGeneralLedgerProject.rpt");
                //}

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("GeneralLedger");
                }
            }
            else
            {
                return RedirectToAction("GeneralLedger");
            }
        }
예제 #13
0
        public ActionResult GetAnFCostCenterReport()
        {
            DataTable dt = null;
            string filepath = string.Empty;

            int companyId = Convert.ToInt32(Session["companyId"].ToString());
            SecCompany objCmnCompany = _CmnCompanyService.GetById(companyId);
            IList<ReportAnFCostCentreViewModel> collection = new List<ReportAnFCostCentreViewModel>();
            List<ReportParameter> paramList = new List<ReportParameter>();

            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "Company";
            objcmpName.Value = objCmnCompany.Name;
            paramList.Add(objcmpName);

            ReportParameter objcmpAddress = new ReportParameter();
            objcmpAddress.Name = "CompanyAddress";
            objcmpAddress.Value = objCmnCompany.Address;
            paramList.Add(objcmpAddress);
            if (ModelState.IsValid)
            {
                dt = new DataTable();
                dt = _ccService.GetCostCentersByCompanyId(companyId);

                filepath = GetReportPath("AnFCostCenter.rpt");

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("CostCenterReport", new { id = 1 });
                    //return RedirectToAction("CostCenterReport");
                }
            }
            else
            {
                return RedirectToAction("CostCenterReport");
            }
        }
예제 #14
0
        public ActionResult GetAnFChartOfAccountWIthOpeningbalanceReport(int? YearId)
        {
            if (YearId == null)
            {
                return RedirectToAction("OpeningBalanceReport");
            }

            DataTable dt = null;
            string filepath = string.Empty;

            //string projectName = string.Empty;

            //string costCenterName = string.Empty;

            //string dateFrom = string.Empty;
            //string dateTo = string.Empty;

            int CompanyId = Convert.ToInt32(Session["companyId"].ToString());
            CompanyId = 1;
            //long FinancilaYearId = Convert.ToInt64(Session["financialYear"].ToString());

            SecCompany objCmnCompany = _CmnCompanyService.GetById(CompanyId);

            string companyName = objCmnCompany.Name;
            string companyAddress = objCmnCompany.Address;

            List<ReportParameter> paramList = new List<ReportParameter>();

            #region ParameterListPreperation

            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "company";
            objcmpName.Value = companyName;
            paramList.Add(objcmpName);

            ReportParameter objcmpAddress = new ReportParameter();
            objcmpAddress.Name = "companyAddress";
            objcmpAddress.Value = companyAddress;
            paramList.Add(objcmpAddress);

            #endregion ParameterListPreperation

            dt = _coaService.GetAnFChartAccountsWithOpeningBalanceForReportByCompanyId(CompanyId, YearId);
            //dt = _opBalanceService.GetOpeningBalanceReportById(CompanyId, YearId);

            filepath = GetReportPath("AnFOpenningBalance.rpt");

            if (dt != null && filepath != string.Empty)
            {
                return new CrystalReportResult(filepath, dt, paramList);
            }
            else
            {
                return RedirectToAction("OpeningBalanceReport");
            }
        }
        public ActionResult GetDailySalesReport(DateTime StartDate, DateTime EndDate, int OfficeId = 0, int CategoryId = 0, int SubCategoryId = 0)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);
                int categoryId = CategoryId;

                SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);
                SlsProduct ChartOfProduct = _ChartOfProductService.GetById(categoryId);
                string productName = ChartOfProduct.Name;
                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;
                string reportName = "Daily Sales Report";

                List<ReportParameter> paramList = new List<ReportParameter>();

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objReportName = new ReportParameter();
                objReportName.Name = "ReportName";
                objReportName.Value = reportName;
                paramList.Add(objReportName);

                ReportParameter objStartDate = new ReportParameter();
                objStartDate.Name = "StartDate";
                String StrtDate = StartDate.ToString("dd-MM-yyyy");
                objStartDate.Value = "From :"+StrtDate;
                paramList.Add(objStartDate);

                ReportParameter objEndDate = new ReportParameter();
                objEndDate.Name = "EndDate";
                String endDate = EndDate.ToString("dd-MM-yyyy");
                objEndDate.Value = "To :" + endDate;
                paramList.Add(objEndDate);

                ReportParameter objCategory = new ReportParameter();
                objCategory.Name = "Category";
                objCategory.Value = "Group/Category Code : "+productName;
                paramList.Add(objCategory);

                #endregion ParameterListPreperation

                dt = _objDailySalesReportService.GetDailySalesReport(companyId, StartDate, EndDate, OfficeId, CategoryId, SubCategoryId);

                filepath = GetReportPath("DailySales.rpt");

                if (dt != null && filepath != string.Empty)
                {

                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("DailySales");
                }
            }
            else
            {
                return RedirectToAction("DailySales");
            }
        }
        public ActionResult GetAnfVoucher(long Id)
        {
            DataTable dt = _anfVoucherService.GetAnfVoucher(Id);

            int companyId = Convert.ToInt32(Session["companyId"]);
            int financialYearId = Convert.ToInt32(Session["financialYear"]);

            SecCompany objCmnCompany = _CmnCompanyService.GetById(companyId);

            string companyName = objCmnCompany.Name;
            string companyAddress = objCmnCompany.Address;

            List<ReportAnFVoucherViewModel> list = dt.DataTableToList<ReportAnFVoucherViewModel>();

            List<ReportParameter> paramList = new List<ReportParameter>();
            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "Company";
            objcmpName.Value = companyName;
            paramList.Add(objcmpName);

            ReportParameter objcmpAddress = new ReportParameter();
            objcmpAddress.Name = "CompanyAddress";
            objcmpAddress.Value = companyAddress;
            paramList.Add(objcmpAddress);

            string filepath = GetReportPath("AnFVouchers.rpt");

            return new CrystalReportResult(filepath, list, paramList);
        }
        public ActionResult GetDataTableForSalesCollectionTarget(int? EmployeeId, string defaultView, string reportTitle)
        {
            DataTable dt = null;
            dt = _objSalesTargetReportService.GetSalesTargetReport(EmployeeId);

            string filepath = string.Empty;
            filepath = GetReportPath("RptSalesTargetCollectiont1.rpt");

            List<ReportParameter> paramList = new List<ReportParameter>();
            int companyId = Convert.ToInt32(Session["companyId"]);
            SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);
            string companyName = objCmnCompany.Name;
            string companyAddress = objCmnCompany.Address;
            string reportName = reportTitle;
            #region ParameterListPreperation

            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "Company";
            objcmpName.Value = companyName;
            paramList.Add(objcmpName);

            ReportParameter objcmpAddress = new ReportParameter();
            objcmpAddress.Name = "CompanyAddress";
            objcmpAddress.Value = companyAddress;
            paramList.Add(objcmpAddress);

            ReportParameter objReportName = new ReportParameter();
            objReportName.Name = "ReportName";
            objReportName.Value = reportName;
            paramList.Add(objReportName);

            ReportParameter objMonthName = new ReportParameter();
            objMonthName.Name = "MonthName";
            objMonthName.Value = DisplayMonthName(DateTime.Now.Month);
            paramList.Add(objMonthName);

            //ReportParameter objYear = new ReportParameter();
            //objYear.Name = "Year";
            //objYear.Value = Year.ToString();
            //paramList.Add(objYear);

            //ReportParameter objMonth = new ReportParameter();
            //objMonth.Name = "Month";
            //objMonth.Value = Month.ToString();
            //paramList.Add(objMonth);

            #endregion ParameterListPreperation

            if (dt != null && filepath != string.Empty)
            {
                return new CrystalReportResult(filepath, dt, paramList);
            }
            else
            {
                return RedirectToAction(defaultView);
            }
        }
        public ActionResult GetAnfVoucherList(VoucherSearchViewModel objVoucherSearchViewModel)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                //string projectName = string.Empty;

                string costCenterName = string.Empty;

                string dateFrom = string.Empty;
                string dateTo = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);
                int financialYearId = Convert.ToInt32(Session["financialYear"]);

                SecCompany objCmnCompany = _CmnCompanyService.GetById(companyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;

                List<ReportParameter> paramList = new List<ReportParameter>();

                if (objVoucherSearchViewModel.CostcenterId != null)
                {
                    costCenterName = _ccService.GetById(objVoucherSearchViewModel.CostcenterId.GetValueOrDefault()).Name;
                }

                dateFrom = objVoucherSearchViewModel.DateFrom.GetValueOrDefault().ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
                dateTo = objVoucherSearchViewModel.ToDate.GetValueOrDefault().ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objCostCenter = new ReportParameter();
                objCostCenter.Name = "CostCenter";
                objCostCenter.Value = costCenterName;
                paramList.Add(objCostCenter);

                ReportParameter objDateFrom = new ReportParameter();
                objDateFrom.Name = "DateFrom";
                objDateFrom.Value = dateFrom;
                paramList.Add(objDateFrom);

                ReportParameter objDateTo = new ReportParameter();
                objDateTo.Name = "DateTo";
                objDateTo.Value = dateTo;
                paramList.Add(objDateTo);

                #endregion ParameterListPreperation

                if (objVoucherSearchViewModel.ReportType == 2)
                {
                    dt = _anfVoucherService.GetAnfVoucherList(financialYearId, companyId,
                                             objVoucherSearchViewModel.VoucherTypeId,
                                              objVoucherSearchViewModel.DateFrom,
                                             objVoucherSearchViewModel.ToDate,
                                             objVoucherSearchViewModel.CostcenterId);

                    filepath = GetReportPath("AnFVoucherList.rpt");
                }

                if (objVoucherSearchViewModel.ReportType == 3)
                {
                    dt = _anfVoucherService.GetShortDetailAnFVoucherList(financialYearId, companyId,
                                             objVoucherSearchViewModel.VoucherTypeId,
                                              objVoucherSearchViewModel.DateFrom,
                                             objVoucherSearchViewModel.ToDate,
                                             objVoucherSearchViewModel.CostcenterId);
                    filepath = GetReportPath("AnFShortVouchersList.rpt");
                }

                if (objVoucherSearchViewModel.ReportType == 4)
                {
                    dt = _anfVoucherService.GetShortDetailAnFVoucherList(financialYearId, companyId,
                                             objVoucherSearchViewModel.VoucherTypeId,
                                              objVoucherSearchViewModel.DateFrom,
                                             objVoucherSearchViewModel.ToDate,
                                             objVoucherSearchViewModel.CostcenterId);
                    filepath = GetReportPath("AnFDetailVouchers.rpt");
                }
                if (objVoucherSearchViewModel.ReportType == 5)
                {
                    //Payment
                    dt = _anfVoucherService.GetPaymentVouchers(financialYearId, companyId,
                                             objVoucherSearchViewModel.VoucherTypeId,
                                              objVoucherSearchViewModel.DateFrom,
                                             objVoucherSearchViewModel.ToDate,
                                             objVoucherSearchViewModel.CostcenterId);
                    ReportParameter PaymentOrRecieve = new ReportParameter();
                    PaymentOrRecieve.Name = "PaymentOrRecieve";
                    PaymentOrRecieve.Value = "Payment Report";
                    paramList.Add(PaymentOrRecieve);
                    //PaymentOrRecieve
                    filepath = GetReportPath("AnFPayment.rpt");
                }
                if (objVoucherSearchViewModel.ReportType == 6)
                {
                    //Receipt
                    dt = _anfVoucherService.GetPaymentVouchers(financialYearId, companyId,
                                            objVoucherSearchViewModel.VoucherTypeId,
                                             objVoucherSearchViewModel.DateFrom,
                                            objVoucherSearchViewModel.ToDate,
                                            objVoucherSearchViewModel.CostcenterId);
                    ReportParameter PaymentOrRecieve = new ReportParameter();
                    PaymentOrRecieve.Name = "PaymentOrRecieve";
                    PaymentOrRecieve.Value = "Receive Report";
                    paramList.Add(PaymentOrRecieve);
                    //PaymentOrRecieve
                    filepath = GetReportPath("AnFPayment.rpt");
                }
                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("Voucher");
                }
            }
            else
            {
                return RedirectToAction("Voucher");
            }
        }
        public ActionResult GetSalesReturnReport(int id)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);

                SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;
                string reportName = "Sales Return Report";

                List<ReportParameter> paramList = new List<ReportParameter>();

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objReportName = new ReportParameter();
                objReportName.Name = "ReportName";
                objReportName.Value = reportName;
                paramList.Add(objReportName);

                #endregion ParameterListPreperation

                dt = _objSalesReturnListReportService.GetSalesReturnListReport(id);

                filepath = GetReportPath("RptSalesReturn.rpt");

                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("GetSalesReturnListReport");
                }
            }
            else
            {
                return RedirectToAction("GetSalesReturnListReport");
            }
        }
        public ActionResult GetAnFReceivableReport(int? costCenterId, int ReportType)
        {
            if (ModelState.IsValid)
            {
                DataTable dt = null;
                string filepath = string.Empty;

                string costCenterName = string.Empty;

                int companyId = Convert.ToInt32(Session["companyId"]);
                int financialYearId = Convert.ToInt32(Session["financialYear"]);

                SecCompany objCmnCompany = _CmnCompanyService.GetById(companyId);

                string companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;

                List<ReportParameter> paramList = new List<ReportParameter>();

                if (costCenterId != null)
                {
                    costCenterName = _ccService.GetById(costCenterId.GetValueOrDefault()).Name;
                }

                #region ParameterListPreperation

                ReportParameter objcmpName = new ReportParameter();
                objcmpName.Name = "Company";
                objcmpName.Value = companyName;
                paramList.Add(objcmpName);

                ReportParameter objcmpAddress = new ReportParameter();
                objcmpAddress.Name = "CompanyAddress";
                objcmpAddress.Value = companyAddress;
                paramList.Add(objcmpAddress);

                ReportParameter objCostCenter = new ReportParameter();
                objCostCenter.Name = "CostCenter";
                objCostCenter.Value = costCenterName;
                paramList.Add(objCostCenter);

                #endregion ParameterListPreperation

                if (ReportType == 1)
                {
                    //Receivable
                dt = _anfVoucherService.GetAnFReceivableReport(financialYearId, companyId, costCenterId);
                    ReportParameter ReceivableOrPayable = new ReportParameter();
                    ReceivableOrPayable.Name = "ReceivableOrPayable";
                    ReceivableOrPayable.Value = "Receivable Report";
                    paramList.Add(ReceivableOrPayable);
                    //ReceivableOrPayable
                    filepath = GetReportPath("AnFReceivableReport.rpt");
                }
                if (ReportType == 2)
                {
                    //Payable
                    dt = _anfVoucherService.GetAnFPayableReport(financialYearId, companyId, costCenterId);
                    ReportParameter ReceivableOrPayable = new ReportParameter();
                    ReceivableOrPayable.Name = "ReceivableOrPayable";
                    ReceivableOrPayable.Value = "Payable Report";
                    paramList.Add(ReceivableOrPayable);
                    //ReceivableOrPayable
                    filepath = GetReportPath("AnFReceivableReport.rpt");
                }
                if (dt != null && filepath != string.Empty)
                {
                    return new CrystalReportResult(filepath, dt, paramList);
                }
                else
                {
                    return RedirectToAction("ReceivableReport");
                }
            }
            else
            {
                return RedirectToAction("ReceivableReport");
            }
        }
        public ActionResult ShowIncentiveReport(int salesPersonId = 0, int year = 0, int month = 0)
        {
            var list = GetAllIncentives(year, month, salesPersonId);
            int companyId = Convert.ToInt32(Session["companyId"]);
            var employeeList = _hrmEmployeeService.GetAllEmployee(companyId);
            var designationList = _hrmDesignationService.GetAll();

            var result = list.Select(i => new RptSlsIncentiveViewModel()
            {
                Id = i.Id,
                HrmEmployeeId = i.HrmEmployeeId,
                Year = i.Year,
                Month = i.Month,
                Commission = i.Commission,
                AmountPaid = i.AmountPaid,
                PaymentDate = i.PaymentDate,
                Remarks = i.Remarks,
                CreatedBy = i.CreatedBy,
                CreatedDate = i.CreatedDate,
                ModifiedBy = i.ModifiedBy == null ? 0 : (int)i.ModifiedBy,
                ModifiedDate = i.ModifiedDate == null ? DateTime.MinValue : (DateTime)i.ModifiedDate,
                MonthName = DateUtil.DisplayMonthName(i.Month),
                EmployeeName = employeeList.Where(j=>j.Id == i.HrmEmployeeId).FirstOrDefault().Name
            }).Distinct().ToList();

            foreach(var item in result)
            {
                int? empId = employeeList.Where(j =>
                    j.Id == item.HrmEmployeeId).FirstOrDefault().HrmDesignationId;
                if(empId != null)
                item.EmployeeDesignation = designationList.Where(d => d.Id == (int)empId).FirstOrDefault().Name;
            }

            string filepath = string.Empty;
            filepath = ReportUtil.GetSalesReportPath("IncentiveReport.rpt");

            #region ParameterListPreperation
            List<ReportParameter> paramList = new List<ReportParameter>();
            //int companyId = Convert.ToInt32(Session["companyId"]);
            SecCompany objCmnCompany = _SecCompanyService.GetById(companyId);
            string companyName = objCmnCompany.Name;
            string companyAddress = objCmnCompany.Address;
            string reportName = "Sales Incentive Report";

            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "Company";
            objcmpName.Value = companyName;
            paramList.Add(objcmpName);

            ReportParameter objcmpAddress = new ReportParameter();
            objcmpAddress.Name = "CompanyAddress";
            objcmpAddress.Value = companyAddress;
            paramList.Add(objcmpAddress);

            ReportParameter objReportName = new ReportParameter();
            objReportName.Name = "ReportName";
            objReportName.Value = reportName;
            paramList.Add(objReportName);

            #endregion ParameterListPreperation

            if (result != null && result.Count > 0 && filepath != string.Empty)
            {
                return new CrystalReportResult(filepath, result, paramList);
            }
            else
            {
                return RedirectToAction("SalesIncentive", "Report", new { area = "Sales" });
            }
        }
예제 #22
0
        public ActionResult GetAnFBalanceSheetReport(ReportAnFBalanceSheetSearchViewModel obj)
        {
            DataTable dt = null;
            string filepath = string.Empty;

            int financilaYearId = Convert.ToInt32(Session["financialYear"].ToString());
            // List<AnFChartOfAccount> list = _coaService.GetByCompanyId(CompanyId);

            List<ReportParameter> paramList = new List<ReportParameter>();

            #region ParameterListPreperation
            //int CompanyId = Convert.ToInt32(Session["companyId"].ToString());
            //ReportParameter objcmpSecCompanyId = new ReportParameter();
            string companyName = string.Empty;
            int? CompanyId = obj.SecCompanyId;
            if (CompanyId != 0)
            {
                SecCompany objCmnCompany = _CmnCompanyService.GetById(CompanyId.Value);
                companyName = objCmnCompany.Name;
                string companyAddress = objCmnCompany.Address;
            }
            else
            {
                CompanyId = null;
                companyName = "MEP Group";
            }

            ReportParameter objcmpName = new ReportParameter();
            objcmpName.Name = "company";
            objcmpName.Value = companyName;
            paramList.Add(objcmpName);

            ReportParameter objcmpDateTo = new ReportParameter();
            objcmpDateTo.Name = "dateto";
            objcmpDateTo.Value = obj.ToDate.ToString("dd/MM/yyyy");
            paramList.Add(objcmpDateTo);

            ReportParameter objcmpDateFrom = new ReportParameter();
            objcmpDateFrom.Name = "datefrom";
            objcmpDateFrom.Value = obj.FromDate.ToString("dd/MM/yyyy");
            paramList.Add(objcmpDateFrom);

            //ReportParameter objcmpBid = new ReportParameter();
            //objcmpBid.Name = "bsid";
            //objcmpBid.Value = obj.CmnBusinessId.ToString();
            //paramList.Add(objcmpBid);

            //ReportParameter objcmpPid = new ReportParameter();
            //objcmpPid.Name = "psid";
            //objcmpPid.Value = obj.CmnProjectId.ToString();
            //paramList.Add(objcmpPid);

            #endregion ParameterListPreperation

            //dt = _coaService.GetAnFBalanceSheetReport(CompanyId, financilaYearId, obj.FromDate, obj.ToDate, obj.CmnBusinessId, obj.CmnProjectId);
            dt = _coaService.GetAnFBalanceSheetReport(CompanyId, financilaYearId, obj.FromDate, obj.ToDate);

            filepath = GetReportPath("AnFBalanceSheet.rpt");

            if (dt != null && filepath != string.Empty)
            {
                return new CrystalReportResult(filepath, dt, paramList);
            }
            else
            {
                return RedirectToAction("BalanceSheet");
            }
        }