public static InventoryLogNote fnCreateInventoryLogNote(int id)
{
InventoryLogNote obj = new InventoryLogNote();
using (var db = new EF.CMCSQL03Entities())
{
obj.productnoteid = -1;
obj.productmasterid = id; // important
obj.reasoncode = null;
obj.notedate = DateTime.UtcNow;
obj.notes = null;
obj.ListOfReasonCodes = (from t in db.tblReasonCode
orderby t.Reason
select new SelectListItem { Value = t.Reason, Text = t.Reason }).ToList();
obj.ListOfReasonCodes.Insert(0, new SelectListItem { Value = "", Text = "Select Reason Code" });
}
return obj;
}
public static int fnSaveInventoryLogNote(InventoryLogNote obj)
{
using (var db = new EF.CMCSQL03Entities())
{
if (obj.productnoteid == -1)
{
var newrec = new EF.tblInvPMLogNote();
db.tblInvPMLogNote.Add(newrec);
db.SaveChanges();
obj.productnoteid = newrec.InvPMLogNoteIDID;
}
var q = (from t in db.tblInvPMLogNote
where t.InvPMLogNoteIDID == obj.productnoteid
select t).FirstOrDefault();
q.ProductMasterID = obj.productmasterid;
q.NoteDate = DateTime.UtcNow;
q.Notes = obj.notes;
q.Comment = obj.reasoncode;
db.SaveChanges();
return q.InvPMLogNoteIDID;
}
}
public static InventoryLogNote fnGetInventoryNote(int id)
{
InventoryLogNote obj = new InventoryLogNote();
using (var db = new EF.CMCSQL03Entities())
{
var q = (from t in db.tblInvPMLogNote
where t.InvPMLogNoteIDID == id
select t).FirstOrDefault();
obj.productnoteid = q.InvPMLogNoteIDID;
obj.productmasterid = q.ProductMasterID;
obj.reasoncode = q.Comment;
obj.notedate = q.NoteDate;
obj.notes = q.Notes;
obj.ListOfReasonCodes = (from t in db.tblReasonCode
orderby t.Reason
select new SelectListItem { Value = t.Reason, Text = t.Reason }).ToList();
obj.ListOfReasonCodes.Insert(0, new SelectListItem { Value = "", Text = "Select Reason Code" });
}
return obj;
}
public ActionResult SaveInventoryLogNote(InventoryLogNote obj)
{
int pk = InventoryService.fnSaveInventoryLogNote(obj);
return null;
}
