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 "";
}
