public int BuildPaganationInvoiceList(InvoiceSearchModel model) { int NOP = 0; ShomaRMEntities db = new ShomaRMEntities(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetInvoicePaginationAndSearchData"; cmd.CommandType = CommandType.StoredProcedure; DbParameter param0 = cmd.CreateParameter(); param0.ParameterName = "FromDate"; param0.Value = model.FromDate; cmd.Parameters.Add(param0); DbParameter param1 = cmd.CreateParameter(); param1.ParameterName = "ToDate"; param1.Value = model.ToDate; cmd.Parameters.Add(param1); DbParameter param3 = cmd.CreateParameter(); param3.ParameterName = "PageNumber"; param3.Value = model.PageNumber; cmd.Parameters.Add(param3); DbParameter param4 = cmd.CreateParameter(); param4.ParameterName = "NumberOfRows"; param4.Value = model.NumberOfRows; cmd.Parameters.Add(param4); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } if (dtTable.Rows.Count > 0) { NOP = int.Parse(dtTable.Rows[0]["NumberOfPages"].ToString()); } db.Dispose(); return(NOP); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }
public ActionResult PopulateMonitorHeader(InvoiceSearchModel invoiceSearchModel) { DateTime?from = null; DateTime?to = null; if (!string.IsNullOrEmpty(invoiceSearchModel.InvoiceFrom)) { from = DateTime.ParseExact(invoiceSearchModel.InvoiceFrom, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); to = DateTime.ParseExact(invoiceSearchModel.InvoiceTo, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } var monitorHeader = _eZYMonitorExpHeaderService.GetMonitorExpHeaders(from, to, invoiceSearchModel.InvoiceNo); return(PartialView("~/Views/ezymonitor/_ezyMonitorHeader.cshtml", monitorHeader)); }
public async Task <ActionResult> Getlist(Guid id) { if (resToken != null) { var searchmodel = new InvoiceSearchModel() { PageIndex = 1, PageSize = 50, IsDesc = true, StartDate = "2018-10-01 00:00:00", EndDate = "2018-11-01 00:00:00" }; var sb = new StringBuilder(); sb.AppendFormat("pageIndex={0}&", searchmodel.PageIndex); sb.AppendFormat("pageSize={0}&", searchmodel.PageSize); sb.AppendFormat("IsDesc={0}&", searchmodel.IsDesc); sb.AppendFormat("startDate={0}&", searchmodel.StartDate); sb.AppendFormat("endDate={0}&", searchmodel.EndDate); string token = resToken.access_token; using (var client = new HttpClient()) using (var request = new HttpRequestMessage(HttpMethod.Get, $"https://efaturaservicetest.isim360.com/v1/outboxinvoice/list?{sb.ToString()}")) { request.Headers.Add("Authorization", $"Bearer {token}"); var response = await client.SendAsync(request); var asString = await response.Content.ReadAsStringAsync(); var x = JsonConvert.DeserializeObject <PagedList <OutboxInvoiceGetModel> >(asString); return(Ok(x)); } } else { return(Ok("Token almak için /gettoken uç noktasını çağırın")); } }
public List <InvoiceSearchModel> FillInvoiceSearchGrid(InvoiceSearchModel model) { ShomaRMEntities db = new ShomaRMEntities(); List <InvoiceSearchModel> lstInvoice = new List <InvoiceSearchModel>(); try { DataTable dtTable = new DataTable(); using (var cmd = db.Database.Connection.CreateCommand()) { db.Database.Connection.Open(); cmd.CommandText = "usp_GetInvoicePaginationAndSearchData"; cmd.CommandType = CommandType.StoredProcedure; DbParameter param0 = cmd.CreateParameter(); param0.ParameterName = "FromDate"; param0.Value = model.FromDate; cmd.Parameters.Add(param0); DbParameter param1 = cmd.CreateParameter(); param1.ParameterName = "ToDate"; param1.Value = model.ToDate; cmd.Parameters.Add(param1); DbParameter param3 = cmd.CreateParameter(); param3.ParameterName = "PageNumber"; param3.Value = model.PageNumber; cmd.Parameters.Add(param3); DbParameter param4 = cmd.CreateParameter(); param4.ParameterName = "NumberOfRows"; param4.Value = model.NumberOfRows; cmd.Parameters.Add(param4); DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter(); da.SelectCommand = cmd; da.Fill(dtTable); db.Database.Connection.Close(); } foreach (DataRow dr in dtTable.Rows) { InvoiceSearchModel searchmodel = new InvoiceSearchModel(); searchmodel.InvoiceID = Convert.ToInt32(dr["InvoiceID"].ToString()); searchmodel.InvoiceNumber = dr["InvoiceNumber"].ToString(); searchmodel.Vendor = dr["Vendor"].ToString(); searchmodel.InvoiceDate = dr["InvoiceDate"].ToString(); searchmodel.Approved = dr["Approved"].ToString(); searchmodel.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()).ToString("N2"); searchmodel.ApprovedBy = dr["ApprovedBy"].ToString(); searchmodel.ReceivedDate = dr["ReceivedDate"].ToString(); searchmodel.PaymentDate = dr["PaymentDate"].ToString(); searchmodel.CreatedDate = dr["CreatedDate"].ToString(); lstInvoice.Add(searchmodel); } db.Dispose(); return(lstInvoice.ToList()); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }