// DailyCashFlowReport public Object GetFinance([FromBody] FinanceankPlan fp) { string sJSONResponse = ""; FinanceOutput fop = new FinanceOutput(); List <FinanceTypes> ftype = new List <FinanceTypes>(); for (int i = 1; i <= 2; i++) { string Type = ""; if (i == 2) { Type = "Expence"; } FinanceTypes dashboardlist = new FinanceTypes { TypeId = i, TypeName = "Income", SubTypes = GetSubType(i, fp.FromDate, fp.ToDate, fp.BranchCode) }; ftype.Add(dashboardlist); } fop.status = "success"; fop.value = ftype; sJSONResponse = JsonConvert.SerializeObject(fop); return(sJSONResponse); }
public Object GetFinanceBankReconcilation([FromBody] FinanceankPlan fp) { string sJSONResponse = ""; DataSet dt_Packageresposne = new DataSet(); DataTable dt_FinRecouncillation = getdata(string.Format("select TypeID,SubTypeID,LedgerID,VendorID,SourceId,FAPaymentModes,BranchCode,Amount,Date,InvoiceId,ExpenditureTo,BankAccountId,MatchedId,Recouncelled,FATID,Comments from FinanceBankReconcilation where BranchCode='{0}' ", fp.BranchCode)); FinanReconcilOpt fro = new FinanReconcilOpt(); try { List <FinanceBankReconcilation> financerec = new List <FinanceBankReconcilation>(); financerec.Add(new FinanceBankReconcilation { TypeID = dt_FinRecouncillation.Rows[0]["TypeID"].ToString() , SubTypeID = dt_FinRecouncillation.Rows[0]["SubTypeID"].ToString() , LedgerID = dt_FinRecouncillation.Rows[0]["LedgerID"].ToString() , VendorID = dt_FinRecouncillation.Rows[0]["VendorID"].ToString() , SourceId = dt_FinRecouncillation.Rows[0]["SourceId"].ToString() , FAPaymentModes = dt_FinRecouncillation.Rows[0]["FAPaymentModes"].ToString() , BranchCode = dt_FinRecouncillation.Rows[0]["BranchCode"].ToString() , Amount = dt_FinRecouncillation.Rows[0]["Amount"].ToString() , Date = dt_FinRecouncillation.Rows[0]["Date"].ToString() , InvoiceId = dt_FinRecouncillation.Rows[0]["InvoiceId"].ToString() , ExpenditureTo = dt_FinRecouncillation.Rows[0]["ExpenditureTo"].ToString() , BankAccountId = dt_FinRecouncillation.Rows[0]["BankAccountId"].ToString() , MatchedId = dt_FinRecouncillation.Rows[0]["MatchedId"].ToString() , Recouncelled = dt_FinRecouncillation.Rows[0]["Recouncelled"].ToString() , FATID = dt_FinRecouncillation.Rows[0]["FATID"].ToString() , Comments = dt_FinRecouncillation.Rows[0]["Comments"].ToString() }); fro.status = "Success"; fro.value = financerec; sJSONResponse = JsonConvert.SerializeObject(fro); } catch (Exception ec) { fro.status = "fail"; sJSONResponse = JsonConvert.SerializeObject(fro); } return(sJSONResponse); }
public Object GetFinanceTransactionReconcilation([FromBody] FinanceankPlan fp) { string sJSONResponse = ""; DataSet dt_Packageresposne = new DataSet(); DataTable dt_FinanceTransactionRecouncillation = getdata(string.Format("select TypeID,SourceID,SourceName,FAPaymentModes,BranchCode,MembershipCode,InvoiceID,Amount,PaymentDate,Receipt,AccountName,Comments,Source,BankAccountId from FinanceTransactionReconcilation where BranchCode='{0}' ", fp.BranchCode)); FinanceTransactionReconcilationopt fro = new FinanceTransactionReconcilationopt(); try { List <FinanceTransactionReconcilation> financetransactionrecouncill = new List <FinanceTransactionReconcilation>(); financetransactionrecouncill.Add(new FinanceTransactionReconcilation { TypeID = dt_FinanceTransactionRecouncillation.Rows[0]["TypeID"].ToString() , SourceID = dt_FinanceTransactionRecouncillation.Rows[0]["SourceID"].ToString() , SourceName = dt_FinanceTransactionRecouncillation.Rows[0]["SourceName"].ToString() , FAPaymentModes = dt_FinanceTransactionRecouncillation.Rows[0]["FAPaymentModes"].ToString() , BranchCode = dt_FinanceTransactionRecouncillation.Rows[0]["BranchCode"].ToString() , MembershipCode = dt_FinanceTransactionRecouncillation.Rows[0]["MembershipCode"].ToString() , InvoiceID = dt_FinanceTransactionRecouncillation.Rows[0]["InvoiceID"].ToString() , Amount = dt_FinanceTransactionRecouncillation.Rows[0]["Amount"].ToString() , PaymentDate = dt_FinanceTransactionRecouncillation.Rows[0]["PaymentDate"].ToString() , Receipt = dt_FinanceTransactionRecouncillation.Rows[0]["Receipt"].ToString() , AccountName = dt_FinanceTransactionRecouncillation.Rows[0]["AccountName"].ToString() , Comments = dt_FinanceTransactionRecouncillation.Rows[0]["Comments"].ToString() , Source = dt_FinanceTransactionRecouncillation.Rows[0]["Source"].ToString() , BankAccountId = dt_FinanceTransactionRecouncillation.Rows[0]["BankAccountId"].ToString() }); fro.status = "Success"; fro.value = financetransactionrecouncill; sJSONResponse = JsonConvert.SerializeObject(fro); } catch (Exception ec) { fro.status = "fail"; sJSONResponse = JsonConvert.SerializeObject(fro); } return(sJSONResponse); }
public Object FinanceAccountingTransactions([FromBody] FinanceankPlan fp) { FATopt FOutputA = new FATopt(); DataSet ds_SlotBooking = new DataSet(); string sJSONResponse = ""; try { List <FATTypes> types = new List <FATTypes>(); for (int i = 1; i <= 3; i++) { if (i == 1) { types.Add(new FATTypes { TypeId = 1, TypeName = "CashInFlow", SubType = GetSubTypes(1) }); } if (i == 2) { types.Add(new FATTypes { TypeId = 2, TypeName = "CashOutFlow", SubType = GetSubTypes(2) }); } } FOutputA.status = "success"; FOutputA.value = types; sJSONResponse = JsonConvert.SerializeObject(FOutputA); } catch (Exception ec) { FOutputA.status = "fail"; sJSONResponse = JsonConvert.SerializeObject(FOutputA); } return(sJSONResponse); }