public ActionResult _Create(int Id) //Id ==>Sale Order Header Id
{
ProductCustomGroupHeader H = new ProductCustomGroupHeaderService(_unitOfWork).Find(Id);
ProductCustomGroupLine s = new ProductCustomGroupLine();
s.ProductCustomGroupHeaderId = H.ProductCustomGroupId;
return(PartialView("_Create", s));
}
public ActionResult _Edit(int id)
{
ProductCustomGroupLine temp = _ProductCustomGroupLineService.GetProductCustomGroupLine(id);
if (temp == null)
{
return(HttpNotFound());
}
return(PartialView("_Create", temp));
}
public ActionResult DeletePost(ProductCustomGroupLine vm)
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
ProductCustomGroupLine ProductCustomGroupLine = _ProductCustomGroupLineService.GetProductCustomGroupLine(vm.ProductCustomGroupLineId);
LogList.Add(new LogTypeViewModel
{
ExObj = ProductCustomGroupLine,
});
_ProductCustomGroupLineService.Delete(vm.ProductCustomGroupLineId);
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(PartialView("EditLine", vm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductCustomGroup).DocumentTypeId,
DocId = vm.ProductCustomGroupHeaderId,
DocLineId = vm.ProductCustomGroupLineId,
ActivityType = (int)ActivityTypeContants.Deleted,
xEModifications = Modifications,
}));
return(Json(new { success = true }));
}
public ActionResult ProductCustomGroupExcelImport()
{
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 ProductCustomGroupRecordList = from c in excel.Worksheet <ProductCustomGroupExcelViewModel>() select c;
StringBuilder strProduct = new StringBuilder();
foreach (var ProductCustomGroupRecord in ProductCustomGroupRecordList)
{
if (_ProductService.Find(ProductCustomGroupRecord.ProductName) == null)
{
if (!strProduct.ToString().Contains("" + ProductCustomGroupRecord.ProductName))
{
strProduct.Append(" " + ProductCustomGroupRecord.ProductName + ",");
}
}
}
if (!string.IsNullOrEmpty(strProduct.ToString()))
{
if (string.IsNullOrEmpty(strProduct.ToString()))
{
ViewBag.product = null;
}
else
{
ViewBag.product = strProduct;
}
return(View());
}
else
{
string previousRecord = null;
int count = 0;
ProductCustomGroupHeader stemp = new ProductCustomGroupHeader();
foreach (var ProductCustomGroupRecord in ProductCustomGroupRecordList)
{
if (count == 0 || ProductCustomGroupRecord.ProductCustomGroupName != previousRecord)
{
ProductCustomGroupHeader s = new ProductCustomGroupHeader();
s.ProductCustomGroupName = ProductCustomGroupRecord.ProductCustomGroupName;
s.IsActive = true;
s.CreatedDate = DateTime.Now;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
_ProductCustomGroupHeaderService.Create(s);
stemp = s;
}
//Object for ProductCustomGroupLineDetail Model to Save Rate, Quantity, Product
Product product = _ProductService.Find(ProductCustomGroupRecord.ProductName);
ProductCustomGroupLine sl = new ProductCustomGroupLine();
sl.ProductCustomGroupHeaderId = stemp.ProductCustomGroupId;
sl.ProductId = product.ProductId;
sl.Qty = ProductCustomGroupRecord.Qty;
sl.CreatedDate = DateTime.Now;
sl.ModifiedDate = DateTime.Now;
sl.CreatedBy = User.Identity.Name;
sl.ModifiedBy = User.Identity.Name;
_ProductCustomGroupLineService.Create(sl);
count++;
previousRecord = ProductCustomGroupRecord.ProductCustomGroupName;
_unitOfWork.Save();
}
return(View("Sucess"));
}
}
public ActionResult _CreatePost(ProductCustomGroupLine svm)
{
if (svm.Qty <= 0)
{
ModelState.AddModelError("Qty", "Please Check Qty");
}
if (ModelState.IsValid)
{
if (svm.ProductCustomGroupLineId == 0)
{
svm.CreatedDate = DateTime.Now;
svm.ModifiedDate = DateTime.Now;
svm.CreatedBy = User.Identity.Name;
svm.ModifiedBy = User.Identity.Name;
svm.ObjectState = Model.ObjectState.Added;
_ProductCustomGroupLineService.Create(svm);
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 = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductCustomGroup).DocumentTypeId,
DocId = svm.ProductCustomGroupHeaderId,
DocLineId = svm.ProductCustomGroupLineId,
ActivityType = (int)ActivityTypeContants.Added,
}));
return(RedirectToAction("_Create", new { id = svm.ProductCustomGroupHeaderId }));
}
else
{
List <LogTypeViewModel> LogList = new List <LogTypeViewModel>();
ProductCustomGroupLine temp1 = _ProductCustomGroupLineService.Find(svm.ProductCustomGroupLineId);
ProductCustomGroupLine ExRec = Mapper.Map <ProductCustomGroupLine>(temp1);
temp1.ProductId = svm.ProductId;
temp1.Qty = svm.Qty;
temp1.ModifiedDate = DateTime.Now;
temp1.ModifiedBy = User.Identity.Name;
_ProductCustomGroupLineService.Update(temp1);
LogList.Add(new LogTypeViewModel
{
ExObj = ExRec,
Obj = temp1,
});
XElement Modifications = new ModificationsCheckService().CheckChanges(LogList);
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 = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductCustomGroup).DocumentTypeId,
DocId = temp1.ProductCustomGroupHeaderId,
DocLineId = temp1.ProductCustomGroupLineId,
ActivityType = (int)ActivityTypeContants.Modified,
xEModifications = Modifications,
}));
return(Json(new { success = true }));
}
}
return(PartialView("_Create", svm));
}
public void Update(ProductCustomGroupLine s)
{
s.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <ProductCustomGroupLine>().Update(s);
}
public void Delete(ProductCustomGroupLine s)
{
_unitOfWork.Repository <ProductCustomGroupLine>().Delete(s);
}
public ProductCustomGroupLine Create(ProductCustomGroupLine S)
{
S.ObjectState = ObjectState.Added;
_unitOfWork.Repository <ProductCustomGroupLine>().Insert(S);
return(S);
}
