public ActionResult _Create(int Id, bool?IsSaleBased) //Id ==>Sale Order Header Id
{
SaleDeliveryHeader H = new SaleDeliveryHeaderService(_unitOfWork).Find(Id);
SaleDeliveryLineViewModel s = new SaleDeliveryLineViewModel();
//Getting Settings
var settings = new SaleDeliverySettingService(_unitOfWork).GetSaleDeliverySettingForDocument(H.DocTypeId, H.DivisionId, H.SiteId);
s.SaleDeliverySettings = Mapper.Map <SaleDeliverySetting, SaleDeliverySettingsViewModel>(settings);
s.DocumentTypeSettings = new DocumentTypeSettingsService(_unitOfWork).GetDocumentTypeSettingsForDocument(H.DocTypeId);
s.SaleDeliveryHeaderId = H.SaleDeliveryHeaderId;
s.SaleDeliveryHeaderDocNo = H.DocNo;
s.DocTypeId = H.DocTypeId;
s.SiteId = H.SiteId;
s.DivisionId = H.DivisionId;
ViewBag.LineMode = "Create";
PrepareViewBag();
if (IsSaleBased == true)
{
return(PartialView("_CreateForSaleOrder", s));
}
else
{
return(PartialView("_Create", s));
}
}
public JsonResult getunitconversiondetailjson(int productid, string unitid, string DealUnitId, int SaleDeliveryHeaderId)
{
SaleDeliveryHeader Delivery = new SaleDeliveryHeaderService(_unitOfWork).Find(SaleDeliveryHeaderId);
var Settings = new SaleDeliverySettingService(_unitOfWork).GetSaleDeliverySettingForDocument(Delivery.DocTypeId, Delivery.DivisionId, Delivery.SiteId);
if (Settings.UnitConversionForId.HasValue && Settings.UnitConversionForId > 0)
{
UnitConversion uc = new UnitConversionService(_unitOfWork).GetUnitConversionForUCF(productid, unitid, DealUnitId, Settings.UnitConversionForId ?? 0);
List <SelectListItem> unitconversionjson = new List <SelectListItem>();
if (uc != null)
{
unitconversionjson.Add(new SelectListItem
{
Text = uc.Multiplier.ToString(),
Value = uc.Multiplier.ToString()
});
}
else
{
unitconversionjson.Add(new SelectListItem
{
Text = "0",
Value = "0"
});
}
return(Json(unitconversionjson));
}
else
{
UnitConversion uc = new UnitConversionService(_unitOfWork).GetUnitConversion(productid, unitid, DealUnitId);
List <SelectListItem> unitconversionjson = new List <SelectListItem>();
if (uc != null)
{
unitconversionjson.Add(new SelectListItem
{
Text = uc.Multiplier.ToString(),
Value = uc.Multiplier.ToString()
});
}
else
{
unitconversionjson.Add(new SelectListItem
{
Text = "0",
Value = "0"
});
}
return(Json(unitconversionjson));
}
}
public ActionResult _ForOrder(int id)
{
SaleDeliveryFilterViewModel vm = new SaleDeliveryFilterViewModel();
vm.SaleDeliveryHeaderId = id;
SaleDeliveryHeader H = new SaleDeliveryHeaderService(_unitOfWork).Find(id);
var settings = new SaleDeliverySettingService(_unitOfWork).GetSaleDeliverySettingForDocument(H.DocTypeId, H.DivisionId, H.SiteId);
vm.SaleDeliverySettings = Mapper.Map <SaleDeliverySetting, SaleDeliverySettingsViewModel>(settings);
vm.DocumentTypeSettings = new DocumentTypeSettingsService(_unitOfWork).GetDocumentTypeSettingsForDocument(H.DocTypeId);
return(PartialView("_OrderFilters", vm));
}
private ActionResult _Modify(int id)
{
SaleDeliveryLine temp = _SaleDeliveryLineService.Find(id);
if (temp == null)
{
return(HttpNotFound());
}
#region DocTypeTimeLineValidation
try
{
TimePlanValidation = DocumentValidation.ValidateDocumentLine(new DocumentUniqueId {
LockReason = temp.LockReason
}, User.Identity.Name, out ExceptionMsg, out Continue);
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
TimePlanValidation = false;
}
if (!TimePlanValidation)
{
TempData["CSEXCL"] += ExceptionMsg;
}
#endregion
if ((TimePlanValidation || Continue))
{
ViewBag.LineMode = "Edit";
}
SaleDeliveryHeader H = new SaleDeliveryHeaderService(_unitOfWork).Find(temp.SaleDeliveryHeaderId);
PrepareViewBag();
SaleDeliveryLineViewModel vm = _SaleDeliveryLineService.GetSaleDeliveryLineForEdit(id);
//Getting Settings
var settings = new SaleDeliverySettingService(_unitOfWork).GetSaleDeliverySettingForDocument(H.DocTypeId, H.DivisionId, H.SiteId);
vm.SaleDeliverySettings = Mapper.Map <SaleDeliverySetting, SaleDeliverySettingsViewModel>(settings);
vm.DocumentTypeSettings = new DocumentTypeSettingsService(_unitOfWork).GetDocumentTypeSettingsForDocument(H.DocTypeId);
vm.SiteId = H.SiteId;
vm.DivisionId = H.DivisionId;
vm.DocTypeId = H.DocTypeId;
return(PartialView("_Create", vm));
}
public JsonResult GetProductDetailJson(int ProductId, int SaleDeliveryHeaderId)
{
ProductViewModel product = new ProductService(_unitOfWork).GetProduct(ProductId);
SaleDeliveryHeader Header = new SaleDeliveryHeaderService(_unitOfWork).Find(SaleDeliveryHeaderId);
//ProductViewModel ProductJson = new ProductViewModel();
//var DealUnitId = _SaleDeliveryLineService.GetSaleDeliveryLineList(SaleDeliveryHeaderId).OrderByDescending(m => m.SaleDeliveryLineId).FirstOrDefault();
var DealUnitId = _SaleDeliveryLineService.GetSaleDeliveryLineList(Header.SaleDeliveryHeaderId).OrderByDescending(m => m.SaleDeliveryLineId).FirstOrDefault();
var DlUnit = new UnitService(_unitOfWork).Find((DealUnitId == null) ? product.UnitId : DealUnitId.DealUnitId);
return(Json(new { ProductId = product.ProductId, StandardCost = product.StandardCost, UnitId = product.UnitId, UnitName = product.UnitName, DealUnitId = (DealUnitId == null) ? product.UnitId : DealUnitId.DealUnitId, DealUnitDecimalPlaces = DlUnit.DecimalPlaces, Specification = product.ProductSpecification, ProductCode = product.ProductCode, ProductName = product.ProductName }));
}
public JsonResult GetPendingSaleOrderCount(int ProductId, int SaleDeliveryHeaderId)
{
int BuyerId = new SaleDeliveryHeaderService(_unitOfWork).Find(SaleDeliveryHeaderId).SaleToBuyerId;
var temp = (from L in db.ViewSaleOrderBalance
where L.ProductId == ProductId && L.BuyerId == BuyerId
group new { L } by new { L.SaleOrderLineId } into Result
select new
{
Cnt = Result.Count()
}).FirstOrDefault();
if (temp != null)
{
return(Json(temp.Cnt));
}
else
{
return(null);
}
}
public ActionResult _Detail(int id)
{
SaleDeliveryLine temp = _SaleDeliveryLineService.Find(id);
SaleDeliveryHeader H = new SaleDeliveryHeaderService(_unitOfWork).Find(temp.SaleDeliveryHeaderId);
PrepareViewBag();
SaleDeliveryLineViewModel vm = _SaleDeliveryLineService.GetSaleDeliveryLineForEdit(id);
//Getting Settings
var settings = new SaleDeliverySettingService(_unitOfWork).GetSaleDeliverySettingForDocument(H.DocTypeId, H.DivisionId, H.SiteId);
vm.SaleDeliverySettings = Mapper.Map <SaleDeliverySetting, SaleDeliverySettingsViewModel>(settings);
if (temp == null)
{
return(HttpNotFound());
}
return(PartialView("_Create", vm));
}
public ActionResult _ResultsPost(SaleDeliveryListViewModel vm)
{
int Cnt = 0;
SaleDeliveryHeader Dh = new SaleDeliveryHeaderService(_unitOfWork).Find(vm.SaleDeliveryLineViewModel.FirstOrDefault().SaleDeliveryHeaderId);
SaleDeliverySetting Settings = new SaleDeliverySettingService(_unitOfWork).GetSaleDeliverySettingForDocument(Dh.DocTypeId, Dh.DivisionId, Dh.SiteId);
int pk = 0;
int PackingPrimaryKey = 0;
int DeliveryPrimaryKey = 0;
List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();
if (ModelState.IsValid)
{
foreach (var item in vm.SaleDeliveryLineViewModel)
{
decimal balqty = (from p in db.ViewSaleInvoiceBalanceForDelivery
where p.SaleInvoiceLineId == item.SaleInvoiceLineId
select p.BalanceQty).FirstOrDefault();
if (item.Qty > 0 && item.Qty <= balqty)
{
SaleDeliveryLine Dl = new SaleDeliveryLine();
Dl.UnitConversionMultiplier = item.UnitConversionMultiplier ?? 0;
Dl.DealQty = item.Qty * item.UnitConversionMultiplier ?? 0;
Dl.DealUnitId = item.DealUnitId;
Dl.CreatedBy = User.Identity.Name;
Dl.CreatedDate = DateTime.Now;
Dl.ModifiedBy = User.Identity.Name;
Dl.ModifiedDate = DateTime.Now;
Dl.SaleDeliveryHeaderId = Dh.SaleDeliveryHeaderId;
Dl.Qty = item.Qty;
Dl.Remark = item.Remark;
Dl.SaleInvoiceLineId = item.SaleInvoiceLineId;
Dl.SaleDeliveryLineId = DeliveryPrimaryKey++;
Dl.ObjectState = Model.ObjectState.Added;
_SaleDeliveryLineService.Create(Dl);
LineList.Add(new LineDetailListViewModel {
Amount = 0, Rate = 0, LineTableId = Dl.SaleDeliveryLineId, HeaderTableId = item.SaleDeliveryHeaderId, PersonID = Dh.SaleToBuyerId
});
pk++;
Cnt = Cnt + 1;
}
}
new SaleDeliveryHeaderService(_unitOfWork).Update(Dh);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Results", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Dh.DocTypeId,
DocId = Dh.SaleDeliveryHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Dh.DocNo,
DocDate = Dh.DocDate,
DocStatus = Dh.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
public ActionResult DeletePost(SaleDeliveryLineViewModel vm)
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
int?StockId = 0;
SaleDeliveryHeader Dh = new SaleDeliveryHeaderService(_unitOfWork).Find(vm.SaleDeliveryHeaderId);
int status = Dh.Status;
SaleDeliveryLine Dl = _SaleDeliveryLineService.Find(vm.SaleDeliveryLineId);
LogList.Add(new LogTypeViewModel
{
ExObj = Dl,
});
_SaleDeliveryLineService.Delete(Dl);
if (Dh.Status != (int)StatusConstants.Drafted)
{
Dh.Status = (int)StatusConstants.Modified;
new SaleDeliveryHeaderService(_unitOfWork).Update(Dh);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
PrepareViewBag();
return(PartialView("_Create", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Dh.DocTypeId,
DocId = Dh.SaleDeliveryHeaderId,
DocLineId = Dl.SaleDeliveryLineId,
ActivityType = (int)ActivityTypeContants.Deleted,
DocNo = Dh.DocNo,
xEModifications = Modifications,
DocDate = Dh.DocDate,
DocStatus = Dh.Status,
}));
return(Json(new { success = true }));
}
//[ValidateAntiForgeryToken]
public ActionResult _CreatePost(SaleDeliveryLineViewModel svm)
{
SaleDeliverySetting Settings = new SaleDeliverySettingService(_unitOfWork).GetSaleDeliverySettingForDocument(svm.DocTypeId, svm.DivisionId, svm.SiteId);
SaleDeliveryHeader Dh = new SaleDeliveryHeaderService(_unitOfWork).Find(svm.SaleDeliveryHeaderId);
if (svm.SaleDeliveryLineId <= 0)
{
ViewBag.LineMode = "Create";
}
else
{
ViewBag.LineMode = "Edit";
}
if (svm.SaleInvoiceLineId <= 0)
{
ModelState.AddModelError("SaleInvoiceLineId", "Sale Invoice field is required");
}
if (svm.Qty <= 0)
{
ModelState.AddModelError("Qty", "The Qty field is required");
}
if (ModelState.IsValid)
{
if (svm.SaleDeliveryLineId <= 0)
{
SaleDeliveryLine Dl = Mapper.Map <SaleDeliveryLineViewModel, SaleDeliveryLine>(svm);
Dl.SaleDeliveryHeaderId = Dh.SaleDeliveryHeaderId;
Dl.CreatedBy = User.Identity.Name;
Dl.CreatedDate = DateTime.Now;
Dl.ModifiedBy = User.Identity.Name;
Dl.ModifiedDate = DateTime.Now;
Dl.ObjectState = Model.ObjectState.Added;
_SaleDeliveryLineService.Create(Dl);
if (Dh.Status != (int)StatusConstants.Drafted)
{
Dh.Status = (int)StatusConstants.Modified;
}
new SaleDeliveryHeaderService(_unitOfWork).Update(Dh);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
PrepareViewBag();
return(PartialView("_Create", svm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Dh.DocTypeId,
DocId = Dl.SaleDeliveryHeaderId,
DocLineId = Dl.SaleDeliveryLineId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = Dh.DocNo,
DocDate = Dh.DocDate,
DocStatus = Dh.Status,
}));
return(RedirectToAction("_Create", new { id = Dh.SaleDeliveryHeaderId }));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
int status = Dh.Status;
SaleDeliveryLine Dl = _SaleDeliveryLineService.Find(svm.SaleDeliveryLineId);
SaleDeliveryLine ExRecD = new SaleDeliveryLine();
ExRecD = Mapper.Map <SaleDeliveryLine>(Dl);
Dl.SaleInvoiceLineId = svm.SaleInvoiceLineId;
Dl.Qty = svm.Qty;
Dl.DealQty = svm.DealQty;
Dl.DealUnitId = svm.DealUnitId;
Dl.Remark = svm.Remark;
_SaleDeliveryLineService.Update(Dl);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRecD,
Obj = Dl,
});
if (Dh.Status != (int)StatusConstants.Drafted)
{
Dh.Status = (int)StatusConstants.Modified;
new SaleDeliveryHeaderService(_unitOfWork).Update(Dh);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
PrepareViewBag();
return(PartialView("_Create", svm));
}
//Saving the Activity Log
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Dh.DocTypeId,
DocId = Dl.SaleDeliveryHeaderId,
DocLineId = Dl.SaleDeliveryLineId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = Dh.DocNo,
xEModifications = Modifications,
DocDate = Dh.DocDate,
DocStatus = Dh.Status,
}));
//End of Saving the Activity Log
return(Json(new { success = true }));
}
}
PrepareViewBag();
return(PartialView("_Create", svm));
}
