public ValidationMsg Save(SysArticleChallan model, int userId) { var transactionOption = new TransactionOptions { Timeout = new TimeSpan(0, 0, 99999) }; var vMsg = new ValidationMsg(); using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption)) { try { _dalCrustChallanPreparation = new DalCrustChallanPreparation(); ChallanID = _dalCrustChallanPreparation.Save(model, userId); //GetpurchaseID(purchaseID); if (ChallanID > 0) { transactionScope.Complete(); vMsg.Type = Enums.MessageType.Success; vMsg.Msg = "Saved successfully."; //vMsg.ReturnId = _dalChemicalForeignPurchaseOrder.GetOrderNo(OrderID); } else { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to save."; } } catch (Exception e) { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to save."; } } return(vMsg); }
public ActionResult CrustChallanPreparation(SysArticleChallan model) { if (model.ArticleChallanID == 0) { var msg = objBll.Save(model, Convert.ToInt32(Session["UserID"])); long ArticleChallanID = objBll.GetChallanID(); var DetailList = objDal.GetArticleDetailListAfterSave(ArticleChallanID); var ColorList = objDal.GetArticleColorListAfterSave(ArticleChallanID); return(Json(new { Msg = msg, ArticleChallanID = ArticleChallanID, DetailList = DetailList, ColorList = ColorList }, JsonRequestBehavior.AllowGet)); } else { var msg = objBll.Update(model, Convert.ToInt32(Session["UserID"])); var DetailList = objDal.GetArticleDetailListAfterSave(model.ArticleChallanID); var ColorList = objDal.GetArticleColorListAfterSave(model.ArticleChallanID); return(Json(new { Msg = msg, DetailList = DetailList, ColorList = ColorList }, JsonRequestBehavior.AllowGet)); } }
public ValidationMsg Update(SysArticleChallan model, int userId) { var transactionOption = new TransactionOptions { Timeout = new TimeSpan(0, 0, 9999) }; var vMsg = new ValidationMsg(); using (var transactionScope = new TransactionScope(TransactionScopeOption.RequiresNew, transactionOption)) { try { _dalCrustChallanPreparation = new DalCrustChallanPreparation(); var UpdateStatus = _dalCrustChallanPreparation.Update(model, userId); if (UpdateStatus > 0) { transactionScope.Complete(); vMsg.Type = Enums.MessageType.Update; vMsg.Msg = "Updated successfully."; } else { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to Update."; } } catch (Exception) { vMsg.Type = Enums.MessageType.Error; vMsg.Msg = "Failed to Update."; } } return(vMsg); }
public long Save(SysArticleChallan model, int userId) { long CurrentChallanID = 0; try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { Sys_ArticleChallan objChallan = new Sys_ArticleChallan(); objChallan.ArticleChallanNo = model.ArticleChallanNo; objChallan.ChallanNote = model.ChallanNote; objChallan.PreparationDate = DalCommon.SetDate(model.PreparationDate); objChallan.BuyerID = model.BuyerID; objChallan.ArticleID = model.ArticleID; objChallan.ArticleArea = model.ArticleArea; objChallan.AreaUnit = model.AreaUnit; objChallan.ArticleNote = model.ArticleNote; objChallan.RecordStatus = "NCF"; objChallan.SetBy = userId; objChallan.ModifiedOn = DateTime.Now; objChallan.IsActive = true; _context.Sys_ArticleChallan.Add(objChallan); _context.SaveChanges(); CurrentChallanID = objChallan.ArticleChallanID; if (model.ArticleDetailList != null) { foreach (var article in model.ArticleDetailList) { Sys_ArticleChallanDetail objArticleDetail = new Sys_ArticleChallanDetail(); objArticleDetail.ArticleChallanID = CurrentChallanID; objArticleDetail.SizeRange = article.SizeRange; if (article.SizeRangeUnitName != null && article.SizeRangeUnitName != "") { objArticleDetail.SizeRangeUnit = DalCommon.GetUnitCode(article.SizeRangeUnitName); } objArticleDetail.PcsSideDescription = article.PcsSideDescription; objArticleDetail.GradeRange = article.GradeRange; objArticleDetail.ThicknessRange = article.ThicknessRange; objArticleDetail.RequiredPercentage = article.RequiredPercentage; if (article.ThicknessUnitName != null && article.ThicknessUnitName != "") { objArticleDetail.ThicknessUnit = DalCommon.GetUnitCode(article.ThicknessUnitName); } objArticleDetail.ThicknessAt = (article.ThicknessAt == "After Shaving" ? "AFSV" : "AFFN"); objArticleDetail.Remarks = article.Remarks; objArticleDetail.SetBy = userId; objArticleDetail.SetOn = DateTime.Now; _context.Sys_ArticleChallanDetail.Add(objArticleDetail); _context.SaveChanges(); } } if (model.ColorList != null) { foreach (var color in model.ColorList) { Sys_ArticleChallanColor objColor = new Sys_ArticleChallanColor(); objColor.ArticleChallanID = CurrentChallanID; objColor.ArticleColorNo = color.ArticleColorNo; objColor.ArticleColor = color.ArticleColor; objColor.ArticleColorArea = color.ArticleColorArea; if (color.ColorAreaUnitName != null && color.ColorAreaUnitName != "") { objColor.ColorAreaUnit = DalCommon.GetUnitCode(color.ColorAreaUnitName); } if (color.RemarkDate != null) { objColor.RemarkDate = Convert.ToDateTime(color.RemarkDate); } objColor.Remarks = color.Remarks; objColor.QuantityDescription = color.QuantityDescription; objColor.SetBy = userId; objColor.SetOn = DateTime.Now; _context.Sys_ArticleChallanColor.Add(objColor); _context.SaveChanges(); } } } transaction.Complete(); } return(CurrentChallanID); } catch (Exception e) { return(0); } }
public int Update(SysArticleChallan model, int userId) { try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { var Challan = (from c in _context.Sys_ArticleChallan.AsEnumerable() where c.ArticleChallanID == model.ArticleChallanID select c).FirstOrDefault(); Challan.ArticleChallanNo = model.ArticleChallanNo; Challan.ChallanNote = model.ChallanNote; Challan.PreparationDate = DalCommon.SetDate(model.PreparationDate); Challan.BuyerID = model.BuyerID; Challan.ArticleID = model.ArticleID; Challan.ArticleArea = model.ArticleArea; Challan.AreaUnit = model.AreaUnit; Challan.ArticleNote = model.ArticleNote; Challan.ModifiedBy = userId; Challan.ModifiedOn = DateTime.Now; _context.SaveChanges(); if (model.ArticleDetailList != null) { foreach (var article in model.ArticleDetailList) { if (article.ArticleChallanDtlID != 0) { var ChallanDetail = (from cd in _context.Sys_ArticleChallanDetail.AsEnumerable() where cd.ArticleChallanDtlID == article.ArticleChallanDtlID select cd).FirstOrDefault(); ChallanDetail.ArticleChallanID = model.ArticleChallanID; ChallanDetail.SizeRange = article.SizeRange; if (article.SizeRangeUnitName != null && article.SizeRangeUnitName != "") { ChallanDetail.SizeRangeUnit = DalCommon.GetUnitCode(article.SizeRangeUnitName); } ChallanDetail.PcsSideDescription = article.PcsSideDescription; ChallanDetail.GradeRange = article.GradeRange; ChallanDetail.ThicknessRange = article.ThicknessRange; ChallanDetail.RequiredPercentage = article.RequiredPercentage; if (article.ThicknessUnitName != null && article.ThicknessUnitName != "") { ChallanDetail.ThicknessUnit = DalCommon.GetUnitCode(article.ThicknessUnitName); } ChallanDetail.ThicknessAt = (article.ThicknessAt == "After Shaving" ? "AFSV" : "AFFN"); ChallanDetail.Remarks = article.Remarks; ChallanDetail.ModifiedBy = userId; ChallanDetail.ModifiedOn = DateTime.Now; _context.SaveChanges(); } else { Sys_ArticleChallanDetail objArticleDetail = new Sys_ArticleChallanDetail(); objArticleDetail.ArticleChallanID = model.ArticleChallanID; objArticleDetail.SizeRange = article.SizeRange; if (article.SizeRangeUnitName != null && article.SizeRangeUnitName != "") { objArticleDetail.SizeRangeUnit = DalCommon.GetUnitCode(article.SizeRangeUnitName); } objArticleDetail.PcsSideDescription = article.PcsSideDescription; objArticleDetail.GradeRange = article.GradeRange; objArticleDetail.ThicknessRange = article.ThicknessRange; if (article.ThicknessUnitName != null && article.ThicknessUnitName != "") { objArticleDetail.ThicknessUnit = DalCommon.GetUnitCode(article.ThicknessUnitName); } objArticleDetail.RequiredPercentage = article.RequiredPercentage; objArticleDetail.ThicknessAt = (article.ThicknessAt == "After Shaving" ? "AFSV" : "AFFN"); objArticleDetail.Remarks = article.Remarks; objArticleDetail.SetBy = userId; objArticleDetail.SetOn = DateTime.Now; _context.Sys_ArticleChallanDetail.Add(objArticleDetail); _context.SaveChanges(); } } } if (model.ColorList != null) { foreach (var color in model.ColorList) { if (color.ArticleChallanIDColor != 0) { var ColorDetail = (from cd in _context.Sys_ArticleChallanColor.AsEnumerable() where cd.ArticleChallanIDColor == color.ArticleChallanIDColor select cd).FirstOrDefault(); ColorDetail.ArticleChallanID = model.ArticleChallanID; ColorDetail.ArticleColorNo = color.ArticleColorNo; ColorDetail.ArticleColor = color.ArticleColor; ColorDetail.ArticleColorArea = color.ArticleColorArea; ColorDetail.QuantityDescription = color.QuantityDescription; if (color.ColorAreaUnitName != null && color.ColorAreaUnitName != "") { ColorDetail.ColorAreaUnit = DalCommon.GetUnitCode(color.ColorAreaUnitName); } if (color.RemarkDate != null) { try { var GridRemarkDate = color.RemarkDate.Contains("/") ? color.RemarkDate : Convert.ToDateTime(color.RemarkDate).ToString("dd/MM/yyyy"); ColorDetail.RemarkDate = DalCommon.SetDate(GridRemarkDate); } catch { var GridRemarkDate = Convert.ToDateTime(color.RemarkDate).Date.ToString("dd/MM/yyyy"); ColorDetail.RemarkDate = DalCommon.SetDate(GridRemarkDate); } } //else //{ // ColorDetail.RemarkDate = null; //} //if (color.RemarkDate != null) // ColorDetail.RemarkDate = Convert.ToDateTime(color.RemarkDate); ColorDetail.Remarks = color.Remarks; ColorDetail.ModifiedBy = userId; ColorDetail.ModifiedOn = DateTime.Now; _context.SaveChanges(); } else { Sys_ArticleChallanColor objColor = new Sys_ArticleChallanColor(); objColor.ArticleChallanID = model.ArticleChallanID; objColor.ArticleColorNo = color.ArticleColorNo; objColor.ArticleColor = color.ArticleColor; objColor.ArticleColorArea = color.ArticleColorArea; objColor.QuantityDescription = color.QuantityDescription; if (color.ColorAreaUnitName != null && color.ColorAreaUnitName != "") { objColor.ColorAreaUnit = DalCommon.GetUnitCode(color.ColorAreaUnitName); } if (color.RemarkDate != null) { objColor.RemarkDate = Convert.ToDateTime(color.RemarkDate); } objColor.Remarks = color.Remarks; objColor.SetBy = userId; objColor.SetOn = DateTime.Now; _context.Sys_ArticleChallanColor.Add(objColor); _context.SaveChanges(); } } } } transaction.Complete(); } return(1); } catch (Exception e) { return(0); } }