public ReceiptsInputModel Get() { ReceiptsInputModel input = new ReceiptsInputModel(); DataTable dt = new DataTable(); string JsonString = string.Empty; JsonString = JsonConvert.SerializeObject(dt); input.plantcd = input.getDataFromDB("exec helper.usp_Detailed_Receipts_inputs 'plantcd'", " "); input.suppliersitename = input.getDataFromDB("exec helper.usp_Detailed_Receipts_inputs 'suppliersitename'", " "); input.ParentSupplierName = input.getDataFromDB("exec helper.usp_Detailed_Receipts_inputs 'ParentSupplierName'", " "); return(input); }
public ReceiptsOutputModel Post(ReceiptsInputModel model) { ReceiptsOutputModel result = new ReceiptsOutputModel(); ReceiptsInputModel action = new ReceiptsInputModel(); DataTable dt = new DataTable(); string JsonString = string.Empty; JsonString = JsonConvert.SerializeObject(dt); if (model.dataflag == "Summary") { result.Summary = action.getDataFromDB("EXEC [helper].[usp_Detailed_Receipts_report_data] '" + model.dataflag + "','" + model.materialnum + "','" + model.plantcd + "','" + model.fromdate + "','" + model.todate + "','" + model.suppliersitename + "','" + model.ParentSupplierName + "'", " "); } else if (model.dataflag == "Detailed") { result.Detailed = action.getDataFromDB("EXEC [helper].[usp_Detailed_Receipts_report_data] '" + model.dataflag + "','" + model.materialnum + "','" + model.plantcd + "','" + model.fromdate + "','" + model.todate + "','" + model.suppliersitename + "','" + model.ParentSupplierName + "'", " "); } result.exportFilename = writeExcelFile(result, model.dataflag); return(result); }
// GET api/values // GET api/values/5 public string Get(int id) { ReceiptsInputModel model = new ReceiptsInputModel(); var str = ""; var query = ""; if (id == 1) { str = HttpContext.Current.Request.LogonUserIdentity.Name.ToString(); query = "dbo.usp_gscobi_app_assitant '" + str + "','login'"; } if (id == 2) { str = HttpContext.Current.Request.LogonUserIdentity.Name.ToString(); str = str.Replace("AMAT\\", ""); query = "insert into [GSCA_APPS].[dbo].[gscobi_apps_users_access_log] values ('" + str + "','DetailedReceipts',GETDATE())"; } if (id == 3) { str = HttpContext.Current.Request.LogonUserIdentity.Name.ToString(); str = str.Replace("AMAT\\", ""); query = "select EMPLOYEE_NTID, Favouriteslist from [dbo].[gscobi_apps_users_favourites_list] where [EMPLOYEE_NTID]='" + str + "' and [APPLICATION_NAME] = 'DetailedReceipts'"; } if (id == 4) { query = "select max(receipt_date) refreshdate from gsca_apps.helper.detailed_receipts_app_receipt"; } return(model.getDataFromDB(query, " "));; }