public static DataTableResponse GetOrderList(DataTableRequest dtParam)
{
using (var dbInvoice = new IncubXpertInvoicingDb())
{
IQueryable <Order> OrdersQuery = dbInvoice.Orders.AsNoTracking();
OrdersQuery = OrdersQuery.OrderByDescending(m => m.Id);
var totalCount = OrdersQuery.Count();
var OrderList = OrdersQuery.Skip(dtParam.start)
.Take(dtParam.length).ToList();
var List = OrderList.Select(c => new[] {
c.Id.ToString(),
c.OrderDate,
c.ScheduledDeliveryDate.ToString(),
c.TotalGst.ToString()
});
var dtResponse = new DataTableResponse()
{
draw = dtParam.draw,
recordsTotal = totalCount,
recordsFiltered = totalCount,
data = List.ToList()
};
return(dtResponse);
}
}
public static DataTableResponse GetCustomerMasterList(DataTableRequest dtParam)
{
using (var dbInvoice = new IncubXpertInvoicingDb())
{
IQueryable <MasterCustomer> OrdersQuery = dbInvoice.MasterCustomers.AsNoTracking();
OrdersQuery = OrdersQuery.OrderByDescending(m => m.Id);
var totalCount = OrdersQuery.Count();
var OrderList = OrdersQuery.Skip(dtParam.start)
.Take(dtParam.length).ToList();
var List = OrderList.Select(c => new[] {
c.Id.ToString(),
c.Name,
c.Address,
c.City,
c.Pincode,
c.ContactNo,
c.EmailId
});
var dtResponse = new DataTableResponse()
{
draw = dtParam.draw,
recordsTotal = totalCount,
recordsFiltered = totalCount,
data = List.ToList()
};
return(dtResponse);
}
}
public static DataTableResponse GetProductMasterList(DataTableRequest dtParam)
{
using (var dbInvoice = new IncubXpertInvoicingDb())
{
IQueryable <MasterProduct> MasterProductQuery = dbInvoice.MasterProducts.AsNoTracking();
MasterProductQuery = MasterProductQuery.OrderByDescending(m => m.Id);
var totalCount = MasterProductQuery.Count();
var OrderList = MasterProductQuery.Skip(dtParam.start)
.Take(dtParam.length).ToList();
var List = OrderList.Select(c => new[] {
c.Id.ToString(),
c.ProductName,
c.Category.ToString(),
c.Rate.ToString(),
c.GstRate.ToString()
});
var dtResponse = new DataTableResponse()
{
draw = dtParam.draw,
recordsTotal = totalCount,
recordsFiltered = totalCount,
data = List.ToList()
};
return(dtResponse);
}
}
public static void SaveCustomerMaster(MasterCustomer objMasterCustomer)
{
using (var dbInvoice = new IncubXpertInvoicingDb())
{
dbInvoice.MasterCustomers.AddOrUpdate(objMasterCustomer);
dbInvoice.SaveChanges();
}
}
public static MasterCustomer GetCustomer(int Id)
{
using (var dbInvoice = new IncubXpertInvoicingDb())
{
var query = from s in dbInvoice.MasterCustomers
where s.Id == Id
select s;
var result = query.FirstOrDefault();
return(result);
}
}
public static void DeleteCustomer(int Id)
{
using (var dbInvoice = new IncubXpertInvoicingDb())
{
var query = from s in dbInvoice.MasterCustomers
where s.Id == Id
select s;
var result = query.FirstOrDefault();
if (result != null)
{
dbInvoice.MasterCustomers.Remove(result);
dbInvoice.SaveChanges();
}
}
}
