private ActionResult _Delete(int id)
{
SaleDispatchReturnLineViewModel temp = _SaleDispatchReturnLineService.GetSaleDispatchReturnLine(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 = "Delete";
}
PrepareViewBag(temp);
SaleDispatchReturnHeader H = new SaleDispatchReturnHeaderService(_unitOfWork).Find(temp.SaleDispatchReturnHeaderId);
//Getting Settings
var settings = new SaleDispatchSettingService(_unitOfWork).GetSaleDispatchSettingForDocument(H.DocTypeId, H.DivisionId, H.SiteId);
temp.SaleDispatchSettings = Mapper.Map <SaleDispatchSetting, SaleDispatchSettingsViewModel>(settings);
return(PartialView("_Create", temp));
}
public ActionResult _Detail(int id)
{
SaleDispatchReturnLineViewModel temp = _SaleDispatchReturnLineService.GetSaleDispatchReturnLine(id);
if (temp == null)
{
return(HttpNotFound());
}
PrepareViewBag(temp);
SaleDispatchReturnHeader H = new SaleDispatchReturnHeaderService(_unitOfWork).Find(temp.SaleDispatchReturnHeaderId);
//Getting Settings
var settings = new SaleDispatchSettingService(_unitOfWork).GetSaleDispatchSettingForDocument(H.DocTypeId, H.DivisionId, H.SiteId);
temp.SaleDispatchSettings = Mapper.Map <SaleDispatchSetting, SaleDispatchSettingsViewModel>(settings);
return(PartialView("_Create", temp));
}
public ActionResult _Create(int Id, int sid) //Id ==>Sale Order Header Id
{
SaleDispatchReturnHeader H = new SaleDispatchReturnHeaderService(_unitOfWork).Find(Id);
SaleDispatchReturnLineViewModel s = new SaleDispatchReturnLineViewModel();
//Getting Settings
var settings = new SaleDispatchSettingService(_unitOfWork).GetSaleDispatchSettingForDocument(H.DocTypeId, H.DivisionId, H.SiteId);
s.SaleDispatchSettings = Mapper.Map <SaleDispatchSetting, SaleDispatchSettingsViewModel>(settings);
s.SaleDispatchReturnHeaderId = H.SaleDispatchReturnHeaderId;
s.SaleDispatchReturnHeaderDocNo = H.DocNo;
s.GodownId = H.GodownId;
s.BuyerId = sid;
ViewBag.LineMode = "Create";
//PrepareViewBag(null);
return(PartialView("_Create", s));
}
//[ValidateAntiForgeryToken]
public ActionResult DeletePost(SaleInvoiceReturnLineViewModel vm)
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
int?StockId = 0;
SaleInvoiceReturnLine SaleInvoiceReturnLine = _SaleInvoiceReturnLineService.Find(vm.SaleInvoiceReturnLineId);
LogList.Add(new LogTypeViewModel
{
ExObj = SaleInvoiceReturnLine,
});
int?SaleDispatchReturnLineId = SaleInvoiceReturnLine.SaleDispatchReturnLineId;
var chargeslist = new SaleInvoiceReturnLineChargeService(_unitOfWork).GetCalculationProductList(vm.SaleInvoiceReturnLineId);
if (chargeslist != null)
{
foreach (var item in chargeslist)
{
new SaleInvoiceReturnLineChargeService(_unitOfWork).Delete(item.Id);
}
}
if (vm.footercharges != null)
{
foreach (var item in vm.footercharges)
{
var footer = new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Find(item.Id);
footer.Rate = item.Rate;
footer.Amount = item.Amount;
new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Update(footer);
}
}
_SaleInvoiceReturnLineService.Delete(SaleInvoiceReturnLine.SaleInvoiceReturnLineId);
SaleInvoiceReturnHeader header = new SaleInvoiceReturnHeaderService(_unitOfWork).Find(SaleInvoiceReturnLine.SaleInvoiceReturnHeaderId);
int status = header.Status;
if (header.Status != (int)StatusConstants.Drafted)
{
header.Status = (int)StatusConstants.Modified;
new SaleInvoiceReturnHeaderService(_unitOfWork).Update(header);
if (header.SaleDispatchReturnHeaderId.HasValue)
{
SaleDispatchReturnHeader DispatchHeader = new SaleDispatchReturnHeaderService(_unitOfWork).Find(header.SaleDispatchReturnHeaderId.Value);
DispatchHeader.Status = header.Status;
new SaleDispatchReturnHeaderService(_unitOfWork).Update(DispatchHeader);
}
}
if (SaleDispatchReturnLineId != null)
{
SaleDispatchReturnLine Gline = new SaleDispatchReturnLineService(_unitOfWork).Find((int)SaleDispatchReturnLineId);
if (Gline != null)
{
LogList.Add(new LogTypeViewModel
{
ExObj = Gline,
});
StockId = Gline.StockId;
new SaleDispatchReturnLineService(_unitOfWork).Delete(Gline);
if (StockId != null)
{
new StockService(_unitOfWork).DeleteStock((int)StockId);
}
}
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Create", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = header.DocTypeId,
DocId = header.SaleInvoiceReturnHeaderId,
DocLineId = SaleInvoiceReturnLine.SaleInvoiceReturnLineId,
ActivityType = (int)ActivityTypeContants.Deleted,
DocNo = header.DocNo,
xEModifications = Modifications,
DocDate = header.DocDate,
DocStatus = header.Status,
}));
return(Json(new { success = true }));
}
//[ValidateAntiForgeryToken]
public ActionResult _CreatePost(SaleInvoiceReturnLineViewModel svm)
{
SaleInvoiceReturnHeader temp = new SaleInvoiceReturnHeaderService(_unitOfWork).Find(svm.SaleInvoiceReturnHeaderId);
var settings = new SaleInvoiceSettingService(_unitOfWork).GetSaleInvoiceSettingForDocument(temp.DocTypeId, temp.DivisionId, temp.SiteId);
if (svm.SaleInvoiceReturnLineId <= 0)
{
ViewBag.LineMode = "Create";
}
else
{
ViewBag.LineMode = "Edit";
}
if (svm.SaleInvoiceReturnLineId <= 0)
{
decimal balqty = (from p in db.SaleInvoiceLine
where p.SaleInvoiceLineId == svm.SaleInvoiceLineId
select p.DealQty).FirstOrDefault();
if (balqty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Invoice Qty");
}
if (svm.Qty == 0)
{
ModelState.AddModelError("Qty", "Please Check Qty");
}
if (svm.SaleInvoiceLineId <= 0)
{
ModelState.AddModelError("SaleInvoiceLineId", "Sale Invoice field is required");
}
if (ModelState.IsValid)
{
SaleInvoiceReturnLine s = Mapper.Map <SaleInvoiceReturnLineViewModel, SaleInvoiceReturnLine>(svm);
s.Sr = _SaleInvoiceReturnLineService.GetMaxSr(s.SaleInvoiceReturnHeaderId);
s.DiscountPer = svm.DiscountPer;
s.CreatedDate = DateTime.Now;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
if (temp.SaleDispatchReturnHeaderId.HasValue)
{
SaleDispatchReturnHeader SaleDispatchReturnHeader = new SaleDispatchReturnHeaderService(_unitOfWork).Find((int)temp.SaleDispatchReturnHeaderId);
SaleDispatchReturnLine Gline = Mapper.Map <SaleInvoiceReturnLine, SaleDispatchReturnLine>(s);
Gline.SaleDispatchLineId = new SaleInvoiceLineService(_unitOfWork).Find(s.SaleInvoiceLineId).SaleDispatchLineId;
Gline.SaleDispatchReturnHeaderId = temp.SaleDispatchReturnHeaderId ?? 0;
Gline.Qty = svm.Qty;
Gline.Weight = svm.Weight;
StockViewModel StockViewModel = new StockViewModel();
StockViewModel.StockHeaderId = SaleDispatchReturnHeader.StockHeaderId ?? 0;
StockViewModel.DocHeaderId = SaleDispatchReturnHeader.SaleDispatchReturnHeaderId;
StockViewModel.DocLineId = Gline.SaleDispatchReturnLineId;
StockViewModel.DocTypeId = SaleDispatchReturnHeader.DocTypeId;
StockViewModel.StockHeaderDocDate = SaleDispatchReturnHeader.DocDate;
StockViewModel.StockDocDate = SaleDispatchReturnHeader.DocDate;
StockViewModel.DocNo = SaleDispatchReturnHeader.DocNo;
StockViewModel.DivisionId = SaleDispatchReturnHeader.DivisionId;
StockViewModel.SiteId = SaleDispatchReturnHeader.SiteId;
StockViewModel.CurrencyId = null;
StockViewModel.HeaderProcessId = settings.ProcessId;
StockViewModel.PersonId = SaleDispatchReturnHeader.BuyerId;
StockViewModel.ProductId = svm.ProductId;
StockViewModel.ProductUidId = svm.ProductUidId;
StockViewModel.HeaderFromGodownId = null;
StockViewModel.HeaderGodownId = SaleDispatchReturnHeader.GodownId;
StockViewModel.GodownId = SaleDispatchReturnHeader.GodownId;
StockViewModel.ProcessId = null;
StockViewModel.LotNo = null;
StockViewModel.CostCenterId = null;
StockViewModel.Qty_Iss = 0;
StockViewModel.Qty_Rec = Gline.Qty;
StockViewModel.Weight_Iss = Gline.Weight;
StockViewModel.Weight_Rec = 0;
StockViewModel.Rate = null;
StockViewModel.ExpiryDate = null;
StockViewModel.Specification = svm.Specification;
StockViewModel.Dimension1Id = svm.Dimension1Id;
StockViewModel.Dimension2Id = svm.Dimension2Id;
StockViewModel.Remark = svm.Remark;
StockViewModel.Status = SaleDispatchReturnHeader.Status;
StockViewModel.CreatedBy = SaleDispatchReturnHeader.CreatedBy;
StockViewModel.CreatedDate = DateTime.Now;
StockViewModel.ModifiedBy = SaleDispatchReturnHeader.ModifiedBy;
StockViewModel.ModifiedDate = DateTime.Now;
string StockPostingError = "";
StockPostingError = new StockService(_unitOfWork).StockPost(ref StockViewModel);
if (StockPostingError != "")
{
ModelState.AddModelError("", StockPostingError);
return(PartialView("_Create", svm));
}
Gline.StockId = StockViewModel.StockId;
Gline.ObjectState = Model.ObjectState.Added;
new SaleDispatchReturnLineService(_unitOfWork).Create(Gline);
s.SaleDispatchReturnLineId = Gline.SaleDispatchReturnLineId;
if (StockViewModel != null)
{
if (SaleDispatchReturnHeader.StockHeaderId == null)
{
SaleDispatchReturnHeader.StockHeaderId = StockViewModel.StockHeaderId;
}
}
if (SaleDispatchReturnHeader.Status != (int)StatusConstants.Drafted)
{
SaleDispatchReturnHeader.Status = (int)StatusConstants.Modified;
}
new SaleDispatchReturnHeaderService(_unitOfWork).Update(SaleDispatchReturnHeader);
}
s.ObjectState = Model.ObjectState.Added;
_SaleInvoiceReturnLineService.Create(s);
if (svm.linecharges != null)
{
foreach (var item in svm.linecharges)
{
item.LineTableId = s.SaleInvoiceReturnLineId;
item.PersonID = temp.BuyerId;
item.HeaderTableId = s.SaleInvoiceReturnHeaderId;
item.ObjectState = Model.ObjectState.Added;
new SaleInvoiceReturnLineChargeService(_unitOfWork).Create(item);
}
}
if (svm.footercharges != null)
{
foreach (var item in svm.footercharges)
{
if (item.Id > 0)
{
var footercharge = new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Find(item.Id);
footercharge.Rate = item.Rate;
footercharge.Amount = item.Amount;
new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Update(footercharge);
}
else
{
item.HeaderTableId = s.SaleInvoiceReturnHeaderId;
item.PersonID = temp.BuyerId;
item.ObjectState = Model.ObjectState.Added;
new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Create(item);
}
}
}
SaleInvoiceReturnHeader temp2 = new SaleInvoiceReturnHeaderService(_unitOfWork).Find(s.SaleInvoiceReturnHeaderId);
if (temp2.Status != (int)StatusConstants.Drafted)
{
temp2.Status = (int)StatusConstants.Modified;
}
new SaleInvoiceReturnHeaderService(_unitOfWork).Update(temp2);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Create", svm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = temp.SaleInvoiceReturnHeaderId,
DocLineId = s.SaleInvoiceReturnLineId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = temp.DocNo,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
return(RedirectToAction("_Create", new { id = s.SaleInvoiceReturnHeaderId, sid = svm.BuyerId }));
}
return(PartialView("_Create", svm));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
int status = temp.Status;
StringBuilder logstring = new StringBuilder();
SaleInvoiceReturnLine line = _SaleInvoiceReturnLineService.Find(svm.SaleInvoiceReturnLineId);
SaleInvoiceReturnLine ExRec = new SaleInvoiceReturnLine();
ExRec = Mapper.Map <SaleInvoiceReturnLine>(line);
decimal balqty = (from p in db.SaleInvoiceLine
where p.SaleInvoiceLineId == svm.SaleInvoiceLineId
select p.DealQty).FirstOrDefault();
if (balqty + line.Qty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Invoice Qty");
}
if (ModelState.IsValid)
{
if (svm.Qty > 0)
{
line.DiscountPer = svm.DiscountPer;
line.Remark = svm.Remark;
line.Qty = svm.Qty;
line.Weight = svm.Weight;
line.DealQty = svm.DealQty;
line.Amount = svm.Amount;
line.ModifiedBy = User.Identity.Name;
line.ModifiedDate = DateTime.Now;
}
_SaleInvoiceReturnLineService.Update(line);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = line,
});
if (temp.SaleDispatchReturnHeaderId.HasValue)
{
SaleDispatchReturnHeader SaleDispatchReturnHeader = new SaleDispatchReturnHeaderService(_unitOfWork).Find((int)temp.SaleDispatchReturnHeaderId);
SaleDispatchReturnLine GLine = new SaleDispatchReturnLineService(_unitOfWork).Find(line.SaleDispatchReturnLineId ?? 0);
SaleDispatchReturnLine ExRecR = new SaleDispatchReturnLine();
ExRecR = Mapper.Map <SaleDispatchReturnLine>(GLine);
GLine.Remark = line.Remark;
GLine.Qty = line.Qty;
GLine.DealQty = line.DealQty;
GLine.Weight = line.Weight;
GLine.ObjectState = Model.ObjectState.Modified;
new SaleDispatchReturnLineService(_unitOfWork).Update(GLine);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRecR,
Obj = GLine,
});
StockViewModel StockViewModel = new StockViewModel();
StockViewModel.StockHeaderId = SaleDispatchReturnHeader.StockHeaderId ?? 0;
StockViewModel.StockId = GLine.StockId ?? 0;
StockViewModel.DocHeaderId = SaleDispatchReturnHeader.SaleDispatchReturnHeaderId;
StockViewModel.DocLineId = GLine.SaleDispatchLineId;
StockViewModel.DocTypeId = SaleDispatchReturnHeader.DocTypeId;
StockViewModel.StockHeaderDocDate = SaleDispatchReturnHeader.DocDate;
StockViewModel.StockDocDate = SaleDispatchReturnHeader.DocDate;
StockViewModel.DocNo = SaleDispatchReturnHeader.DocNo;
StockViewModel.DivisionId = SaleDispatchReturnHeader.DivisionId;
StockViewModel.SiteId = SaleDispatchReturnHeader.SiteId;
StockViewModel.CurrencyId = null;
StockViewModel.HeaderProcessId = settings.ProcessId;
StockViewModel.PersonId = SaleDispatchReturnHeader.BuyerId;
StockViewModel.ProductId = svm.ProductId;
StockViewModel.ProductUidId = svm.ProductUidId;
StockViewModel.HeaderFromGodownId = null;
StockViewModel.HeaderGodownId = SaleDispatchReturnHeader.GodownId;
StockViewModel.GodownId = SaleDispatchReturnHeader.GodownId;
StockViewModel.ProcessId = null;
StockViewModel.LotNo = null;
StockViewModel.CostCenterId = null;
StockViewModel.Qty_Iss = 0;
StockViewModel.Qty_Rec = svm.Qty;
StockViewModel.Weight_Iss = svm.Weight;
StockViewModel.Weight_Rec = 0;
StockViewModel.Rate = null;
StockViewModel.ExpiryDate = null;
StockViewModel.Specification = svm.Specification;
StockViewModel.Dimension1Id = svm.Dimension1Id;
StockViewModel.Dimension2Id = svm.Dimension2Id;
StockViewModel.Remark = svm.Remark;
StockViewModel.Status = SaleDispatchReturnHeader.Status;
StockViewModel.CreatedBy = SaleDispatchReturnHeader.CreatedBy;
StockViewModel.CreatedDate = SaleDispatchReturnHeader.CreatedDate;
StockViewModel.ModifiedBy = User.Identity.Name;
StockViewModel.ModifiedDate = DateTime.Now;
string StockPostingError = "";
StockPostingError = new StockService(_unitOfWork).StockPost(ref StockViewModel);
if (StockPostingError != "")
{
ModelState.AddModelError("", StockPostingError);
return(PartialView("_Create", svm));
}
if (SaleDispatchReturnHeader.Status != (int)StatusConstants.Drafted)
{
SaleDispatchReturnHeader.Status = (int)StatusConstants.Modified;
new SaleDispatchReturnHeaderService(_unitOfWork).Update(SaleDispatchReturnHeader);
}
}
if (temp.Status != (int)StatusConstants.Drafted)
{
temp.Status = (int)StatusConstants.Modified;
new SaleInvoiceReturnHeaderService(_unitOfWork).Update(temp);
}
if (svm.linecharges != null)
{
foreach (var item in svm.linecharges)
{
var productcharge = new SaleInvoiceReturnLineChargeService(_unitOfWork).Find(item.Id);
SaleInvoiceReturnLineCharge ExRecLine = new SaleInvoiceReturnLineCharge();
ExRecLine = Mapper.Map <SaleInvoiceReturnLineCharge>(productcharge);
productcharge.Rate = item.Rate;
productcharge.Amount = item.Amount;
productcharge.DealQty = item.DealQty;
new SaleInvoiceReturnLineChargeService(_unitOfWork).Update(productcharge);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRecLine,
Obj = productcharge,
});
}
}
if (svm.footercharges != null)
{
foreach (var item in svm.footercharges)
{
var footercharge = new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Find(item.Id);
SaleInvoiceReturnHeaderCharge ExRecLine = new SaleInvoiceReturnHeaderCharge();
ExRecLine = Mapper.Map <SaleInvoiceReturnHeaderCharge>(footercharge);
footercharge.Rate = item.Rate;
footercharge.Amount = item.Amount;
new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Update(footercharge);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRecLine,
Obj = footercharge,
});
}
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Create", svm));
}
//Saving the Activity Log
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = line.SaleInvoiceReturnHeaderId,
DocLineId = line.SaleInvoiceReturnLineId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = temp.DocNo,
xEModifications = Modifications,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
//End of Saving the Activity Log
return(Json(new { success = true }));
}
return(PartialView("_Create", svm));
}
}
public ActionResult _ResultsPost(SaleInvoiceReturnMasterDetailModel vm)
{
int Cnt = 0;
List <HeaderChargeViewModel> HeaderCharges = new List <HeaderChargeViewModel>();
List <LineChargeViewModel> LineCharges = new List <LineChargeViewModel>();
int pk = 0;
int Gpk = 0;
int Serial = _SaleInvoiceReturnLineService.GetMaxSr(vm.SaleInvoiceReturnLineViewModel.FirstOrDefault().SaleInvoiceReturnHeaderId);
bool HeaderChargeEdit = false;
SaleInvoiceReturnHeader Header = new SaleInvoiceReturnHeaderService(_unitOfWork).Find(vm.SaleInvoiceReturnLineViewModel.FirstOrDefault().SaleInvoiceReturnHeaderId);
SaleInvoiceSetting Settings = new SaleInvoiceSettingService(_unitOfWork).GetSaleInvoiceSettingForDocument(Header.DocTypeId, Header.DivisionId, Header.SiteId);
int?MaxLineId = new SaleInvoiceReturnLineChargeService(_unitOfWork).GetMaxProductCharge(Header.SaleInvoiceReturnHeaderId, "Web.SaleInvoiceReturnLines", "SaleInvoiceReturnHeaderId", "SaleInvoiceReturnLineId");
int PersonCount = 0;
int CalculationId = Settings.CalculationId;
List <LineDetailListViewModel> LineList = new List <LineDetailListViewModel>();
SaleDispatchReturnHeader GoodsRetHeader = new SaleDispatchReturnHeaderService(_unitOfWork).Find(Header.SaleDispatchReturnHeaderId ?? 0);
if (ModelState.IsValid)
{
foreach (var item in vm.SaleInvoiceReturnLineViewModel)
{
decimal balqty = (from p in db.ViewSaleInvoiceBalance
where p.SaleInvoiceLineId == item.SaleInvoiceLineId
select p.BalanceQty).FirstOrDefault();
if (item.Qty > 0 && item.Qty <= balqty)
{
SaleInvoiceReturnLine line = new SaleInvoiceReturnLine();
//var receipt = new SaleDispatchLineService(_unitOfWork).Find(item.SaleDispatchLineId );
line.SaleInvoiceReturnHeaderId = item.SaleInvoiceReturnHeaderId;
line.SaleInvoiceLineId = item.SaleInvoiceLineId;
line.Qty = item.Qty;
line.Sr = Serial++;
line.DiscountPer = item.DiscountPer;
line.DiscountAmount = item.DiscountAmount;
line.Rate = item.Rate;
line.DealQty = item.UnitConversionMultiplier * item.Qty;
line.DealUnitId = item.DealUnitId;
line.UnitConversionMultiplier = item.UnitConversionMultiplier;
line.Amount = item.RateAfterDiscount * line.DealQty;
line.Remark = item.Remark;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.SaleInvoiceReturnLineId = pk;
SaleDispatchReturnLine GLine = Mapper.Map <SaleInvoiceReturnLine, SaleDispatchReturnLine>(line);
GLine.SaleDispatchLineId = new SaleInvoiceLineService(_unitOfWork).Find(line.SaleInvoiceLineId).SaleDispatchLineId;
GLine.SaleDispatchReturnHeaderId = GoodsRetHeader.SaleDispatchReturnHeaderId;
GLine.SaleDispatchReturnLineId = Gpk;
GLine.Qty = line.Qty;
GLine.ObjectState = Model.ObjectState.Added;
SaleDispatchLine SaleDispatchLine = new SaleDispatchLineService(_unitOfWork).Find(GLine.SaleDispatchLineId);
PackingLine PackingLin = new PackingLineService(_unitOfWork).Find(SaleDispatchLine.PackingLineId);
StockViewModel StockViewModel = new StockViewModel();
if (Cnt == 0)
{
StockViewModel.StockHeaderId = GoodsRetHeader.StockHeaderId ?? 0;
}
else
{
if (GoodsRetHeader.StockHeaderId != null && GoodsRetHeader.StockHeaderId != 0)
{
StockViewModel.StockHeaderId = (int)GoodsRetHeader.StockHeaderId;
}
else
{
StockViewModel.StockHeaderId = -1;
}
}
StockViewModel.StockId = -Cnt;
StockViewModel.DocHeaderId = GoodsRetHeader.SaleDispatchReturnHeaderId;
StockViewModel.DocLineId = SaleDispatchLine.SaleDispatchLineId;
StockViewModel.DocTypeId = GoodsRetHeader.DocTypeId;
StockViewModel.StockHeaderDocDate = GoodsRetHeader.DocDate;
StockViewModel.StockDocDate = GoodsRetHeader.DocDate;
StockViewModel.DocNo = GoodsRetHeader.DocNo;
StockViewModel.DivisionId = GoodsRetHeader.DivisionId;
StockViewModel.SiteId = GoodsRetHeader.SiteId;
StockViewModel.CurrencyId = null;
StockViewModel.PersonId = GoodsRetHeader.BuyerId;
StockViewModel.ProductId = PackingLin.ProductId;
StockViewModel.ProductUidId = PackingLin.ProductUidId;
StockViewModel.HeaderFromGodownId = null;
StockViewModel.HeaderGodownId = GoodsRetHeader.GodownId;
StockViewModel.HeaderProcessId = Settings.ProcessId;
StockViewModel.GodownId = GoodsRetHeader.GodownId;
StockViewModel.Remark = Header.Remark;
StockViewModel.Status = Header.Status;
StockViewModel.ProcessId = null;
StockViewModel.LotNo = null;
StockViewModel.CostCenterId = null;
StockViewModel.Qty_Iss = 0;
StockViewModel.Qty_Rec = GLine.Qty;
StockViewModel.Rate = null;
StockViewModel.ExpiryDate = null;
StockViewModel.Specification = PackingLin.Specification;
StockViewModel.Dimension1Id = PackingLin.Dimension1Id;
StockViewModel.Dimension2Id = PackingLin.Dimension2Id;
StockViewModel.CreatedBy = User.Identity.Name;
StockViewModel.CreatedDate = DateTime.Now;
StockViewModel.ModifiedBy = User.Identity.Name;
StockViewModel.ModifiedDate = DateTime.Now;
string StockPostingError = "";
StockPostingError = new StockService(_unitOfWork).StockPost(ref StockViewModel);
if (StockPostingError != "")
{
string message = StockPostingError;
ModelState.AddModelError("", message);
return(PartialView("_Results", vm));
}
if (Cnt == 0)
{
GoodsRetHeader.StockHeaderId = StockViewModel.StockHeaderId;
}
GLine.StockId = StockViewModel.StockId;
new SaleDispatchReturnLineService(_unitOfWork).Create(GLine);
line.SaleDispatchReturnLineId = GLine.SaleDispatchReturnLineId;
line.ObjectState = Model.ObjectState.Added;
_SaleInvoiceReturnLineService.Create(line);
LineList.Add(new LineDetailListViewModel {
Amount = line.Amount, Rate = line.Rate, LineTableId = line.SaleInvoiceReturnLineId, HeaderTableId = item.SaleInvoiceReturnHeaderId, PersonID = Header.BuyerId, DealQty = line.DealQty
});
Gpk++;
pk++;
Cnt = Cnt + 1;
}
}
new SaleDispatchReturnHeaderService(_unitOfWork).Update(GoodsRetHeader);
new ChargesCalculationService(_unitOfWork).CalculateCharges(LineList, vm.SaleInvoiceReturnLineViewModel.FirstOrDefault().SaleInvoiceReturnHeaderId, CalculationId, MaxLineId, out LineCharges, out HeaderChargeEdit, out HeaderCharges, "Web.SaleInvoiceReturnHeaderCharges", "Web.SaleInvoiceReturnLineCharges", out PersonCount, Header.DocTypeId, Header.SiteId, Header.DivisionId);
// Saving Charges
foreach (var item in LineCharges)
{
SaleInvoiceReturnLineCharge PoLineCharge = Mapper.Map <LineChargeViewModel, SaleInvoiceReturnLineCharge>(item);
PoLineCharge.ObjectState = Model.ObjectState.Added;
new SaleInvoiceReturnLineChargeService(_unitOfWork).Create(PoLineCharge);
}
//Saving Header charges
for (int i = 0; i < HeaderCharges.Count(); i++)
{
if (!HeaderChargeEdit)
{
SaleInvoiceReturnHeaderCharge POHeaderCharge = Mapper.Map <HeaderChargeViewModel, SaleInvoiceReturnHeaderCharge>(HeaderCharges[i]);
POHeaderCharge.HeaderTableId = vm.SaleInvoiceReturnLineViewModel.FirstOrDefault().SaleInvoiceReturnHeaderId;
POHeaderCharge.PersonID = Header.BuyerId;
POHeaderCharge.ObjectState = Model.ObjectState.Added;
new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Create(POHeaderCharge);
}
else
{
var footercharge = new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Find(HeaderCharges[i].Id);
footercharge.Rate = HeaderCharges[i].Rate;
footercharge.Amount = HeaderCharges[i].Amount;
new SaleInvoiceReturnHeaderChargeService(_unitOfWork).Update(footercharge);
}
}
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("_Results", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.SaleInvoiceReturnHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
public ActionResult DeletePost(SaleDispatchReturnLineViewModel vm)
{
bool BeforeSave = true;
//try
//{
// BeforeSave = SaleDispatchReturnDocEvents.beforeLineDeleteEvent(this, new SaleEventArgs(vm.SaleDispatchReturnHeaderId, vm.SaleDispatchReturnLineId), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXC"] += message;
// EventException = true;
//}
//if (!BeforeSave)
// TempData["CSEXC"] += "Validation failed before delete.";
if (BeforeSave && !EventException)
{
int?StockId = 0;
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
SaleDispatchReturnLine SaleDispatchReturnLine = db.SaleDispatchReturnLine.Find(vm.SaleDispatchReturnLineId);
SaleDispatchReturnHeader header = new SaleDispatchReturnHeaderService(_unitOfWork).Find(SaleDispatchReturnLine.SaleDispatchReturnHeaderId);
//try
//{
// SaleDispatchReturnDocEvents.onLineDeleteEvent(this, new SaleEventArgs(SaleDispatchReturnLine.SaleDispatchReturnHeaderId, SaleDispatchReturnLine.SaleDispatchReturnLineId), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXCL"] += message;
// EventException = true;
//}
LogList.Add(new LogTypeViewModel
{
ExObj = Mapper.Map <SaleDispatchReturnLine>(SaleDispatchReturnLine),
});
StockId = SaleDispatchReturnLine.StockId;
//new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyOnReturn(SaleDispatchReturnLine.SaleDispatchLineId, SaleDispatchReturnLine.SaleDispatchReturnLineId, header.DocDate, 0, ref db, true);
//_SaleDispatchReturnLineService.Delete(SaleDispatchReturnLine);
if (header.Status != (int)StatusConstants.Drafted && header.Status != (int)StatusConstants.Import)
{
header.Status = (int)StatusConstants.Modified;
header.ModifiedBy = User.Identity.Name;
header.ModifiedDate = DateTime.Now;
//new SaleDispatchReturnHeaderService(_unitOfWork).Update(header);
}
header.ObjectState = Model.ObjectState.Modified;
db.SaleDispatchReturnHeader.Add(header);
var SaleDispatchLine = db.SaleDispatchLine.Find(SaleDispatchReturnLine.SaleDispatchLineId);
SaleDispatchReturnLine.ObjectState = Model.ObjectState.Deleted;
db.SaleDispatchReturnLine.Remove(SaleDispatchReturnLine);
if (StockId != null)
{
new StockService(_unitOfWork).DeleteStockDB((int)StockId, ref db, true);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", vm));
}
//try
//{
// SaleDispatchReturnDocEvents.afterLineDeleteEvent(this, new SaleEventArgs(SaleDispatchReturnLine.SaleDispatchReturnHeaderId, SaleDispatchReturnLine.SaleDispatchReturnLineId), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXC"] += message;
//}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = header.DocTypeId,
DocId = header.SaleDispatchReturnHeaderId,
DocLineId = SaleDispatchReturnLine.SaleDispatchReturnLineId,
ActivityType = (int)ActivityTypeContants.Deleted,
DocNo = header.DocNo,
xEModifications = Modifications,
DocDate = header.DocDate,
DocStatus = header.Status,
}));
}
return(Json(new { success = true }));
}
public ActionResult _CreatePost(SaleDispatchReturnLineViewModel svm)
{
if (svm.SaleDispatchReturnLineId <= 0)
{
ViewBag.LineMode = "Create";
}
else
{
ViewBag.LineMode = "Edit";
}
bool BeforeSave = true;
//try
//{
// if (svm.SaleDispatchReturnLineId <= 0)
// BeforeSave = SaleDispatchReturnDocEvents.beforeLineSaveEvent(this, new SaleEventArgs(svm.SaleDispatchReturnHeaderId, EventModeConstants.Add), ref db);
// else
// BeforeSave = SaleDispatchReturnDocEvents.beforeLineSaveEvent(this, new SaleEventArgs(svm.SaleDispatchReturnHeaderId, EventModeConstants.Edit), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXCL"] += message;
// EventException = true;
//}
//if (!BeforeSave)
// ModelState.AddModelError("", "Validation failed before save.");
if (svm.SaleDispatchReturnLineId <= 0)
{
SaleDispatchReturnHeader Header = new SaleDispatchReturnHeaderService(_unitOfWork).Find(svm.SaleDispatchReturnHeaderId);
decimal balqty = (from p in db.SaleDispatchLine
join t in db.PackingLine on p.PackingLineId equals t.PackingLineId
where p.SaleDispatchLineId == svm.SaleDispatchLineId
select t.DealQty).FirstOrDefault();
if (balqty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Invoice Qty");
}
if (svm.Qty == 0)
{
ModelState.AddModelError("Qty", "Please Check Qty");
}
if (svm.SaleDispatchLineId <= 0)
{
ModelState.AddModelError("SaleDispatchLineId", "Sale Invoice field is required");
}
if (svm.DealQty <= 0)
{
ModelState.AddModelError("DealQty", "DealQty field is required");
}
if (ModelState.IsValid && BeforeSave && !EventException)
{
int ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.FullFinishing).ProcessId;
SaleDispatchReturnLine Line = Mapper.Map <SaleDispatchReturnLineViewModel, SaleDispatchReturnLine>(svm);
StockViewModel StockViewModel = new StockViewModel();
StockViewModel.StockHeaderId = Header.StockHeaderId ?? 0;
StockViewModel.DocHeaderId = Header.SaleDispatchReturnHeaderId;
StockViewModel.DocLineId = Line.SaleDispatchReturnLineId;
StockViewModel.DocTypeId = Header.DocTypeId;
StockViewModel.StockHeaderDocDate = Header.DocDate;
StockViewModel.StockDocDate = Header.DocDate;
StockViewModel.DocNo = Header.DocNo;
StockViewModel.DivisionId = Header.DivisionId;
StockViewModel.SiteId = Header.SiteId;
StockViewModel.CurrencyId = null;
StockViewModel.HeaderProcessId = ProcessId;
StockViewModel.PersonId = Header.BuyerId;
StockViewModel.ProductId = svm.ProductId;
StockViewModel.HeaderFromGodownId = null;
StockViewModel.HeaderGodownId = Header.GodownId;
StockViewModel.GodownId = Header.GodownId;
StockViewModel.ProcessId = ProcessId;
StockViewModel.LotNo = null;
StockViewModel.CostCenterId = null;
StockViewModel.Qty_Iss = Line.Qty;
StockViewModel.Qty_Rec = 0;
StockViewModel.Rate = null;
StockViewModel.ExpiryDate = null;
StockViewModel.Specification = svm.Specification;
StockViewModel.Dimension1Id = svm.Dimension1Id;
StockViewModel.Dimension2Id = svm.Dimension2Id;
StockViewModel.ProductUidId = svm.ProductUidId;
StockViewModel.Remark = Line.Remark;
StockViewModel.Status = Header.Status;
StockViewModel.CreatedBy = Header.CreatedBy;
StockViewModel.CreatedDate = DateTime.Now;
StockViewModel.ModifiedBy = Header.ModifiedBy;
StockViewModel.ModifiedDate = DateTime.Now;
string StockPostingError = "";
StockPostingError = new StockService(_unitOfWork).StockPostDB(ref StockViewModel, ref db);
if (StockPostingError != "")
{
ModelState.AddModelError("", StockPostingError);
return(PartialView("_Create", svm));
}
Line.StockId = StockViewModel.StockId;
Line.Sr = _SaleDispatchReturnLineService.GetMaxSr(svm.SaleDispatchReturnHeaderId);
Line.CreatedDate = DateTime.Now;
Line.ModifiedDate = DateTime.Now;
Line.CreatedBy = User.Identity.Name;
Line.ModifiedBy = User.Identity.Name;
Line.ObjectState = Model.ObjectState.Added;
var SaleDispatchLine = new SaleDispatchLineService(_unitOfWork).Find(Line.SaleDispatchLineId);
Line.ObjectState = Model.ObjectState.Added;
db.SaleDispatchReturnLine.Add(Line);
//_SaleDispatchReturnLineService.Create(Line);
//new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyOnReturn(Line.SaleDispatchLineId, Line.SaleDispatchReturnLineId, Header.DocDate, Line.Qty, ref db, true);
if (Header.Status != (int)StatusConstants.Drafted && Header.Status != (int)StatusConstants.Import)
{
Header.Status = (int)StatusConstants.Modified;
Header.ModifiedBy = User.Identity.Name;
Header.ModifiedDate = DateTime.Now;
}
if (StockViewModel != null)
{
if (Header.StockHeaderId == null)
{
Header.StockHeaderId = StockViewModel.StockHeaderId;
}
}
Header.ObjectState = Model.ObjectState.Modified;
db.SaleDispatchReturnHeader.Add(Header);
//new SaleDispatchReturnHeaderService(_unitOfWork).Update(Header);
//try
//{
// SaleDispatchReturnDocEvents.onLineSaveEvent(this, new SaleEventArgs(Line.SaleDispatchReturnHeaderId, Line.SaleDispatchReturnLineId, EventModeConstants.Add), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXCL"] += message;
// EventException = true;
//}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
//try
//{
// SaleDispatchReturnDocEvents.afterLineSaveEvent(this, new SaleEventArgs(Line.SaleDispatchReturnHeaderId, Line.SaleDispatchReturnLineId, EventModeConstants.Add), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXCL"] += message;
//}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.SaleDispatchReturnHeaderId,
DocLineId = Line.SaleDispatchReturnLineId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(RedirectToAction("_Create", new { id = Line.SaleDispatchReturnHeaderId, sid = svm.BuyerId }));
}
return(PartialView("_Create", svm));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
SaleDispatchReturnHeader Header = new SaleDispatchReturnHeaderService(_unitOfWork).Find(svm.SaleDispatchReturnHeaderId);
int status = Header.Status;
StringBuilder logstring = new StringBuilder();
SaleDispatchReturnLine Line = _SaleDispatchReturnLineService.Find(svm.SaleDispatchReturnLineId);
SaleDispatchReturnLine ExRec = new SaleDispatchReturnLine();
ExRec = Mapper.Map <SaleDispatchReturnLine>(Line);
decimal balqty = (from p in db.SaleDispatchLine
join t in db.PackingLine on p.PackingLineId equals t.PackingLineId
where p.SaleDispatchLineId == svm.SaleDispatchLineId
select t.DealQty).FirstOrDefault();
if (balqty + Line.Qty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Invoice Qty");
}
if (svm.DealQty <= 0)
{
ModelState.AddModelError("DealQty", "DealQty field is required");
}
if (ModelState.IsValid)
{
int ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.FullFinishing).ProcessId;
Line.Remark = svm.Remark;
Line.Qty = svm.Qty;
Line.DealQty = svm.DealQty;
Line.ModifiedBy = User.Identity.Name;
Line.ModifiedDate = DateTime.Now;
Line.ObjectState = Model.ObjectState.Modified;
db.SaleDispatchReturnLine.Add(Line);
//_SaleDispatchReturnLineService.Update(Line);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = Line,
});
//new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyOnReturn(Line.SaleDispatchLineId, Line.SaleDispatchReturnLineId, Header.DocDate, Line.Qty, ref db, true);
StockViewModel StockViewModel = new StockViewModel();
StockViewModel.StockHeaderId = Header.StockHeaderId ?? 0;
StockViewModel.StockId = Line.StockId ?? 0;
StockViewModel.DocHeaderId = Header.SaleDispatchReturnHeaderId;
StockViewModel.DocLineId = Line.SaleDispatchLineId;
StockViewModel.DocTypeId = Header.DocTypeId;
StockViewModel.StockHeaderDocDate = Header.DocDate;
StockViewModel.StockDocDate = Header.DocDate;
StockViewModel.DocNo = Header.DocNo;
StockViewModel.DivisionId = Header.DivisionId;
StockViewModel.SiteId = Header.SiteId;
StockViewModel.CurrencyId = null;
StockViewModel.HeaderProcessId = ProcessId;
StockViewModel.PersonId = Header.BuyerId;
StockViewModel.ProductId = svm.ProductId;
StockViewModel.HeaderFromGodownId = null;
StockViewModel.HeaderGodownId = Header.GodownId;
StockViewModel.GodownId = Header.GodownId;
StockViewModel.ProcessId = ProcessId;
StockViewModel.LotNo = null;
StockViewModel.CostCenterId = null;
StockViewModel.Qty_Iss = svm.Qty;
StockViewModel.Qty_Rec = 0;
StockViewModel.Rate = null;
StockViewModel.ExpiryDate = null;
StockViewModel.Specification = svm.Specification;
StockViewModel.Dimension1Id = svm.Dimension1Id;
StockViewModel.Dimension2Id = svm.Dimension2Id;
StockViewModel.ProductUidId = svm.ProductUidId;
StockViewModel.Remark = Line.Remark;
StockViewModel.Status = Header.Status;
StockViewModel.CreatedBy = Header.CreatedBy;
StockViewModel.CreatedDate = Header.CreatedDate;
StockViewModel.ModifiedBy = User.Identity.Name;
StockViewModel.ModifiedDate = DateTime.Now;
string StockPostingError = "";
StockPostingError = new StockService(_unitOfWork).StockPostDB(ref StockViewModel, ref db);
if (StockPostingError != "")
{
ModelState.AddModelError("", StockPostingError);
return(PartialView("_Create", svm));
}
if (Header.Status != (int)StatusConstants.Drafted && Header.Status != (int)StatusConstants.Import)
{
Header.Status = (int)StatusConstants.Modified;
Header.ModifiedDate = DateTime.Now;
Header.ModifiedBy = User.Identity.Name;
//new SaleDispatchReturnHeaderService(_unitOfWork).Update(Header);
}
Header.ObjectState = Model.ObjectState.Modified;
db.SaleDispatchReturnHeader.Add(Header);
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
//try
//{
// SaleDispatchReturnDocEvents.onLineSaveEvent(this, new SaleEventArgs(Line.SaleDispatchReturnHeaderId, Line.SaleDispatchReturnLineId, EventModeConstants.Edit), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXCL"] += message;
// EventException = true;
//}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
//try
//{
// SaleDispatchReturnDocEvents.afterLineSaveEvent(this, new SaleEventArgs(Line.SaleDispatchReturnHeaderId, Line.SaleDispatchReturnLineId, EventModeConstants.Edit), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXC"] += message;
//}
//Saving the Activity Log
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.SaleDispatchReturnHeaderId,
DocLineId = Line.SaleDispatchReturnLineId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = Header.DocNo,
xEModifications = Modifications,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
//End of Saving the Activity Log
return(Json(new { success = true }));
}
return(PartialView("_Create", svm));
}
}
public ActionResult _ResultsPost(SaleDispatchReturnMasterDetailModel vm)
{
int Cnt = 0;
int Serial = _SaleDispatchReturnLineService.GetMaxSr(vm.SaleDispatchReturnLineViewModel.FirstOrDefault().SaleDispatchReturnHeaderId);
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
bool BeforeSave = true;
//try
//{
// BeforeSave = SaleDispatchReturnDocEvents.beforeLineSaveBulkEvent(this, new SaleEventArgs(vm.SaleDispatchReturnLineViewModel.FirstOrDefault().SaleDispatchReturnHeaderId), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXCL"] += message;
// EventException = true;
//}
//if (!BeforeSave)
// ModelState.AddModelError("", "Validation failed before save");
if (ModelState.IsValid && BeforeSave && !EventException)
{
int ProcessId = new ProcessService(_unitOfWork).Find(ProcessConstants.FullFinishing).ProcessId;
SaleDispatchReturnHeader Header = new SaleDispatchReturnHeaderService(_unitOfWork).Find(vm.SaleDispatchReturnLineViewModel.FirstOrDefault().SaleDispatchReturnHeaderId);
foreach (var item in vm.SaleDispatchReturnLineViewModel)
{
decimal balqty = (from p in db.ViewSaleDispatchBalance
where p.SaleDispatchLineId == item.SaleDispatchLineId
select p.BalanceQty).FirstOrDefault();
if (item.Qty > 0 && item.Qty <= balqty)
{
SaleDispatchReturnLine Line = new SaleDispatchReturnLine();
Line.SaleDispatchReturnHeaderId = item.SaleDispatchReturnHeaderId;
Line.SaleDispatchLineId = item.SaleDispatchLineId;
Line.Qty = item.Qty;
Line.Sr = Serial++;
Line.DealQty = item.UnitConversionMultiplier * item.Qty;
Line.DealUnitId = item.DealUnitId;
Line.UnitConversionMultiplier = item.UnitConversionMultiplier;
Line.Remark = item.Remark;
Line.CreatedDate = DateTime.Now;
Line.ModifiedDate = DateTime.Now;
Line.CreatedBy = User.Identity.Name;
Line.ModifiedBy = User.Identity.Name;
LineStatus.Add(Line.SaleDispatchLineId, Line.Qty);
SaleDispatchLine SaleDispatchLine = new SaleDispatchLineService(_unitOfWork).Find(Line.SaleDispatchLineId);
//var receipt = new SaleDispatchLineService(_unitOfWork).Find(item.SaleDispatchLineId );
StockViewModel StockViewModel = new StockViewModel();
if (Cnt == 0)
{
StockViewModel.StockHeaderId = Header.StockHeaderId ?? 0;
}
else
{
if (Header.StockHeaderId != null && Header.StockHeaderId != 0)
{
StockViewModel.StockHeaderId = (int)Header.StockHeaderId;
}
else
{
StockViewModel.StockHeaderId = -1;
}
}
StockViewModel.StockId = -Cnt;
StockViewModel.DocHeaderId = Header.SaleDispatchReturnHeaderId;
StockViewModel.DocLineId = Line.SaleDispatchLineId;
StockViewModel.DocTypeId = Header.DocTypeId;
StockViewModel.StockHeaderDocDate = Header.DocDate;
StockViewModel.StockDocDate = Header.DocDate;
StockViewModel.DocNo = Header.DocNo;
StockViewModel.DivisionId = Header.DivisionId;
StockViewModel.SiteId = Header.SiteId;
StockViewModel.CurrencyId = null;
StockViewModel.PersonId = Header.BuyerId;
StockViewModel.ProductId = item.ProductId;
StockViewModel.HeaderFromGodownId = null;
StockViewModel.HeaderGodownId = Header.GodownId;
StockViewModel.HeaderProcessId = ProcessId;
StockViewModel.GodownId = Header.GodownId;
StockViewModel.Remark = Header.Remark;
StockViewModel.Status = Header.Status;
StockViewModel.ProcessId = ProcessId;
StockViewModel.LotNo = null;
StockViewModel.CostCenterId = null;
StockViewModel.Qty_Iss = Line.Qty;
StockViewModel.Qty_Rec = 0;
StockViewModel.Rate = null;
StockViewModel.ExpiryDate = null;
StockViewModel.Specification = item.Specification;
StockViewModel.Dimension1Id = item.Dimension1Id;
StockViewModel.Dimension2Id = item.Dimension2Id;
//StockViewModel.ProductUidId = SaleDispatchLine.ProductUidId;
StockViewModel.CreatedBy = User.Identity.Name;
StockViewModel.CreatedDate = DateTime.Now;
StockViewModel.ModifiedBy = User.Identity.Name;
StockViewModel.ModifiedDate = DateTime.Now;
string StockPostingError = "";
StockPostingError = new StockService(_unitOfWork).StockPostDB(ref StockViewModel, ref db);
if (StockPostingError != "")
{
string message = StockPostingError;
ModelState.AddModelError("", message);
return(PartialView("_Results", vm));
}
if (Cnt == 0)
{
Header.StockHeaderId = StockViewModel.StockHeaderId;
}
Line.StockId = StockViewModel.StockId;
Line.ObjectState = Model.ObjectState.Added;
db.SaleDispatchReturnLine.Add(Line);
//_SaleDispatchReturnLineService.Create(Line);
Cnt = Cnt + 1;
}
}
if (Header.Status != (int)StatusConstants.Drafted && Header.Status != (int)StatusConstants.Import)
{
Header.Status = (int)StatusConstants.Modified;
Header.ModifiedBy = User.Identity.Name;
Header.ModifiedDate = DateTime.Now;
}
Header.ObjectState = Model.ObjectState.Modified;
db.SaleDispatchReturnHeader.Add(Header);
//new SaleDispatchReturnHeaderService(_unitOfWork).Update(Header);
//new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyReturnMultiple(LineStatus, Header.DocDate, ref db);
//try
//{
// SaleDispatchReturnDocEvents.onLineSaveBulkEvent(this, new SaleEventArgs(vm.SaleDispatchReturnLineViewModel.FirstOrDefault().SaleDispatchReturnHeaderId), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXCL"] += message;
// EventException = true;
//}
try
{
if (EventException)
{
throw new Exception();
}
db.SaveChanges();
//_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Results", vm));
}
//try
//{
// SaleDispatchReturnDocEvents.afterLineSaveBulkEvent(this, new SaleEventArgs(vm.SaleDispatchReturnLineViewModel.FirstOrDefault().SaleDispatchReturnHeaderId), ref db);
//}
//catch (Exception ex)
//{
// string message = _exception.HandleException(ex);
// TempData["CSEXC"] += message;
//}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = Header.DocTypeId,
DocId = Header.SaleDispatchReturnHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
