public bool AddNewPreInvoice(Tbl_PreInvoice invoice) { try { if (_context.Tbl_PreInvoice.Any(x => x.PreInvoice_ID == invoice.PreInvoice_ID)) { // user already exists Tbl_PreInvoice ToBeUpdatedUser = _context.Tbl_PreInvoice.First(x => x.PreInvoice_ID == invoice.PreInvoice_ID); ToBeUpdatedUser.Description = invoice.Description; ToBeUpdatedUser.IssueDate = invoice.IssueDate; ToBeUpdatedUser.PreInvoiceNumber = invoice.PreInvoiceNumber; ToBeUpdatedUser.PreInvoiceType_ID = invoice.PreInvoiceType_ID; if (invoice.PreInvoiceUpload != null) { ToBeUpdatedUser.PreInvoiceUpload = invoice.PreInvoiceUpload; } ToBeUpdatedUser.PreInvoice_ID = invoice.PreInvoice_ID; ToBeUpdatedUser.SendingStatus = invoice.SendingStatus; ToBeUpdatedUser.ConfirmationStatus = invoice.ConfirmationStatus; ToBeUpdatedUser.Customer_ID = invoice.Customer_ID; ToBeUpdatedUser.LastUpdateUser_ID = invoice.LastUpdateUser_ID; ToBeUpdatedUser.LastUpdateTime = invoice.LastUpdateTime; ToBeUpdatedUser.LastUpdateDate = invoice.LastUpdateDate; } else { if (_context.Tbl_PreInvoice.Any(x => x.PreInvoice_ID == invoice.PreInvoice_ID)) { return(false); } Tbl_PreInvoice ToBeInsertedUser = new Tbl_PreInvoice(); ToBeInsertedUser.Description = invoice.Description; ToBeInsertedUser.IssueDate = invoice.IssueDate; ToBeInsertedUser.PreInvoiceNumber = invoice.PreInvoiceNumber; ToBeInsertedUser.PreInvoiceType_ID = invoice.PreInvoiceType_ID; if (invoice.PreInvoiceUpload != null) { ToBeInsertedUser.PreInvoiceUpload = invoice.PreInvoiceUpload; } ToBeInsertedUser.PreInvoice_ID = invoice.PreInvoice_ID; ToBeInsertedUser.SendingStatus = invoice.SendingStatus; ToBeInsertedUser.ConfirmationStatus = invoice.ConfirmationStatus; ToBeInsertedUser.Customer_ID = invoice.Customer_ID; ToBeInsertedUser.LastUpdateUser_ID = invoice.LastUpdateUser_ID; ToBeInsertedUser.LastUpdateTime = invoice.LastUpdateTime; ToBeInsertedUser.LastUpdateDate = invoice.LastUpdateDate; _context.Tbl_PreInvoice.Add(ToBeInsertedUser); } if (_context.SaveChanges() > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
public ActionResult SubmitPreInvoice(DataSourceRequest command, PreInvoiceListModel model) { HttpSessionStateBase session = HttpContext.Session; try { Tbl_PreInvoice tu = new Tbl_PreInvoice(); tu.IssueDate = model.IssueDate; tu.PreInvoiceNumber = model.PreInvoiceNumber; tu.PreInvoiceType_ID = model.PreInvoiceType_ID; tu.Customer_ID = model.Customer_ID; if (model.File != null) { MemoryStream target = new MemoryStream(); model.File.InputStream.CopyTo(target); byte[] data = target.ToArray(); tu.PreInvoiceUpload = data; } tu.Description = model.Description; tu.PreInvoice_ID = model.PreInvoice_ID; if (model.Check_Sent && !model.Check_NotSent) { tu.SendingStatus = 1; } else if (!model.Check_Sent && model.Check_NotSent) { tu.SendingStatus = 2; } else { tu.SendingStatus = 0; } if (model.Check_Confirmed && !model.Check_NotConfirmed) { tu.ConfirmationStatus = 1; } else if (!model.Check_Confirmed && model.Check_NotConfirmed) { tu.ConfirmationStatus = 2; } else { tu.ConfirmationStatus = 0; } tu.LastUpdateUser_ID = Convert.ToInt32(session["UserID"]); tu.LastUpdateDate = DateTime.Now.ToString("yyyy-MM-dd"); tu.LastUpdateTime = DateTime.Now.ToString("HH:mm"); if (_accService.AddNewPreInvoice(tu)) { var gridModel = new DataSourceResult { ExtraData = new PreInvoiceModel { Message = Message.OperationSuccessful, MessageColor = "green" }, Total = 1 }; return(Json(gridModel)); } else { var gridModel = new DataSourceResult { ExtraData = new PreInvoiceModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } } catch (Exception ex) { var gridModel = new DataSourceResult { ExtraData = new PreInvoiceModel { Message = Message.OperationUnsuccessful, MessageColor = "red" }, Total = 1 }; return(Json(gridModel)); } //return ""; }