public bool Update([FromBody] SpareMaster _oSpareMaster)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.SpareMasters
.Where(s => s.SpareID == _oSpareMaster.SpareID)
.FirstOrDefault();
// var input = context.SpareMasters.First<SpareMaster>();
input.SpareName = _oSpareMaster.SpareName;
input.Stock = _oSpareMaster.Stock;
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult FilterByDate(long distributorId, int month, int year)
{
try
{
var output = context.DistributorBills
.Include(i => i.Invoice)
.Include(i => i.ClientMaster)
.Include(i => i.ProductMaster)
.Include(i => i.Order)
.Include(i => i.Distributor)
.Include(i => i.PaymentStatus)
.OrderByDescending(o => o.CreatedOn)
.Where(
w => (distributorId == 0 ? true : w.DistributorID == distributorId) &&
(month == 0 ? true : w.CreatedOn.Month == month) &&
(year == 0 ? true : w.CreatedOn.Year == year)
).ToList();
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Update([FromBody] DistributorBill _oDistributorBill)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.DistributorBills
.Where(s => s.DistributorBillID == _oDistributorBill.DistributorBillID)
.FirstOrDefault();
input.PaymentModeID = _oDistributorBill.PaymentModeID;
input.PaymentStatusID = _oDistributorBill.PaymentStatusID;
input.ModifiedOn = DateTime.Now;
if (_oDistributorBill.PaymentStatusID == 1 && input.PaymentDate == null)
{
input.PaymentDate = DateTime.Now;
}
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Add([FromBody] List <License> listOfLicense)
{
try
{
int output = 0;
foreach (var item in listOfLicense)
{
using (var context = new DB001Core())
{
context.Licenses.Add(item);
output = context.SaveChanges();
}
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Update([FromBody] List <License> listOfLicense)
{
try
{
int output = 0;
foreach (var item in listOfLicense)
{
using (var context = new DB001Core())
{
var input = context.Licenses
.Where(s => s.LicenseID == item.LicenseID)
.FirstOrDefault();
input.TotalLicense = item.TotalLicense;
input.LicenseDueDate = item.LicenseDueDate;
output = context.SaveChanges();
}
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult GetLGetProductListist(long clientId)
{
try
{
var license = context.Licenses
.Where(s => s.ClientID == clientId)
.ToList();
var output = new List <ProductMaster>();
if (license.Count == 0)
{
output = context.ProductMasters.ToList();
}
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Update([FromBody] DistrictMaster _oDistrictMaster)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.DistrictMasters
.Where(w => w.DistrictID == _oDistrictMaster.DistrictID)
.FirstOrDefault();
input.DistrictName = _oDistrictMaster.DistrictName;
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Update([FromBody] InventoryMaster _oInventoryMaster)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.InventoryMasters
.Where(s => s.InventoryID == _oInventoryMaster.InventoryID)
.FirstOrDefault();
input.ReferenceNumber = _oInventoryMaster.ReferenceNumber;
input.InventoryType = _oInventoryMaster.InventoryType;
input.WarrantyDate = _oInventoryMaster.WarrantyDate;
input.DeviceID = _oInventoryMaster.DeviceID;
input.SpareID = _oInventoryMaster.SpareID;
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Update([FromBody] Distributor _oDistributor)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.Distributors
.Where(w => w.DistributorID == _oDistributor.DistributorID)
.FirstOrDefault();
input.DistributorName = _oDistributor.DistributorName;
input.Email = _oDistributor.Email;
input.MobileNo = _oDistributor.MobileNo;
input.Address = _oDistributor.Address;
input.IsActive = _oDistributor.IsActive;
input.CityID = _oDistributor.CityID;
input.DistrictID = _oDistributor.DistrictID;
input.StateID = _oDistributor.StateID;
input.ModifiedOn = DateTime.Now;
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult GetList()
{
try
{
var output = context.Dispatchs
.Include(i => i.ClientMaster)
.Include(i => i.ProductMaster)
.Include(i => i.Order)
.Include(i => i.StateMaster)
.Include(i => i.DistrictMaster)
.Include(i => i.CityMaster)
.Where(w => w.IsDeleted == false)
.OrderBy(o => o.IsDispatched)
.ThenByDescending(o => o.DispatchDate)
.ThenByDescending(o => o.CreatedOn)
.ToList();
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public int ChangeOrderStatus(long orderId, string newStatus)
{
var output = 0;
long currentStatusId = 0;
long newStatusId = 0;
var oCurrentStatus = context.Orders
.Where(w => w.OrderID == orderId)
.FirstOrDefault();
var oNewStatus = context.OrderStatuss
.Where(w => w.Status == newStatus)
.FirstOrDefault();
if (oCurrentStatus != null && oNewStatus != null)
{
currentStatusId = oCurrentStatus.OrderStatusID;
newStatusId = oNewStatus.OrderStatusID;
if (currentStatusId < newStatusId)
{
using (var context = new DB001Core())
{
var input = context.Orders
.Where(w => w.OrderID == orderId)
.FirstOrDefault();
input.OrderStatusID = newStatusId;
output = context.SaveChanges();
}
}
}
return(output);
}
public bool Add([FromBody] Order _oOrder)
{
try
{
int output;
using (var context = new DB001Core())
{
CommonLogic clsCommonLogic = new CommonLogic();
_oOrder.OrderNumber = clsCommonLogic.GenerateOrderNumber();
_oOrder.OrderDate = DateTime.Now;
_oOrder.OrderStatusID = 1;
_oOrder.CreatedOn = DateTime.Now;
context.Orders.Add(_oOrder);
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Update([FromBody] Dispatch _oDispatch)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.Dispatchs
.Include(d => d.DispatchDetails)
.Where(s => s.DispatchID == _oDispatch.DispatchID)
.FirstOrDefault();
input.ClientID = _oDispatch.ClientID;
input.ProductID = _oDispatch.ProductID;
input.StateID = _oDispatch.StateID;
input.DistrictID = _oDispatch.DistrictID;
input.CityID = _oDispatch.CityID;
input.ShippingAddress = _oDispatch.ShippingAddress;
input.DispatchDate = _oDispatch.DispatchDate;
input.DispatchDetails = _oDispatch.DispatchDetails;
input.IsDispatched = _oDispatch.IsDispatched;
input.ModifiedOn = DateTime.Now;
if (_oDispatch.IsDispatched == true)
{
if (input.DispatchDate == null)
{
input.DispatchDate = DateTime.Now;
}
}
output = context.SaveChanges();
}
if (_oDispatch.IsDispatched == true)
{
var invoice = context.Invoices
.Where(w => w.OrderID == _oDispatch.OrderID && w.PaymentStatus.Status == "Pending")
.FirstOrDefault();
if (invoice != null)
{
invoice.PaymentStatusID = 2; //Unpaid
context.SaveChanges();
}
CommonLogic commonLogic = new CommonLogic();
commonLogic.ChangeOrderStatus(_oDispatch.OrderID, "Delivered");
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult Existance(long inventoryId)
{
try
{
bool output = false;
var inventory = context.DispatchDetails
.Where(s => s.InventoryID == inventoryId)
.FirstOrDefault();
if (inventory != null)
{
output = true;
}
else
{
output = false;
}
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult GetList()
{
try
{
var output = context.UserMasters
.Include(i => i.ProfileMaster)
.Where(
w => w.ProfileMaster.ProfileName != "Superadmin" &&
w.ProfileMaster.ProfileName != "Administrator" &&
w.ProfileMaster.ProfileName != "Inventory Supervisor" &&
w.ProfileMaster.ProfileName != "Account Manager"
)
.ToList();
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult Get(long invoiceId)
{
try
{
var output = context.Invoices
.Where(s => s.InvoiceID == invoiceId)
.FirstOrDefault();
output.InvoiceDetails = context.InvoiceDetails
.Include(i => i.InventoryMaster.DeviceMaster)
.Include(i => i.InventoryMaster.SpareMaster)
.Include(i => i.InvoiceHeader)
.Where(w => w.InvoiceID == invoiceId)
.ToList();
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool UpdateStatus([FromBody] UserMaster _oUserMaster)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.UserMasters
.Where(s => s.UserID == _oUserMaster.UserID)
.FirstOrDefault();
input.IsActive = _oUserMaster.IsActive;
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Add([FromBody] ClientMaster _oClientMaster)
{
try
{
CommonLogic clsCommon = new CommonLogic();
_oClientMaster.ClientCode = clsCommon.GenerateClientCode(_oClientMaster.ClientName);
int output;
using (var context = new DB001Core())
{
context.ClientMasters.Add(_oClientMaster);
output = context.SaveChanges();
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult MakeInvoice([FromBody] Dispatch _oDispatch)
{
try
{
FileResult fileResult;
var output = context.Dispatchs
.Include(i => i.ClientMaster)
.Where(w => w.DispatchID == _oDispatch.DispatchID)
.FirstOrDefault();
var company = context.Companys.FirstOrDefault();
CommonLogic commonLogic = new CommonLogic();
string body = commonLogic.CreateShippingBody(_hostingEnvironment.WebRootPath, output, company);
fileResult = commonLogic.ConvertHtmlToPdf(body, output.DispatchNumber);
return(Json(fileResult));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Add([FromBody] Dispatch _oDispatch)
{
try
{
int output;
using (var context = new DB001Core())
{
CommonLogic clsCommonLogic = new CommonLogic();
_oDispatch.DispatchNumber = clsCommonLogic.GenerateDispatchCode();
_oDispatch.CreatedOn = DateTime.Now;
_oDispatch.ModifiedOn = DateTime.Now;
_oDispatch.IsDeleted = false;
context.Dispatchs.Add(_oDispatch);
output = context.SaveChanges();
}
CommonLogic commonLogic = new CommonLogic();
commonLogic.ChangeOrderStatus(_oDispatch.OrderID, "Device Ready");
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult DraftAvailable(long orderId)
{
try
{
bool draftAvailable = false;
var output = context.Invoices
.Where(w => w.OrderID == orderId)
.FirstOrDefault();
if (output != null)
{
draftAvailable = true;
}
else
{
draftAvailable = false;
}
return(Json(draftAvailable));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult GetInventoryList(bool isEditable)
{
try
{
if (isEditable == false)
{
var output = context.InventoryMasters
.FromSql("Select * from InventoryMasters i where i.InventoryID not in (select InventoryID from DispatchDetails dd inner join Dispatchs d on dd.DispatchID = d.DispatchID where d.IsDeleted = 0)")
.Include(d => d.DeviceMaster)
.Include(d => d.SpareMaster)
.ToList();
return(Json(output));
}
else
{
var output = context.InventoryMasters
.Include(d => d.DeviceMaster)
.Include(d => d.SpareMaster)
.ToList();
return(Json(output));
}
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Update([FromBody] Order _oOrder)
{
try
{
int output;
using (var context = new DB001Core())
{
var input = context.Orders
.Where(w => w.OrderID == _oOrder.OrderID)
.FirstOrDefault();
input.ClientTypeID = _oOrder.ClientTypeID;
input.DeadlineDate = _oOrder.DeadlineDate;
input.ModifiedOn = DateTime.Now;
input.ModifiedBy = _oOrder.ModifiedBy;
if (_oOrder.OrderStatusID != 0)
{
input.OrderStatusID = _oOrder.OrderStatusID;
}
output = context.SaveChanges();
//Cancel Order
if (_oOrder.OrderStatusID == 6)
{
var dispatch = context.Dispatchs
.Where(w => w.OrderID == _oOrder.OrderID)
.FirstOrDefault();
if (dispatch != null)
{
dispatch.IsDeleted = true;
var update = context.SaveChanges();
}
var invoice = context.Invoices
.Where(w => w.OrderID == _oOrder.OrderID)
.FirstOrDefault();
if (invoice != null)
{
invoice.IsDeleted = true;
var update = context.SaveChanges();
}
}
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Add([FromBody] Invoice _oInvoice)
{
try
{
int output;
CommonLogic clsCommonLogic = new CommonLogic();
_oInvoice.InvoiceNumber = clsCommonLogic.GenerateInvoiceNumber();
_oInvoice.CreatedOn = DateTime.Now;
_oInvoice.ModifiedOn = DateTime.Now;
_oInvoice.IsDeleted = false;
using (var context = new DB001Core())
{
context.Invoices.Add(_oInvoice);
output = context.SaveChanges();
}
if (!_oInvoice.IsDraft)
{
using (var context = new DB001Core())
{
var input = context.Orders
.Include(i => i.OrderStatus)
.Where(o => o.OrderID == _oInvoice.OrderID && (o.OrderStatus.Status == "Pending" || o.OrderStatus.Status == "Device Ready" || o.OrderStatus.Status == "Delivered"))
.FirstOrDefault();
if (input != null)
{
if (input.OrderStatus.Status == "Pending" || input.OrderStatus.Status == "Device Ready")
{
input.OrderStatusID = 3;
}
else if (input.OrderStatus.Status == "Delivered" || _oInvoice.PaymentStatusID == 1) //Paid
{
input.OrderStatusID = 5;
}
var status = context.SaveChanges();
}
}
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult StockRegister()
{
DashboardStockRegister dashboard = new DashboardStockRegister();
try
{
var orderCount = context.Orders
.Include(i => i.OrderStatus)
.Where(w => w.OrderStatus.Status == "Pending")
.Count();
var pendingOrders = context.Orders
.Include(i => i.ClientMaster)
.Include(i => i.ProductMaster)
.Where(w => w.OrderStatus.Status == "Pending")
.ToList();
var devices = context.DeviceMasters.ToList();
var pendingDispatchCount = context.Dispatchs
.Where(w => w.IsDispatched == false && w.IsDeleted == false)
.Count();
var totalDispatchCount = context.Dispatchs
.Where(w => w.IsDispatched == true && w.IsDeleted == false)
.Count();
var spares = context.SpareMasters.ToList();
var inventoryCount = context.InventoryMasters.Count();
var dispatchDetailCount = context.DispatchDetails.Count();
var deviceCount = (from t in devices select t.Stock).Sum();
var spareCount = (from t in spares select t.Stock).Sum();
dashboard.PendingOrderCount = orderCount;
dashboard.PendingDispatchCount = pendingDispatchCount;
dashboard.AvailabaleInventory = inventoryCount - dispatchDetailCount;
dashboard.AvailabaleDevices = deviceCount;
dashboard.AvailabaleSpares = spareCount;
dashboard.TotalDispatchCount = totalDispatchCount;
dashboard.PendingOrders = pendingOrders;
return(Json(dashboard));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
dashboard = null;
}
}
public JsonResult MakeInvoice([FromBody] Invoice _oInvoice)
{
try
{
FileResult fileResult;
var output = context.Invoices
.Include(i => i.Order)
.Include(i => i.ClientMaster)
.Include(i => i.ClientMaster.StateMaster)
.Include(i => i.ClientMaster.DistrictMaster)
.Include(i => i.ClientMaster.CityMaster)
.Include(i => i.ProductMaster)
.Where(w => w.InvoiceID == _oInvoice.InvoiceID && w.IsDraft == false)
.FirstOrDefault();
if (output != null)
{
output.InvoiceDetails = context.InvoiceDetails
.Include(i => i.InventoryMaster)
.Include(i => i.InventoryMaster.DeviceMaster)
.Include(i => i.InventoryMaster.SpareMaster)
.Include(i => i.InvoiceHeader)
.Where(w => w.InvoiceID == _oInvoice.InvoiceID)
.ToList();
if (output.InvoiceDetails != null)
{
var company = context.Companys.FirstOrDefault();
CommonLogic commonLogic = new CommonLogic();
string body = commonLogic.CreateInvoiceBody(_hostingEnvironment.WebRootPath, output, company);
fileResult = commonLogic.ConvertHtmlToPdf(body, output.InvoiceNumber);
}
else
{
fileResult = null;
}
}
else
{
fileResult = null;
}
return(Json(fileResult));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public async Task <bool> Update([FromBody] UserMaster _oUserMaster)
{
try
{
int output = 0;
UserViewModel userViewModel = new UserViewModel
{
Name = _oUserMaster.Name,
UserName = _oUserMaster.UserName,
Password = _oUserMaster.Password
};
ApplicationUser applicationUser = applicationDbContext.Users
.Where(w => w.UserName == _oUserMaster.UserName)
.FirstOrDefault();
if (applicationUser != null)
{
UserController userController = new UserController(userManager, roleManager);
var appOutput = await userController.UpdateUser(applicationUser.Id, userViewModel);
if (Convert.ToBoolean(appOutput.Value))
{
using (var context = new DB001Core())
{
var input = context.UserMasters
.Where(s => s.UserID == _oUserMaster.UserID)
.FirstOrDefault();
if (_oUserMaster.Password != "")
{
input.Password = _oUserMaster.Password;
}
input.Name = _oUserMaster.Name;
input.MobileNo = _oUserMaster.MobileNo;
input.IsActive = _oUserMaster.IsActive;
output = context.SaveChanges();
}
}
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public bool Delete([FromBody] InventoryMaster _oInventoryMaster)
{
try
{
int output;
using (var context = new DB001Core())
{
context.Remove <InventoryMaster>(_oInventoryMaster);
output = context.SaveChanges();
}
if (_oInventoryMaster.DeviceID != null)
{
using (var context = new DB001Core())
{
var input = context.DeviceMasters
.Where(s => s.DeviceID == _oInventoryMaster.DeviceID)
.FirstOrDefault();
input.Stock = input.Stock + 1;
output = context.SaveChanges();
}
}
if (_oInventoryMaster.SpareID != null)
{
using (var context = new DB001Core())
{
var input = context.SpareMasters
.Where(s => s.SpareID == _oInventoryMaster.SpareID)
.FirstOrDefault();
input.Stock = input.Stock + 1;
output = context.SaveChanges();
}
}
return(Convert.ToBoolean(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult GetList()
{
try
{
var output = context.ClientMasters.ToList();
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
public JsonResult GetOrderStatusList()
{
try
{
var output = context.OrderStatuss.ToList();
return(Json(output));
}
catch (Exception ex)
{
throw;
}
finally
{
context = null;
}
}
