public ActionResult DeletePost(SaleOrderCancelLineViewModel vm)
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
SaleOrderCancelLine SaleOrderLine = _SaleOrderCancelLineService.Find(vm.SaleOrderCancelLineId);
LogList.Add(new LogTypeViewModel
{
ExObj = SaleOrderLine,
});
SaleOrderCancelHeader header = new SaleOrderCancelHeaderService(_unitOfWork).Find(SaleOrderLine.SaleOrderCancelHeaderId);
new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyOnCancel(SaleOrderLine.SaleOrderLineId, SaleOrderLine.SaleOrderCancelLineId, header.DocDate, 0);
_SaleOrderCancelLineService.Delete(vm.SaleOrderCancelLineId);
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 SaleOrderCancelHeaderService(_unitOfWork).Update(header);
}
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = header.DocTypeId,
DocId = header.SaleOrderCancelHeaderId,
DocLineId = SaleOrderLine.SaleOrderCancelLineId,
ActivityType = (int)ActivityTypeContants.Deleted,
DocNo = header.DocNo,
xEModifications = Modifications,
DocDate = header.DocDate,
DocStatus = header.Status,
}));
return(Json(new { success = true }));
}
public ActionResult SaleOrderCancelExcelImport()
{
int i = 0;
var file = Request.Files[0];
string filePath = Request.MapPath(ConfigurationManager.AppSettings["ExcelFilePath"] + file.FileName);
file.SaveAs(filePath);
var excel = new ExcelQueryFactory();
//excel.FileName =ConfigurationManager.AppSettings["ExcelFilePath"]; // @"C:\Users\guru\Downloads\PO.xls"; //TODO: Rempve hardcode
excel.FileName = filePath;
var SaleOrderCancelRecordList = from c in excel.Worksheet <SaleOrderCancelExcel>() select c;
StringBuilder strSaleOrder = new StringBuilder();
StringBuilder strSaleOrderCancelNo = new StringBuilder();
StringBuilder strOtherValidation = new StringBuilder();
foreach (var SaleOrderCancelRecord in SaleOrderCancelRecordList)
{
if (_SaleOrderCancelHeaderService.FindByDocNo(SaleOrderCancelRecord.SaleOrderCancelNo) != null)
{
if (!strSaleOrderCancelNo.ToString().Contains("" + SaleOrderCancelRecord.SaleOrderCancelNo))
{
strSaleOrderCancelNo.Append(" " + SaleOrderCancelRecord.SaleOrderCancelNo + ",");
}
}
if (_SaleOrderHeaderService.FindByDocNo(SaleOrderCancelRecord.SaleOrderNo) == null)
{
if (!strSaleOrder.ToString().Contains("" + SaleOrderCancelRecord.SaleOrderNo))
{
strSaleOrder.Append(" " + SaleOrderCancelRecord.SaleOrderNo + ",");
}
}
//SaleOrderLine pol = _SaleOrderLineService.GetSaleOrderLineForSaleOrderAndProduct(SaleOrderCancelRecord.SaleOrderNo, SaleOrderCancelRecord.Product);
decimal balqty = _SaleOrderCancelLineService.GetSaleOrderBalanceQty(SaleOrderCancelRecord.SaleOrderNo, SaleOrderCancelRecord.Product);
if (balqty != null)
{
i = i + 1;
if (balqty < SaleOrderCancelRecord.Quantity)
{
strOtherValidation.Append("SaleOrder Cancel qty is greater than Order qty for Sale Order " + SaleOrderCancelRecord.SaleOrderNo + " and Product " + SaleOrderCancelRecord.Product + "." + Environment.NewLine);
}
}
}
if (!string.IsNullOrEmpty(strSaleOrderCancelNo.ToString()) || !string.IsNullOrEmpty(strSaleOrder.ToString()) || !string.IsNullOrEmpty(strOtherValidation.ToString()))
{
if (string.IsNullOrEmpty(strSaleOrderCancelNo.ToString()))
{
ViewBag.SaleOrderCancelNo = null;
}
else
{
ViewBag.SaleOrderCancelNo = strSaleOrderCancelNo;
}
if (string.IsNullOrEmpty(strSaleOrder.ToString()))
{
ViewBag.SaleOrder = null;
}
else
{
ViewBag.SaleOrder = strSaleOrder;
}
if (string.IsNullOrEmpty(strOtherValidation.ToString()))
{
ViewBag.OtherValidation = null;
}
else
{
ViewBag.OtherValidation = strOtherValidation;
}
return(View());
}
else
{
string previousRecord = null;
int count = 0;
SaleOrderCancelHeader Temp_SaleOrderCancelHeader = new SaleOrderCancelHeader();
foreach (var SaleOrderCancelRecord in SaleOrderCancelRecordList)
{
//Object for SaleOrderCancelLine Model
SaleOrderCancelLine sl = new SaleOrderCancelLine();
sl.CreatedBy = User.Identity.Name;
sl.CreatedDate = DateTime.Now;
sl.ModifiedBy = User.Identity.Name;
sl.ModifiedDate = DateTime.Now;
sl.SaleOrderCancelHeaderId = Temp_SaleOrderCancelHeader.SaleOrderCancelHeaderId;
sl.SaleOrderLineId = _SaleOrderCancelLineService.GetSaleOrderLineIdForProductandSaleOrderDocNo(SaleOrderCancelRecord.SaleOrderNo, SaleOrderCancelRecord.Product);
sl.Qty = SaleOrderCancelRecord.Quantity;
if (count == 0 || SaleOrderCancelRecord.SaleOrderCancelNo != previousRecord)
{
//Object for SaleOrderCancelHeader Model
SaleOrderCancelHeader sh = new SaleOrderCancelHeader();
sh.CreatedBy = User.Identity.Name;
sh.CreatedDate = DateTime.Now;
sh.DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"];
sh.SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"];
sh.DocDate = SaleOrderCancelRecord.CancelDate;
sh.DocNo = SaleOrderCancelRecord.SaleOrderCancelNo;
sh.DocTypeId = new DocumentTypeService(_unitOfWork).FindByName(TransactionDocCategoryConstants.SaleOrderCancel).DocumentTypeId;
sh.ModifiedBy = User.Identity.Name;
sh.ModifiedDate = DateTime.Now;
sh.Remark = SaleOrderCancelRecord.Remark;
sh.ReasonId = new ReasonService(_unitOfWork).FindByName(TransactionDocCategoryConstants.SaleOrderCancel).ReasonId;
int BuyerId = (from L in db.SaleOrderLine
join H in db.SaleOrderHeader on L.SaleOrderHeaderId equals H.SaleOrderHeaderId into SaleOrderHeaderTable
from SaleOrderHeaderTab in SaleOrderHeaderTable.DefaultIfEmpty()
where L.SaleOrderLineId == sl.SaleOrderLineId
select new { BuyerId = SaleOrderHeaderTab.SaleToBuyerId }).FirstOrDefault().BuyerId;
sh.BuyerId = BuyerId;
_SaleOrderCancelHeaderService.Create(sh);
Temp_SaleOrderCancelHeader = sh;
}
_SaleOrderCancelLineService.Create(sl);
count++;
previousRecord = SaleOrderCancelRecord.SaleOrderCancelNo;
//Saving DB::
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
throw ex;
}
}
return(View("Sucess"));
}
}
public ActionResult _CreatePost(SaleOrderCancelLineViewModel svm)
{
SaleOrderCancelHeader temp2 = new SaleOrderCancelHeaderService(_unitOfWork).Find(svm.SaleOrderCancelHeaderId);
if (svm.SaleOrderCancelLineId <= 0)
{
SaleOrderCancelLine s = new SaleOrderCancelLine();
decimal balqty = (from p in db.ViewSaleOrderBalanceForCancellation
where p.SaleOrderLineId == svm.SaleOrderLineId
select p.BalanceQty).FirstOrDefault();
if (balqty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Balance Qty");
}
if (svm.Qty == 0)
{
ModelState.AddModelError("Qty", "Please Check Qty");
}
if (ModelState.IsValid)
{
s.Remark = svm.LineRemark;
s.SaleOrderCancelHeaderId = svm.SaleOrderCancelHeaderId;
s.SaleOrderLineId = svm.SaleOrderLineId ?? 0;
s.Qty = svm.Qty;
s.CreatedDate = DateTime.Now;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
_SaleOrderCancelLineService.Create(s);
new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyOnCancel(s.SaleOrderLineId, s.SaleOrderCancelLineId, temp2.DocDate, s.Qty);
if (temp2.Status != (int)StatusConstants.Drafted && temp2.Status != (int)StatusConstants.Import)
{
temp2.Status = (int)StatusConstants.Modified; temp2.ModifiedBy = User.Identity.Name; temp2.ModifiedDate = DateTime.Now;
}
new SaleOrderCancelHeaderService(_unitOfWork).Update(temp2);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp2.DocTypeId,
DocId = temp2.SaleOrderCancelHeaderId,
DocLineId = s.SaleOrderCancelLineId,
ActivityType = (int)ActivityTypeContants.Added,
DocNo = temp2.DocNo,
DocDate = temp2.DocDate,
DocStatus = temp2.Status,
}));
return(RedirectToAction("_Create", new { id = s.SaleOrderCancelHeaderId, bid = svm.BuyerId }));
}
return(PartialView("_Create", svm));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
SaleOrderCancelHeader temp = new SaleOrderCancelHeaderService(_unitOfWork).Find(svm.SaleOrderCancelHeaderId);
int status = temp.Status;
StringBuilder logstring = new StringBuilder();
SaleOrderCancelLine s = _SaleOrderCancelLineService.Find(svm.SaleOrderCancelLineId);
SaleOrderCancelLine ExRec = new SaleOrderCancelLine();
ExRec = Mapper.Map <SaleOrderCancelLine>(s);
decimal balqty = (from p in db.ViewSaleOrderBalanceForCancellation
where p.SaleOrderLineId == svm.SaleOrderLineId
select p.BalanceQty).FirstOrDefault();
if (balqty + s.Qty < svm.Qty)
{
ModelState.AddModelError("Qty", "Qty Exceeding Balance Qty");
}
if (ModelState.IsValid)
{
if (svm.Qty > 0)
{
//Tracking the Modification::
if (status == (int)StatusConstants.Approved)
{
logstring.Append("Editing SaleOrderCancelLineId No:" + svm.SaleOrderCancelLineId + "::\n");
if ((s.Remark != svm.Remark))
{
logstring.Append(s.Remark + " Remark Modified to " + svm.Remark + "::\n");
}
if ((s.Qty != svm.Qty))
{
logstring.Append(s.Qty + " Qty Modified to " + svm.Qty + "::\n");
}
}
//Ennd of Checking Modifications
s.Remark = svm.LineRemark;
s.Qty = svm.Qty;
s.ModifiedBy = User.Identity.Name;
s.ModifiedDate = DateTime.Now;
new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyOnCancel(s.SaleOrderLineId, s.SaleOrderCancelLineId, temp.DocDate, s.Qty);
}
_SaleOrderCancelLineService.Update(s);
if (temp.Status != (int)StatusConstants.Drafted && temp.Status != (int)StatusConstants.Import)
{
temp.Status = (int)StatusConstants.Modified;
temp.ModifiedDate = DateTime.Now;
temp.ModifiedBy = User.Identity.Name;
}
new SaleOrderCancelHeaderService(_unitOfWork).Update(temp);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = s,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXCL"] += message;
return(PartialView("_Create", svm));
}
//SAving the Activity Log::
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = temp.DocTypeId,
DocId = temp.SaleOrderCancelHeaderId,
DocLineId = s.SaleOrderCancelLineId,
ActivityType = (int)ActivityTypeContants.Modified,
DocNo = temp.DocNo,
xEModifications = Modifications,
DocDate = temp.DocDate,
DocStatus = temp.Status,
}));
//End Of Saving Activity Log
return(Json(new { success = true }));
}
return(PartialView("_Create", svm));
}
}
public ActionResult CompleteSaleOrderCancelLine(SaleOrderCancelMasterDetailModel vm)
{
int SaleOrderCancelHeaderId = 0;
if (ModelState.IsValid)
{
foreach (var item in vm.SaleOrderCancelViewModels)
{
decimal balqty = (from p in db.ViewSaleOrderBalanceForCancellation
where p.SaleOrderLineId == item.SaleOrderLineId
select p.BalanceQty).FirstOrDefault();
if (balqty < item.Qty)
{
return(View(vm).Danger("Qty Exceeding Bal Qty"));
}
if (item.Qty > 0)
{
SaleOrderCancelLine line = new SaleOrderCancelLine();
line.SaleOrderCancelHeaderId = item.SaleOrderCancelHeaderId;
line.SaleOrderLineId = item.SaleOrderLineId ?? 0;
line.Qty = item.Qty;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.Remark = item.LineRemark;
_SaleOrderCancelLineService.Create(line);
}
SaleOrderCancelHeaderId = item.SaleOrderCancelHeaderId;
}
//_unitOfWork.Save();
SaleOrderCancelHeader header = new SaleOrderCancelHeaderService(_unitOfWork).Find(SaleOrderCancelHeaderId);
if (header.Status != (int)StatusConstants.Drafted && header.Status != (int)StatusConstants.Import)
{
header.Status = (int)StatusConstants.Submitted; header.ModifiedBy = User.Identity.Name; header.ModifiedDate = DateTime.Now;
}
//Activity Log
ActivityLog al = new ActivityLog()
{
ActivityType = (int)StatusConstants.Submitted,
DocId = header.SaleOrderCancelHeaderId,
UserRemark = header.Remark,
Narration = "Sale Order Cancel Submitted with Cancel no:" + header.DocNo,
CreatedDate = DateTime.Now,
CreatedBy = User.Identity.Name,
DocTypeId = header.DocTypeId,
};
new SaleOrderCancelHeaderService(_unitOfWork).Update(header);
_ActivityLogService.Create(al);
_unitOfWork.Save();
return(RedirectToActionPermanent("Index", "SaleOrderCancelHeader"));
}
return(View(vm));
}
public ActionResult _ResultsPost(SaleOrderCancelMasterDetailModel vm)
{
Dictionary <int, decimal> LineStatus = new Dictionary <int, decimal>();
var Header = new SaleOrderCancelHeaderService(_unitOfWork).Find(vm.SaleOrderCancelViewModels.FirstOrDefault().SaleOrderCancelHeaderId);
if (ModelState.IsValid)
{
foreach (var item in vm.SaleOrderCancelViewModels)
{
decimal balqty = (from p in db.ViewSaleOrderBalanceForCancellation
where p.SaleOrderLineId == item.SaleOrderLineId
select p.BalanceQty).FirstOrDefault();
if (balqty < item.Qty)
{
return(View("_Results", vm).Danger("Qty Exceeding Bal Qty"));
}
if (item.Qty > 0)
{
SaleOrderCancelLine line = new SaleOrderCancelLine();
line.SaleOrderCancelHeaderId = item.SaleOrderCancelHeaderId;
line.SaleOrderLineId = item.SaleOrderLineId ?? 0;
line.Qty = item.Qty;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.Remark = item.LineRemark;
LineStatus.Add(line.SaleOrderLineId, line.Qty);
_SaleOrderCancelLineService.Create(line);
}
}
if (Header.Status != (int)StatusConstants.Drafted && Header.Status != (int)StatusConstants.Import)
{
Header.Status = (int)StatusConstants.Modified;
Header.ObjectState = Model.ObjectState.Modified;
new SaleOrderCancelHeaderService(_unitOfWork).Update(Header);
}
new SaleOrderLineStatusService(_unitOfWork).UpdateSaleQtyCancelMultiple(LineStatus, Header.DocDate);
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 = Header.DocTypeId,
DocId = Header.SaleOrderCancelHeaderId,
ActivityType = (int)ActivityTypeContants.MultipleCreate,
DocNo = Header.DocNo,
DocDate = Header.DocDate,
DocStatus = Header.Status,
}));
return(Json(new { success = true }));
}
return(PartialView("_Results", vm));
}
public SaleOrderCancelLine Add(SaleOrderCancelLine p)
{
_unitOfWork.Repository <SaleOrderCancelLine>().Insert(p);
return(p);
}
public void Update(SaleOrderCancelLine p)
{
p.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <SaleOrderCancelLine>().Update(p);
}
public void Delete(SaleOrderCancelLine p)
{
_unitOfWork.Repository <SaleOrderCancelLine>().Delete(p);
}
public SaleOrderCancelLine Create(SaleOrderCancelLine p)
{
p.ObjectState = ObjectState.Added;
_unitOfWork.Repository <SaleOrderCancelLine>().Insert(p);
return(p);
}
