public IHttpActionResult EditTaxSaving(TaxSavingModel ts) { DataSet ds = TaxSavingsRepository.GetTaxSavingReceipt(ts.EmployeeId, ts.FinancialYear); DataTable Results = ds.Tables[0]; var query = Results.AsEnumerable().Select(result => new { TaxSavingId = result.Field <Guid>("TaxSavingId"), EmployeeId = result.Field <Guid>("EmployeeId"), FullName = result.Field <string>("FullName"), FinancialYear = result.Field <int>("FinancialYear"), TaxSavingType = result.Field <int>("TaxSavingType"), TaxSavingTypeName = result.Field <string>("TaxSavingTypeName"), RecurringFrequency = result.Field <int>("RecurringFrequency"), SavingDate = result.Field <DateTime?>("SavingDate"), AccountNumber = result.Field <string>("AccountNumber"), Amount = result.Field <decimal?>("Amount"), TotalAmount = result.Field <decimal?>("TotalAmount"), Remarks = result.Field <string>("Remarks"), ReceiptSubmitted = result.Field <bool?>("ReceiptSubmitted"), EligibleCount = result.Field <int>("EligibleCount") }); var filterdata = query.Where(m => m.TaxSavingId == ts.TaxSavingId); return(Ok(filterdata)); }
public IHttpActionResult ExcelExport(TaxSavingModel ts) { /*string employeeId, string financialYear, string fyText*/ string fileName = Guid.NewGuid().ToString() + ".xlsx"; string physicalFileName = HttpRuntime.AppDomainAppPath + "/Log/" + fileName; DataSet ds = TaxSavingsRepository.GetTaxSavingReceipt(ts.EmployeeId, ts.FinancialYear); DataSet dsList = new DataSet(); List <string> strTableHeader = new List <string>(); System.Data.DataView view = new System.Data.DataView(ds.Tables[0]); DataTable distinctValues = view.ToTable(true, "EmployeeId", "FullName"); for (int i = 0; i < distinctValues.Rows.Count; i++) { DataSet objDsList = TaxSavingsRepository.GetTaxSavingReceiptForExcel((distinctValues.Rows[i]["EmployeeId"].ToString() != "") ? Guid.Parse(distinctValues.Rows[i]["EmployeeId"].ToString()) : Guid.Parse("00000000-0000-0000-0000-000000000000"), ts.FinancialYear); objDsList.Tables[0].TableName = distinctValues.Rows[i]["FullName"].ToString(); dsList.Tables.Add(objDsList.Tables[0].Copy()); strTableHeader.Add(distinctValues.Rows[i]["FullName"].ToString()); } var excelHelper = new ExcelExport(); Attachment objExcelFile = new Attachment(); string excelSheetHeading = "Tax Savings (FY " + ts.fyText + ")"; excelHelper.ExportToExcel(physicalFileName, dsList, excelSheetHeading); string downloadName = string.Format("Tax Savings -{0:yyyyMMdd-HHmmss}" + ".xlsx", DateTime.Now); objExcelFile.FileName = downloadName;; objExcelFile.FileContent = System.IO.File.ReadAllBytes(physicalFileName); objExcelFile.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; return(Ok(objExcelFile)); }
public IHttpActionResult DeleteTaxSavingReceipt(TaxSavingModel ts) { long result; result = TaxSavingsRepository.DeleteTaxSavingReceipt(ts.TaxSavingId); return(Ok(result)); }
public IHttpActionResult UpdateTaxSavingReceipt(TaxSavingModel ts) { long result; JavaScriptSerializer serializer = new JavaScriptSerializer(); dynamic receiptObj = serializer.Deserialize <object>(ts.jsonData); result = TaxSavingsRepository.UpdateTaxSavingReceipt(Guid.Parse(receiptObj["taxSavingId"]), Guid.Parse(receiptObj["employeeId"]), int.Parse(receiptObj["financialYear"]), int.Parse(receiptObj["taxSavingType"]), int.Parse(receiptObj["recurringFrequency"]), (Convert.ToString(receiptObj["savingDate"]) != "") ? DateTime.Parse(receiptObj["savingDate"]) : null, System.Uri.UnescapeDataString(Convert.ToString(receiptObj["accountNumber"])), float.Parse(receiptObj["amount"]), Convert.ToString(receiptObj["remarks"]), int.Parse(receiptObj["eligibleCount"])); return(Ok(result)); }
public IHttpActionResult CopyPriviousReciept(TaxSavingModel ts) { if (ts.EmployeeId != Guid.Empty) { var Result = EmployeeRepository.CopyTaxSavingData(ts.EmployeeId, ts.currentYear - 1); return(Ok(Result)); } else { return(Ok()); } }
public IHttpActionResult ApproveTaxSavingReceipt(TaxSavingModel ts) { long result; JavaScriptSerializer serializer = new JavaScriptSerializer(); dynamic objReceiptsForApproval = serializer.Deserialize <object>(ts.jsonData); string receiptsForApprovalString = ""; for (int i = 0; i < objReceiptsForApproval.Length; i++) { if (i == 0) { receiptsForApprovalString = Convert.ToString(objReceiptsForApproval[i]["TaxSavingId"]); } else { receiptsForApprovalString = receiptsForApprovalString + ',' + Convert.ToString(objReceiptsForApproval[i]["TaxSavingId"]); } } result = TaxSavingsRepository.ApproveTaxSavingReceipt(receiptsForApprovalString); return(Ok(result)); }
public IHttpActionResult GetTaxSavingReceipt(TaxSavingModel ts) { DataSet ds = TaxSavingsRepository.GetTaxSavingReceipt(ts.EmployeeId, ts.FinancialYear); return(Ok(ds.Tables[0])); }