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);
}
}
