public ActionResult Edit([Bind(Include = "ID,InvoiceID,Notes,OriginalExpectedPaymentDate,RevisedExpectedPaymentDate,CreatedDate,EmployeeId")] InvoiceNote invoiceNote)
{
if (ModelState.IsValid)
{
Invoice invoice = db.Invoices.Find(invoiceNote.InvoiceID);
db.Entry(invoiceNote).State = EntityState.Modified;
db.SaveChanges();
// Update invoice as well .
invoice.ExpectedPaymentDate = invoiceNote.RevisedExpectedPaymentDate;
if (invoice.Status == InvoiceStatus.Open)
{
invoice.DaysOverdue = ((int)(invoice.ExpectedPaymentDate - invoice.DueDate).Days);
}
else
{
invoice.DaysOverdue = 0;
}
db.Entry(invoice).State = EntityState.Modified;
db.SaveChanges();
return(Redirect(base.SessionGetReturnURL()));
}
ViewBag.InvoiceID = new SelectList(db.Invoices, "ID", "InvoiceNumber", invoiceNote.InvoiceID);
return(View(invoiceNote));
}
/// <summary>
/// Retrieves list of InvoiceNote objects from SqlCommand, after database query
/// number of rows retrieved and returned depends upon the rows field value
/// </summary>
/// <param name="cmd">The command object to use for query</param>
/// <param name="rows">Number of rows to process</param>
/// <returns>A list of InvoiceNote objects</returns>
private InvoiceNoteList GetList(SqlCommand cmd, long rows)
{
// Select multiple records
SqlDataReader reader;
long result = SelectRecords(cmd, out reader);
//InvoiceNote list
InvoiceNoteList list = new InvoiceNoteList();
using ( reader )
{
// Read rows until end of result or number of rows specified is reached
while (reader.Read() && rows-- != 0)
{
InvoiceNote invoiceNoteObject = new InvoiceNote();
FillObject(invoiceNoteObject, reader);
list.Add(invoiceNoteObject);
}
// Close the reader in order to receive output parameters
// Output parameters are not available until reader is closed.
reader.Close();
}
return(list);
}
/// <summary>
/// populates a InvoiceNote with its child entities
/// </summary>
/// <param name="invoiceNote"></param>
/// <param name="fillChilds"></param>
private void FillInvoiceNoteWithChilds(InvoiceNote invoiceNoteObject, bool fillChilds)
{
// populate child data for a invoiceNoteObject
if (invoiceNoteObject != null)
{
}
}
public async Task <ServiceActionResult <InvoiceNote> > Update(InvoiceNote item)
{
var existingInvoiceNote = await _dataContext.InvoiceNotes.SingleOrDefaultAsync(i => i.Id == item.Id);
if (existingInvoiceNote == null)
{
return new ServiceActionResult <InvoiceNote> {
Entity = item, Code = ServiceActionResultCode.InvoiceNoteNotFound
}
}
;
if (_authenticatedPrincipal.UserId != existingInvoiceNote.CreatedByUserId)
{
return new ServiceActionResult <InvoiceNote> {
Entity = item, Code = ServiceActionResultCode.OnlyOwnersAllowed
}
}
;
existingInvoiceNote.CopyFrom(item);
await _dataContext.SaveChangesAsync();
return(new ServiceActionResult <InvoiceNote> {
Entity = existingInvoiceNote, Code = ServiceActionResultCode.Success
});
}
}
}
/// <summary>
/// Update InvoiceNote Object.
/// Data manipulation processing for: new, deleted, updated InvoiceNote
/// </summary>
/// <param name="invoiceNoteObject"></param>
/// <returns></returns>
public bool Update(InvoiceNote invoiceNoteObject)
{
bool success = false;
success = UpdateBase(invoiceNoteObject);
return(success);
}
public async Task <ServiceActionResult <InvoiceNote> > Create(InvoiceNote item)
{
_dataContext.InvoiceNotes.Add(item);
await _dataContext.SaveChangesAsync();
return(new ServiceActionResult <InvoiceNote> {
Entity = item, Code = ServiceActionResultCode.Success
});
}
public void PrintInvoce(int idFatura)
{
InvoiceController invC = new InvoiceController();
Invoice invoice = invC.getOne(idFatura);
if (invoice.TipoDocumentoId == "10") // Nota de Credito
{
InvoiceNote rep = new InvoiceNote();
rep.initData(invoice);
documentViewer1.DocumentSource = rep;
rep.CreateDocument();
if (!invoice.OriginalFeita)
{
invoice.OriginalFeita = true;
invC.update(invoice);
}
}
else if (invoice.TipoDocumento.Tipo == "RC")
{
ReciboReport rep = new ReciboReport();
Recibo recibo = new ReciboController().getForDocumentId(invoice.Id);
rep.initData(recibo);
documentViewer1.DocumentSource = rep;
rep.CreateDocument();
if (!invoice.OriginalFeita)
{
invoice.OriginalFeita = true;
invC.update(invoice);
}
}
else
{
InvoiceReport rep = new InvoiceReport();
rep.initDate(invoice);
rep.CreateDocument();
if (!invoice.OriginalFeita)
{
invoice.OriginalFeita = true;
invC.update(invoice);
}
InvoiceReport rep2 = new InvoiceReport();
rep2.initDate(invoice);
rep2.CreateDocument();
rep.ModifyDocument(x => { x.AddPages(rep2.Pages); });
/*foreach (DevExpress.XtraReports.Parameters.Parameter item in rep.Parameters)
* {
* item.Visible = false;
* }*/
documentViewer1.DocumentSource = rep;
}
}
public ActionResult DeleteConfirmed(int id)
{
InvoiceNote invoiceNote = db.InvoiceNotes.Find(id);
db.InvoiceNotes.Remove(invoiceNote);
db.SaveChanges();
return(Redirect(base.SessionGetReturnURL()));
}
public static InvoiceNoteDto ToInvoiceNoteDto(this InvoiceNote invoiceNote)
{
return(invoiceNote == null
? null
: new InvoiceNoteDto()
{
Id = invoiceNote.Id,
InvoiceId = invoiceNote.InvoiceId,
Text = invoiceNote.Text
});
}
// GET: InvoiceNote/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
base.SessionHandleOtherActions();
InvoiceNote invoiceNote = db.InvoiceNotes.Find(id);
if (invoiceNote == null)
{
return(HttpNotFound());
}
return(View(invoiceNote));
}
private List <InvoiceNote> ExtractNotes(List <Segment> nte)
{
var notes = new List <InvoiceNote>();
foreach (var seg in nte)
{
var note = new InvoiceNote()
{
NTE01_NoteReferenceCode = seg.GetElement(1),
NTE02_NoteDescription = seg.GetElement(2)
};
notes.Add(note);
}
return(notes);
}
/// <summary>
/// Update base of InvoiceNote Object.
/// Data manipulation processing for: new, deleted, updated InvoiceNote
/// </summary>
/// <param name="invoiceNoteObject"></param>
/// <returns></returns>
public bool UpdateBase(InvoiceNote invoiceNoteObject)
{
// use of switch for different types of DML
switch (invoiceNoteObject.RowState)
{
// insert new rows
case BaseBusinessEntity.RowStateEnum.NewRow:
return(Insert(invoiceNoteObject));
// delete rows
case BaseBusinessEntity.RowStateEnum.DeletedRow:
return(Delete(invoiceNoteObject.Id));
}
// update rows
using (InvoiceNoteDataAccess data = new InvoiceNoteDataAccess(ClientContext))
{
return(data.Update(invoiceNoteObject) > 0);
}
}
/// <summary>
/// Insert new invoiceNote.
/// data manipulation for insertion of InvoiceNote
/// </summary>
/// <param name="invoiceNoteObject"></param>
/// <returns></returns>
private bool Insert(InvoiceNote invoiceNoteObject)
{
// new invoiceNote
using (InvoiceNoteDataAccess data = new InvoiceNoteDataAccess(ClientContext))
{
// insert to invoiceNoteObject
Int32 _Id = data.Insert(invoiceNoteObject);
// if successful, process
if (_Id > 0)
{
invoiceNoteObject.Id = _Id;
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Retrieves InvoiceNote object from SqlCommand, after database query
/// </summary>
/// <param name="cmd">The command object to use for query</param>
/// <returns>InvoiceNote object</returns>
private InvoiceNote GetObject(SqlCommand cmd)
{
SqlDataReader reader;
long rows = SelectRecords(cmd, out reader);
using (reader)
{
if (reader.Read())
{
InvoiceNote invoiceNoteObject = new InvoiceNote();
FillObject(invoiceNoteObject, reader);
return(invoiceNoteObject);
}
else
{
return(null);
}
}
}
public void PrintInvoce(int idFatura, FrmCreditOrDebitNote frmCreditNote)
{
_frmCreditNote = frmCreditNote;
// Nota de credito
InvoiceController invC = new InvoiceController();
Invoice invoice = invC.getOne(idFatura);
InvoiceNote rep = new InvoiceNote();
rep.initData(invoice);
documentViewer1.DocumentSource = rep;
rep.CreateDocument();
if (!invoice.OriginalFeita)
{
invoice.OriginalFeita = true;
invC.update(invoice);
}
}
public ActionResult Create([Bind(Include = "ID,InvoiceID,Notes,OriginalExpectedPaymentDate,RevisedExpectedPaymentDate")] InvoiceNote invoiceNote)
{
if (ModelState.IsValid)
{
Invoice invoice = db.Invoices.Find(invoiceNote.InvoiceID);
HttpSessionStateBase session = HttpContext.Session;
Employee employee = (Employee)session["employee"];
invoiceNote.CreatedDate = DateTime.Now;
invoiceNote.Employee = employee;
db.InvoiceNotes.Add(invoiceNote);
db.SaveChanges();
// Update invoice as well .
invoice.ExpectedPaymentDate = invoiceNote.RevisedExpectedPaymentDate;
if (invoice.Status == InvoiceStatus.Open)
{
invoice.DaysOverdue = ((int)(invoice.ExpectedPaymentDate - invoice.DueDate).Days);
}
else
{
invoice.DaysOverdue = 0;
}
db.Entry(invoice).State = EntityState.Modified;
db.SaveChanges();
return(Redirect(base.SessionGetReturnURL()));
}
ViewBag.InvoiceID = new SelectList(db.Invoices, "ID", "InvoiceNumber", invoiceNote.InvoiceID);
return(View(invoiceNote));
}
/// <summary>
/// Fill External Childs of InvoiceNote Object.
/// </summary>
/// <param name="invoiceNoteObject"></param>
/// <returns></returns>
public void FillChilds(InvoiceNote invoiceNoteObject)
{
///Fill external information of Childs of InvoiceNoteObject
}
public static InvoiceNote ToInvoiceNote(this InvoiceNoteDto invoiceNoteDto, InvoiceNote invoiceNote)
{
invoiceNote.Text = invoiceNoteDto.Text;
return(invoiceNote);
}
public async Task <ActionResult <ServiceActionResult <InvoiceNote> > > Update([FromBody] InvoiceNote invoiceNote)
{
var result = await _invoiceNoteService.Update(invoiceNote);
return(Ok(result));
}
public ActionResult saveInvoiceNote(InvoiceNote modelinvoiceNote)
{
int i = _invoiceNote.AddInvoiceNoteRecord(Mapper.Map <LMGEDI.Core.Data.Model.InvoiceNote>(modelinvoiceNote));
return(Json(i));
}
