public List <M_Brand> GetItemsBrand(T_PurchaseOrderDetails Objmodel)
{
List <M_Brand> objBrandList = new List <M_Brand>();
try
{
using (_objUnitOfWork = new UnitOfWork())
{
var vQuery = _objUnitOfWork._T_PurchaseOrderDetails_Repository.Query();
var vQueryBrand = _objUnitOfWork._M_Brand_Repository.Query();
if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.ItemsId)))
{
vQuery = vQuery.Where(x => x.ItemsId == Objmodel.ItemsId && x.Quantity > 0);
}
var vJoinQuery = vQuery.Join(vQueryBrand, p => p.BrandId, b => b.Id, (p, b) => new { p, b }).ToList();
var vObjList = vJoinQuery.Select(x => new M_Brand()
{
Id = x.b.Id,
Name = x.b.Name
}).ToList();
objBrandList = vObjList;
}
}
catch (Exception ex)
{
throw ex;
}
return(objBrandList);
}
public List <T_PurchaseOrderDetails> GetItemsLatestStockDetail(T_PurchaseOrderDetails Objmodel)
{
List <T_PurchaseOrderDetails> objPurchaseList = new List <T_PurchaseOrderDetails>();
try
{
using (_objUnitOfWork = new UnitOfWork())
{
var vQuery = _objUnitOfWork._T_PurchaseOrderDetails_Repository.Query();
if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.ItemsId)) && !string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.BrandId)))
{
vQuery = vQuery.Where(x => x.ItemsId == Objmodel.ItemsId && x.BrandId == Objmodel.BrandId);
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.ItemsId)))
{
vQuery = vQuery.Where(x => x.ItemsId == Objmodel.ItemsId);
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.BrandId)))
{
vQuery = vQuery.Where(x => x.BrandId == Objmodel.BrandId);
}
objPurchaseList = vQuery.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(objPurchaseList);
}
public JsonResult GetItemsBrand(T_PurchaseOrderDetails ObjPurchaseOrder)
{
var ObjModelList = new List <M_Brand>();
try
{
ObjModelList = _blSalesOrder.GetItemsBrand(ObjPurchaseOrder);
}
catch (Exception ex)
{
throw ex;
}
return(Json(new { data = ObjModelList, Success = true }, JsonRequestBehavior.AllowGet));
}
public T_PurchaseOrderDetails DeletePurchaseOrderDetail(T_PurchaseOrderDetails ObjModel)
{
try
{
using (_objUnitOfWork = new UnitOfWork())
{
_objUnitOfWork._T_PurchaseOrderDetails_Repository.Delete(ObjModel.Id);
_objUnitOfWork.Save();
}
}
catch (Exception ex)
{
throw ex;
}
return(ObjModel);
}
public decimal GetItemsStockDetail(T_PurchaseOrderDetails Objmodel)
{
try
{
using (_objUnitOfWork = new UnitOfWork())
{
var vQueryPurchaseOrder = _objUnitOfWork._T_PurchaseOrderDetails_Repository.Query();
var vQuerySalesOrder = _objUnitOfWork._T_SalesOrderDetails_Repository.Query();
if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.ItemsId)) && !string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.BrandId)))
{
vQueryPurchaseOrder = vQueryPurchaseOrder.Where(x => x.ItemsId == Objmodel.ItemsId && x.BrandId == Objmodel.BrandId);
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.ItemsId)))
{
vQueryPurchaseOrder = vQueryPurchaseOrder.Where(x => x.ItemsId == Objmodel.ItemsId);
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.BrandId)))
{
vQueryPurchaseOrder = vQueryPurchaseOrder.Where(x => x.BrandId == Objmodel.BrandId);
}
if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.ItemsId)) && !string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.BrandId)))
{
vQuerySalesOrder = vQuerySalesOrder.Where(x => x.ItemsId == Objmodel.ItemsId && x.BrandId == Objmodel.BrandId);
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.ItemsId)))
{
vQuerySalesOrder = vQuerySalesOrder.Where(x => x.ItemsId == Objmodel.ItemsId);
}
else if (!string.IsNullOrWhiteSpace(Convert.ToString(Objmodel.BrandId)))
{
vQuerySalesOrder = vQuerySalesOrder.Where(x => x.BrandId == Objmodel.BrandId);
}
var vTotalPurchaseOrderQuantity = vQueryPurchaseOrder.ToList().Sum(x => x.Quantity);
var vTotalSalesOrderQuantity = vQuerySalesOrder.ToList().Sum(x => x.Quantity);
return(vTotalPurchaseOrderQuantity - vTotalSalesOrderQuantity);
}
}
catch (Exception ex)
{
throw ex;
}
}
public T_PurchaseOrderDetails GetByIdPurchaseOrderDetail(Guid UserId)
{
var ObjPurchaseOrder = new T_PurchaseOrderDetails();
try
{
using (_objUnitOfWork = new UnitOfWork())
{
ObjPurchaseOrder = _objUnitOfWork._T_PurchaseOrderDetails_Repository.GetById(UserId);
}
}
catch (Exception ex)
{
throw ex;
}
return(ObjPurchaseOrder);
}
public ActionResult DeletePurchaseOrderDetails(T_PurchaseOrderDetails ObjModel)
{
try
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(ObjModel.Id)))
{
var vObj = _blPurchaseOrder.GetByIdPurchaseOrderDetail(ObjModel.Id);
if (vObj != null)
{
_blPurchaseOrder.DeletePurchaseOrderDetail(ObjModel);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(ObjModel));
}
public bool GetFirstOrDefaultPruchaseOrderDetail(T_PurchaseOrderDetails Objmodel)
{
try
{
using (_objUnitOfWork = new UnitOfWork())
{
var vObj = _objUnitOfWork._T_PurchaseOrderDetails_Repository.GetFirstOrDefault(x => x.Id == Objmodel.Id);
if (vObj != null)
{
return(true);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(false);
}
public JsonResult GetItemsStock(T_PurchaseOrderDetails ObjPurchaseOrder)
{
var ObjModel = new T_PurchaseOrderDetails();
try
{
ObjModel.Quantity = _blSalesOrder.GetItemsStockDetail(ObjPurchaseOrder);
var vSellingPrice = _blSalesOrder.GetItemsLatestStockDetail(ObjPurchaseOrder).OrderByDescending(x => x.CreatedDate).FirstOrDefault();
if (vSellingPrice != null)
{
ObjModel.SellingRate = vSellingPrice.SellingRate;
ObjModel.UomId = vSellingPrice.UomId;
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(new { data = ObjModel, Success = true }, JsonRequestBehavior.AllowGet));
}
public ActionResult CreatePurchaseOrderDetails(T_PurchaseOrderDetails ObjModel)
{
try
{
if (!string.IsNullOrWhiteSpace(Convert.ToString(ObjModel.Id)))
{
var vObjExists = _blPurchaseOrder.GetByIdPurchaseOrderDetail(ObjModel.Id);
if (vObjExists == null)
{
Guid guidId = Guid.NewGuid();
Guid guidPurchaseOrderId = Guid.Parse(Convert.ToString(ObjModel.PurchaseOrderId));
Guid guidItemsId = Guid.Parse(Convert.ToString(ObjModel.ItemsId));
Guid guidBrandId = Guid.Parse(Convert.ToString(ObjModel.BrandId));
Guid guidGuageId = Guid.Parse(Convert.ToString(ObjModel.GuageId));
Guid guidUomId = Guid.Parse(Convert.ToString(ObjModel.UomId));
T_PurchaseOrderDetails _Obj_T_PurchaseOrder = new T_PurchaseOrderDetails()
{
Id = guidId,
PurchaseOrderId = guidPurchaseOrderId,
SlNo = ObjModel.SlNo,
ItemsId = guidItemsId,
BrandId = guidBrandId,
GuageId = guidGuageId,
UomId = guidUomId,
Quantity = ObjModel.Quantity,
BuyingRate = ObjModel.BuyingRate,
BuyingPrice = ObjModel.BuyingPrice,
SellingRate = ObjModel.SellingRate,
SellingPrice = ObjModel.SellingPrice,
DifferenceAmount = ObjModel.DifferenceAmount,
Remark = ObjModel.Remark,
CreatedBy = _objAuthentication.UserName,
CreatedDate = DateTime.Now
};
_blPurchaseOrder.CreatePurchaseOrderDetail(_Obj_T_PurchaseOrder);
return(Json(new { data = ObjModel, Success = true }, JsonRequestBehavior.AllowGet));
}
else
{
Guid guidId = Guid.Parse(Convert.ToString(ObjModel.Id));
Guid guidPurchaseOrderId = Guid.Parse(Convert.ToString(ObjModel.PurchaseOrderId));
Guid guidItemsId = Guid.Parse(Convert.ToString(ObjModel.ItemsId));
Guid guidBrandId = Guid.Parse(Convert.ToString(ObjModel.BrandId));
Guid guidGuageId = Guid.Parse(Convert.ToString(ObjModel.GuageId));
Guid guidUomId = Guid.Parse(Convert.ToString(ObjModel.UomId));
vObjExists.ItemsId = guidItemsId;
vObjExists.BrandId = guidBrandId;
vObjExists.GuageId = guidGuageId;
vObjExists.UomId = guidUomId;
vObjExists.Quantity = ObjModel.Quantity;
vObjExists.BuyingRate = ObjModel.BuyingRate;
vObjExists.BuyingPrice = ObjModel.BuyingPrice;
vObjExists.SellingRate = ObjModel.SellingRate;
vObjExists.SellingPrice = ObjModel.SellingPrice;
vObjExists.DifferenceAmount = ObjModel.DifferenceAmount;
vObjExists.Remark = ObjModel.Remark;
vObjExists.ModifyBy = _objAuthentication.UserName;
vObjExists.ModifyDate = DateTime.Now;
_blPurchaseOrder.UpdatePurchaseOrderDetail(vObjExists);
return(Json(new { data = ObjModel, Success = true }, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Json(new { data = ObjModel, Success = false }, JsonRequestBehavior.AllowGet));
}
