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;
}
}
