public JsonResult SaveGradeSelectionData(PreGradeSelectionData model)
{
var confirmMessage = _dalPrqPreGradeSelection.SaveGradeSelectionData(model);
return(new JsonResult {
Data = confirmMessage
});
}
public ValidationMsg SaveGradeSelectionData(PreGradeSelectionData model)
{
try
{
using (var tx = new TransactionScope())
{
using (_context)
{
if (model.SelectionID == 0)
{
var objPreGradeSelection = new Prq_PreGradeSelection
{
SelectionType = "PGS",
SupplierID = model.SupplierID,
PurchaseID = model.PurchaseID,
ItemTypeID = model.ItemTypeID,
SupplierAddressID = model.SupplierAddressID,
SelectionStore = model.SelectionStore,
SelectionDate = Convert.ToDateTime(model.SelectionDate),
SelectedBy = model.SelectedBy,
SelectionComments = model.SelectionComments,
ApprovedBy = model.ApprovedBy,
ApproveComments = model.ApproveComments,
CheckedBy = model.CheckedBy,
CheckComments = model.CheckComments,
RecordStatus = "NCF"
};
_context.Prq_PreGradeSelection.Add(objPreGradeSelection);
foreach (var gradeSelection in model.GradeSelectedList)
{
var objPreGradeSelectedData = new Prq_PreGradeSelectedData
{
SelectionID = objPreGradeSelection.SelectionID,
GradeID = gradeSelection.GradeID,
GradeQty = gradeSelection.GradeQty,
GradeSide = gradeSelection.GradeSide,
GradeArea = gradeSelection.GradeArea,
UnitID = gradeSelection.UnitID,
RecordStatus = "NCF",
SetOn = DateTime.Now
};
_context.Prq_PreGradeSelectedData.Add(objPreGradeSelectedData);
}
_context.SaveChanges();
}
else
{
var query = new StringBuilder();
query.Append("Delete From Prq_PreGradeSelectedData");
query.Append(" WHERE [SelectionID] = '" + model.SelectionID + "'");
_context.Database.ExecuteSqlCommand(query.ToString());
foreach (var gradeSelection in model.GradeSelectedList)
{
var objPreGradeSelectedData = new Prq_PreGradeSelectedData
{
SelectionID = model.SelectionID,
GradeID = gradeSelection.GradeID,
GradeQty = gradeSelection.GradeQty,
GradeArea = gradeSelection.GradeArea,
UnitID = gradeSelection.UnitID,
GradeSide = gradeSelection.GradeSide,
RecordStatus = "NCF",
SetOn = DateTime.Now
};
_context.Prq_PreGradeSelectedData.Add(objPreGradeSelectedData);
}
_context.SaveChanges();
}
tx.Complete();
_vmMsg.Type = Enums.MessageType.Success;
_vmMsg.Msg = "Saved Successfully.";
}
}
}
catch (Exception)
{
_vmMsg.Type = Enums.MessageType.Error;
_vmMsg.Msg = "Failed to save.";
}
return(_vmMsg);
}
