public ServiceResult InsertMaterialRejectForm(Material_Reject_Form pForm) { try { using (var db = new AgnosDBContext()) { db.Material_Reject_Form.Add(pForm); db.SaveChanges(); db.Entry(pForm).GetDatabaseValues(); return(new ServiceResult() { Code = ReturnCode.SUCCESS, Msg = Success.GetMessage(ReturnCode.SUCCESS_INSERT), Field = Resource.Material_Reject }); } } catch (Exception ex) { return(new ServiceResult() { Code = ReturnCode.ERROR_INSERT, Msg = Error.GetMessage(ReturnCode.ERROR_INSERT), Field = Resource.Material_Reject, Exception = ex }); } }
public ServiceResult SaveMaterialRejectForm(Material_Reject_Form pForm) { try { using (var db = new AgnosDBContext()) { var form = db.Material_Reject_Form.Where(w => w.Material_Reject_ID == pForm.Material_Reject_ID).FirstOrDefault(); if (form != null) { db.Material_Reject_Form.Remove(form); } db.Material_Reject_Form.Add(pForm); db.SaveChanges(); return(new ServiceResult() { Code = ReturnCode.SUCCESS, Msg = Success.GetMessage(ReturnCode.SUCCESS_INSERT), Field = Resource.Material_Reject }); } } catch (Exception ex) { return(new ServiceResult() { Code = ReturnCode.ERROR_INSERT, Msg = Error.GetMessage(ReturnCode.ERROR_INSERT), Field = Resource.Attachment_File, Exception = ex }); } }
public ServiceResult UpdateMaterialReject(Material_Reject pRej, Material_Reject_Form pForm = null) { try { using (var db = new AgnosDBContext()) { var current = db.Material_Reject.Where(w => w.Material_Reject_ID == pRej.Material_Reject_ID).FirstOrDefault(); if (current != null) { if (string.IsNullOrEmpty(pRej.RMR_No)) { //------------- Start Running Number-----------------// var runningNumber = db.Running_Number_Config.Where(w => w.Running_Number_Type == Running_Number_Type.RMR).FirstOrDefault(); if (runningNumber == null) { runningNumber = new Running_Number_Config() { Ref_Count = 1, Number_Of_Digit = 2, Running_Number_Type = Running_Number_Type.RMR, Create_On = currentdate, Create_By = userlogin.Email_Address, Running_Year = currentdate.Year }; } else { if (!(runningNumber.Running_Year.HasValue && runningNumber.Running_Year == currentdate.Year)) { // reset Ref_Count runningNumber.Ref_Count = 1; runningNumber.Running_Year = currentdate.Year; runningNumber.Update_On = currentdate; runningNumber.Update_By = userlogin.Email_Address; } } string RMR_No = runningNumber.Ref_Count.ToString().PadLeft(runningNumber.Number_Of_Digit.Value, '0') + "/" + currentdate.Year.ToString().Substring(2, 2); var rcri = new MaterialRejectCriteria(); rcri.RMR_No = RMR_No; bool validNo = false; while (!validNo) { var rej = new Material_Reject(); var result = GetMaterialReject(rcri); if (result.Code == ReturnCode.SUCCESS) { var rejs = result.Object as List <Material_Reject>; if (rejs.Count() == 0) { validNo = true; } else { if (runningNumber.Ref_Count == 0) { runningNumber.Ref_Count = 1; } runningNumber.Update_On = currentdate; runningNumber.Update_By = userlogin.Email_Address; runningNumber.Ref_Count++; RMR_No = runningNumber.Ref_Count.ToString().PadLeft(runningNumber.Number_Of_Digit.Value, '0') + "/" + currentdate.Year.ToString().Substring(2, 2); } } } runningNumber.Ref_Count++; pRej.RMR_No = RMR_No; if (runningNumber.Running_Number_Config_ID == 0) { db.Running_Number_Config.Add(runningNumber); } //------------- End Running Number-----------------// } if (pForm != null) { var form = db.Material_Reject_Form.Where(w => w.Material_Reject_ID == current.Material_Reject_ID).FirstOrDefault(); if (form != null) { db.Material_Reject_Form.Remove(form); } db.Material_Reject_Form.Add(pForm); } SaveProductMaping(db, pRej.Product_Code, pRej.Product_Name); pRej.Update_On = currentdate; pRej.Update_By = userlogin.Email_Address; db.Entry(current).CurrentValues.SetValues(pRej); db.SaveChanges(); } return(new ServiceResult() { Code = ReturnCode.SUCCESS, Msg = Success.GetMessage(ReturnCode.SUCCESS_UPDATE), Field = Resource.Material_Reject }); } } catch (Exception ex) { return(new ServiceResult() { Code = ReturnCode.ERROR_UPDATE, Msg = Error.GetMessage(ReturnCode.ERROR_UPDATE), Field = Resource.Material_Reject, Exception = ex }); } }