public InvLeatherIssue SetToBussinessObject(Inv_LeatherIssue Entity)
{
InvLeatherIssue Model = new InvLeatherIssue();
Model.IssueID = Entity.IssueID;
Model.IssueDate = Entity.IssueDate.Date.ToString("dd/MM/yyyy");
Model.IssueRef = Entity.IssueRef;
Model.IssueFor = Entity.IssueFor;
//switch (Entity.IssueFor)
//{
// case "Leather":
// Model.IssueForName = "Store Transfer";
// break;
// case "Production":
// Model.IssueForName = "Production";
// break;
// case "Job Order":
// Model.IssueForName = "Job Order";
// break;
//}
Model.IssueFrom = Entity.IssueFrom;
Model.IssueFromName = Entity.IssueFrom == null ? "" : _context.SYS_Store.Where(m => m.StoreID == Entity.IssueFrom).FirstOrDefault().StoreName;
Model.IssueTo = Entity.IssueTo;
Model.IssueToName = Entity.IssueTo == null ? "" : _context.SYS_Store.Where(m => m.StoreID == Entity.IssueTo).FirstOrDefault().StoreName;
Model.JobOrderNo = Entity.JobOrderNo;
Model.JobOrderNo = Entity.JobOrderNo;
Model.PurchaseYear = Entity.PurchaseYear;
Model.RecordStatus = Entity.RecordStatus;
switch (Entity.RecordStatus)
{
case "NCF":
Model.RecordStatusName = "Not Confirmed";
break;
case "CNF":
Model.RecordStatusName = "Confirmed";
break;
case "APV":
Model.RecordStatusName = "Approved";
break;
case "RCV":
Model.RecordStatusName = "Received";
break;
default:
Model.RecordStatusName = "";
break;
}
return(Model);
}
public ValidationMsg Save(InvLeatherIssue model, int userid)
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
model.SetBy = userid;
Inv_LeatherIssue tblLeatherIssue = SetToModelObject(model);
_context.Inv_LeatherIssue.Add(tblLeatherIssue);
_context.SaveChanges();
#region Save Detail Records
if (model.LeatherIssueItemList != null)
{
foreach (InvLeatherIssueItem objInvLeatherIssueItem in model.LeatherIssueItemList)
{
objInvLeatherIssueItem.SetBy = userid;
objInvLeatherIssueItem.IssueID = tblLeatherIssue.IssueID;
Inv_LeatherIssueItem tblPurchaseYearPeriod =
SetToModelObject(objInvLeatherIssueItem);
_context.Inv_LeatherIssueItem.Add(tblPurchaseYearPeriod);
}
}
_context.SaveChanges();
#endregion
tx.Complete();
IssueID = tblLeatherIssue.IssueID;
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
}
}
catch
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
public Inv_LeatherIssue SetToModelObject(InvLeatherIssue model)
{
Inv_LeatherIssue Entity = new Inv_LeatherIssue();
Entity.IssueID = model.IssueID;
Entity.IssueDate = DalCommon.SetDate(model.IssueDate);// Convert.ToDateTime(model.IssueDate).Date;
Entity.IssueFor = model.IssueFor;
Entity.IssueRef = model.IssueRef;
Entity.IssueFrom = model.IssueFrom;
Entity.IssueTo = model.IssueTo;
Entity.JobOrderNo = model.JobOrderNo;
Entity.PurchaseYear = model.PurchaseYear;
Entity.RecordStatus = "NCF";
Entity.SetOn = DateTime.Now;
Entity.SetBy = model.SetBy;
Entity.IPAddress = string.Empty;
return(Entity);
}
public ValidationMsg Update(InvLeatherIssue model, int userid)
{
_vmMsg = new ValidationMsg();
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
Inv_LeatherIssue CurrentEntity = SetToModelObject(model);
var OriginalEntity = _context.Inv_LeatherIssue.First(m => m.IssueID == model.IssueID);
OriginalEntity.IssueDate = CurrentEntity.IssueDate;// Convert.ToDateTime(CurrentEntity.IssueDate).Date;
OriginalEntity.IssueFor = CurrentEntity.IssueFor;
OriginalEntity.IssueRef = CurrentEntity.IssueRef;
OriginalEntity.IssueFrom = CurrentEntity.IssueFrom;
OriginalEntity.IssueTo = CurrentEntity.IssueTo;
OriginalEntity.JobOrderNo = CurrentEntity.JobOrderNo;
OriginalEntity.PurchaseYear = CurrentEntity.PurchaseYear;
OriginalEntity.SetBy = userid;
OriginalEntity.SetOn = DateTime.Now;
#region Save Detail Records
if (model.LeatherIssueItemList != null)
{
foreach (InvLeatherIssueItem objInvLeatherIssueItem in model.LeatherIssueItemList)
{
if (objInvLeatherIssueItem.ItemIssueID == 0)
{
objInvLeatherIssueItem.IssueID = model.IssueID;
Inv_LeatherIssueItem tblPurchaseYearPeriod =
SetToModelObject(objInvLeatherIssueItem);
_context.Inv_LeatherIssueItem.Add(tblPurchaseYearPeriod);
}
else
{
Inv_LeatherIssueItem CurEntity = SetToModelObject(objInvLeatherIssueItem);
var OrgEntity = _context.Inv_LeatherIssueItem.First(m => m.ItemIssueID == objInvLeatherIssueItem.ItemIssueID);
OrgEntity.SupplierID = CurEntity.SupplierID;
OrgEntity.ChallanID = CurEntity.ChallanID;
OrgEntity.ItemType = CurEntity.ItemType;
OrgEntity.LeatherType = CurEntity.LeatherType;
OrgEntity.LeatherStatus = CurEntity.LeatherStatus;
OrgEntity.IssueQty = CurEntity.IssueQty;
OrgEntity.UnitID = CurEntity.UnitID;
OrgEntity.IssueSide = CurEntity.IssueSide;
OrgEntity.Remarks = CurEntity.Remarks;
OrgEntity.SetBy = userid;
OrgEntity.SetOn = DateTime.Now;
}
}
}
_context.SaveChanges();
#endregion
tx.Complete();
IssueID = model.IssueID;
_vmMsg.Type = Enums.MessageType.Update;
_vmMsg.Msg = "Updated Successfully.";
}
}
}
catch
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to Update.";
}
return(_vmMsg);
}
