private void toolbar_btnEdit_Click(object sender) { payment_promissory_note payment_promissory_note = (payment_promissory_note)payment_promissory_noteViewSource.View.CurrentItem; if (payment_promissory_note != null) { payment_promissory_note.State = System.Data.Entity.EntityState.Modified; } payment_promissory_noteViewSource.View.Refresh(); }
private void set_ContactPref(object sender, EventArgs e) { if (sbxContact.ContactID > 0) { contact contact = PromissoryNoteDB.contacts.Where(x => x.id_contact == sbxContact.ContactID).FirstOrDefault(); payment_promissory_note payment_promissory_note = (payment_promissory_note)payment_promissory_noteViewSource.View.CurrentItem; payment_promissory_note.id_contact = contact.id_contact; payment_promissory_note.contact = contact; } }
private void toolbar_btnSave_Click(object sender) { PromissoryNoteDB.SaveChanges(); payment_promissory_note payment_promissory_note = (payment_promissory_note)payment_promissory_noteViewSource.View.CurrentItem; if (payment_promissory_note != null) { payment_promissory_note.State = System.Data.Entity.EntityState.Unchanged; } payment_promissory_noteViewSource.View.Refresh(); }
private void toolBar_btnSearch_Click(object sender, string query) { if (!string.IsNullOrEmpty(query) && payment_promissory_noteViewSource != null) { try { payment_promissory_noteViewSource.View.Filter = i => { payment_promissory_note payment_promissory_note = i as payment_promissory_note; if (payment_promissory_note != null) { if ((payment_promissory_note.contact != null ? payment_promissory_note.contact.name.ToLower().Contains(query.ToLower()) : false) || payment_promissory_note.note_number.Contains(query)) { return(true); } else { return(false); } } else { return(false); } }; } catch (Exception ex) { throw ex; } } else { payment_promissory_noteViewSource.View.Filter = null; } }
public List <payment_schedual> insert_Schedual(object obj_entity) { List <payment_schedual> payment_schedualList = new List <payment_schedual>(); //SALES INVOICE if (obj_entity as sales_invoice != null) { sales_invoice sales_invoice = (sales_invoice)obj_entity; foreach (app_contract_detail app_contract_detail in sales_invoice.app_contract.app_contract_detail.Where(x => x.is_order == false)) { payment_schedual payment_schedual = new payment_schedual(); payment_schedual.credit = 0; payment_schedual.debit = sales_invoice.GrandTotal * app_contract_detail.coefficient; payment_schedual.id_currencyfx = sales_invoice.id_currencyfx; payment_schedual.sales_invoice = sales_invoice; payment_schedual.trans_date = sales_invoice.trans_date; payment_schedual.expire_date = sales_invoice.trans_date.AddDays(app_contract_detail.interval); payment_schedual.status = entity.Status.Documents_General.Approved; payment_schedual.id_contact = sales_invoice.id_contact; payment_schedualList.Add(payment_schedual); ///Checks if selected Contract has Promissory Note created. if (sales_invoice.app_contract.is_promissory) { payment_promissory_note payment_promissory_note = new payment_promissory_note(); //Dates. Transactional (based on Sales Trans) and Expiry (based on Exp of Payment)... payment_promissory_note.trans_date = sales_invoice.trans_date; payment_promissory_note.expiry_date = sales_invoice.trans_date.AddDays(app_contract_detail.interval); //Navigational Properties... payment_promissory_note.id_branch = sales_invoice.id_branch; payment_promissory_note.id_terminal = sales_invoice.id_terminal; payment_promissory_note.id_company = sales_invoice.id_company; payment_promissory_note.id_contact = sales_invoice.id_contact; //Values... payment_promissory_note.value = sales_invoice.GrandTotal * app_contract_detail.coefficient; payment_promissory_note.id_currencyfx = sales_invoice.id_currencyfx; payment_promissory_note.status = entity.Status.Documents.Pending; //Create Payment to control the Promissory Note as Non-Calculated. payment_schedual payment_schedual_promise = new payment_schedual(); //Debit Credit payment_schedual_promise.credit = 0; payment_schedual_promise.debit = sales_invoice.GrandTotal * app_contract_detail.coefficient; //Nav Properties payment_schedual_promise.id_contact = sales_invoice.id_contact; payment_schedual_promise.id_currencyfx = sales_invoice.id_currencyfx; payment_schedual_promise.sales_invoice = sales_invoice; //Date payment_schedual_promise.trans_date = sales_invoice.trans_date; payment_schedual_promise.expire_date = sales_invoice.trans_date.AddDays(app_contract_detail.interval); payment_schedual_promise.can_calculate = false; //Pending so that we can Approve while Printing. payment_schedual_promise.status = entity.Status.Documents_General.Pending; //Adding Payment Schedual into PromissoryNote payment_promissory_note.payment_schedual.Add(payment_schedual_promise); payment_promissory_noteLIST.Add(payment_promissory_note); } } return(payment_schedualList); } //SALES RETURN else if (obj_entity as sales_return != null) { sales_return sales_return = (sales_return)obj_entity; payment_schedual payment_schedual = new payment_schedual(); payment_schedual.debit = sales_return.GrandTotal; payment_schedual.credit = 0; payment_schedual.id_currencyfx = sales_return.id_currencyfx; payment_schedual.sales_return = sales_return; payment_schedual.trans_date = sales_return.trans_date; payment_schedual.expire_date = sales_return.trans_date; payment_schedual.status = entity.Status.Documents_General.Approved; payment_schedual.id_contact = sales_return.id_contact; payment_schedual.can_calculate = false; payment_schedualList.Add(payment_schedual); return(payment_schedualList); } //PURCHASE RETURN else if (obj_entity as purchase_return != null) { purchase_return purchase_return = (purchase_return)obj_entity; payment_schedual payment_schedual = new payment_schedual(); payment_schedual.credit = purchase_return.GrandTotal; payment_schedual.debit = 0; payment_schedual.id_currencyfx = purchase_return.id_currencyfx; payment_schedual.purchase_return = purchase_return; payment_schedual.trans_date = purchase_return.trans_date; payment_schedual.expire_date = purchase_return.trans_date; payment_schedual.status = entity.Status.Documents_General.Approved; payment_schedual.id_contact = purchase_return.id_contact; payment_schedual.can_calculate = false; payment_schedualList.Add(payment_schedual); return(payment_schedualList); } //SALES ORDER else if (obj_entity as sales_order != null) { sales_order sales_order = (sales_order)obj_entity; foreach (app_contract_detail app_contract_detail in sales_order.app_contract.app_contract_detail.Where(x => x.is_order)) { payment_schedual payment_schedual = new payment_schedual(); payment_schedual.credit = 0; payment_schedual.debit = sales_order.GrandTotal * app_contract_detail.coefficient; payment_schedual.id_currencyfx = sales_order.id_currencyfx; payment_schedual.sales_order = sales_order; payment_schedual.trans_date = sales_order.trans_date; payment_schedual.expire_date = sales_order.trans_date.AddDays(app_contract_detail.interval); payment_schedual.status = entity.Status.Documents_General.Approved; payment_schedual.id_contact = sales_order.id_contact; payment_schedualList.Add(payment_schedual); } return(payment_schedualList); } //PURCHASE INVOICE else if (obj_entity as purchase_invoice != null) { purchase_invoice purchase_invoice = (purchase_invoice)obj_entity; foreach (app_contract_detail app_contract_detail in purchase_invoice.app_contract.app_contract_detail.Where(x => x.is_order == false)) { payment_schedual payment_schedual = new payment_schedual(); payment_schedual.credit = purchase_invoice.GrandTotal * app_contract_detail.coefficient; payment_schedual.debit = 0; payment_schedual.id_currencyfx = purchase_invoice.id_currencyfx; payment_schedual.purchase_invoice = purchase_invoice; payment_schedual.trans_date = purchase_invoice.trans_date; payment_schedual.expire_date = purchase_invoice.trans_date.AddDays(app_contract_detail.interval); payment_schedual.status = entity.Status.Documents_General.Pending; payment_schedual.id_contact = purchase_invoice.id_contact; payment_schedualList.Add(payment_schedual); } return(payment_schedualList); } //PURCHASE ORDER else if (obj_entity as purchase_order != null) { purchase_order purchase_order = (purchase_order)obj_entity; foreach (app_contract_detail app_contract_detail in purchase_order.app_contract.app_contract_detail.Where(x => x.is_order)) { payment_schedual payment_schedual = new payment_schedual(); payment_schedual.credit = purchase_order.GrandTotal * app_contract_detail.coefficient; payment_schedual.debit = 0; payment_schedual.id_currencyfx = purchase_order.id_currencyfx; payment_schedual.purchase_order = purchase_order; payment_schedual.trans_date = purchase_order.trans_date; payment_schedual.expire_date = purchase_order.trans_date.AddDays(app_contract_detail.interval); payment_schedual.status = entity.Status.Documents_General.Pending; payment_schedual.id_contact = purchase_order.id_contact; payment_schedualList.Add(payment_schedual); } return(payment_schedualList); } return(null); }