public PaggingData salessettlement(int list, int page)
{
try
{
PaggingData data = new PaggingData();
var total_count = db.OrderDispatchedMasters.Where(x => x.Deleted == false && x.Status == "Partial receiving -Bounce").Count();
var ordermaster = db.OrderDispatchedMasters.Where(x => x.Deleted == false && x.Status == "Partial receiving -Bounce").OrderByDescending(x => x.OrderId).Skip((page - 1) * list).Take(list).ToList();
data.ordermaster = ordermaster;
data.total_count = total_count;
return(data);
}
catch (Exception ex)
{
return(null);
}
}
public async Task <PaggingData <CustomersDto> > Handle(GetCustomersQuery request, CancellationToken cancellationToken)
{
var output = new PaggingData <CustomersDto>();
output.List = await context.Customers.Where(c => (string.IsNullOrEmpty(request.Name) || (c.FirstName + " " + c.LastName).Contains(request.Name)) &&
(string.IsNullOrEmpty(request.Email) || c.Email.Contains(request.Email)) &&
(string.IsNullOrEmpty(request.PhoneNumber) || c.PhoneNumber.Contains(request.PhoneNumber)))
.OrderByDescending(c => c.Id).Skip(request.PageNumber * request.RowCount).Take(request.RowCount)
.ProjectTo <CustomersDto>(mapper.ConfigurationProvider).AsNoTracking().ToListAsync(cancellationToken);
output.TotalLength = await context.Customers.Where(c => (string.IsNullOrEmpty(request.Name) || (c.FirstName + " " + c.LastName).Contains(request.Name)) &&
(string.IsNullOrEmpty(request.Email) || c.Email.Contains(request.Email)) &&
(string.IsNullOrEmpty(request.PhoneNumber) || c.PhoneNumber.Contains(request.PhoneNumber))).CountAsync(cancellationToken);
return(output);
}
public HttpResponseMessage get(int list, int page)
{
try
{
var sc = context.DreamOrderDb.Where(x => x.Deleted == false).OrderByDescending(x => x.Order_Id).Skip((page - 1) * list).Take(list).ToList();
PaggingData obj = new PaggingData();
obj.total_count = context.DreamOrderDb.Count();
obj.ordermaster = sc;
return(Request.CreateResponse(HttpStatusCode.OK, obj));
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
public PaggingData GetSupplier(int list, int page, string SupplierCode)
{
AuthContext db = new AuthContext();
logger.Info("start ItemMaster: ");
try
{
PaggingData obj = new PaggingData();
obj.total_count = db.itemMasters.Where(x => x.SUPPLIERCODES == SupplierCode).Count();
obj.ordermaster = db.itemMasters.AsEnumerable().Where(x => x.SUPPLIERCODES == SupplierCode).Skip((page - 1) * list).Take(list).ToList();
logger.Info("End ItemMaster: ");
return(obj);
}
catch (Exception ex)
{
logger.Error("Error in ItemMaster " + ex.Message);
logger.Info("End ItemMaster: ");
return(null);
}
}
public HttpResponseMessage Get(int list, int page)
{
logger.Info("start OrderMaster: ");
PaggingData obj = new PaggingData();
try
{
var identity = User.Identity as ClaimsIdentity;
int compid = 0, userid = 0;
foreach (Claim claim in identity.Claims)
{
if (claim.Type == "compid")
{
compid = int.Parse(claim.Value);
}
if (claim.Type == "userid")
{
userid = int.Parse(claim.Value);
}
}
logger.Info("User ID : {0} , Company Id : {1}", compid, userid);
var newdata = context.DbOrderMaster.Where(x => x.Deleted == false && x.Status == "Pending").OrderByDescending(x => x.OrderId).Skip((page - 1) * list).Take(list).ToList();
obj.total_count = context.DbOrderMaster.Where(x => x.Deleted == false && x.Status == "Pending").Count();
obj.ordermaster = newdata;
logger.Info("End OrderMaster: ");
return(Request.CreateResponse(HttpStatusCode.OK, obj));
}
catch (Exception ex)
{
logger.Error("Error in OrderMaster " + ex.Message);
logger.Info("End OrderMaster: ");
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
