private void submit_Click(object sender, EventArgs e) { decimal amount; bool success = Decimal.TryParse(amount_pay.Text, out amount); if (success && amount > 0) { number.Text = ""; using (DataClasses1DataContext context = new DataClasses1DataContext()) { ACCOUNT user = context.ACCOUNTs.First(i => i.id == Home.UserID); user.balance -= amount; PAYMENT payment = new PAYMENT(); payment.amount = amount; payment.date = DateTime.Now; payment.account_id = user.id; context.PAYMENTs.InsertOnSubmit(payment); context.SubmitChanges(); } this.Close(); } }
public ActionResult DeleteConfirmed(Guid id) { PAYMENT paymentModelView = db.PAYMENTs.Find(id); db.PAYMENTs.Remove(paymentModelView); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult DeleteConfirmed(int id) { PAYMENT pAYMENT = db.PAYMENTs.Find(id); db.PAYMENTs.Remove(pAYMENT); db.SaveChanges(); return(RedirectToAction("Index")); }
public void CreatePayment(decimal tot, int methodP, int numTransaction) { PAYMENT p = new PAYMENT { amount = tot, momentPay = DateTime.Now, paymentMethodId = methodP, transactionId = numTransaction }; db.PAYMENTs.Add(p); db.SaveChanges(); }
public PaymentSearchView(PAYMENT payment) { this.PAYMENTID = payment.PAYMENTID; this.PAYMENTTYPENAME = payment.PAYMENTTYPE.NAME; this.FAMILYNAME = payment.FAMILY.LASTNAME; this.GYMYEAR = payment.GYMYEAR; this.PAYMENTDATE = payment.PAYMENTDATE; this.CHECKNUMBER = payment.CHECKNUMBER; this.AMOUNT = payment.AMOUNT; }
public ActionResult Edit([Bind(Include = "ID,ReceiptNo,Payment1,PaymentDate,JobID,Reference,PaymentType,CollectedBy,CreationDate,CreatedBy,LastModifiedBy,InvoiceID,PaymentTypeID,PaymentMethodId")] PAYMENT paymentModelView) { if (ModelState.IsValid) { db.Entry(paymentModelView).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(paymentModelView)); }
public ActionResult Create(PAYMENT pay) { // TODO: Add insert logic here if (ModelState.IsValid) { db.PAYMENTS.Add(pay); db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public ActionResult Edit([Bind(Include = "Payment_ID,PaymentAmount,PaymentDate,PaymentMonth,Student_ID")] PAYMENT pAYMENT) { if (ModelState.IsValid) { db.Entry(pAYMENT).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Student_ID = new SelectList(db.STUDENTs, "Student_ID", "StudentName", pAYMENT.Student_ID); return(View(pAYMENT)); }
public ActionResult Edit(PAYMENT pay) { if (ModelState.IsValid) { db.Entry(pay).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public ActionResult Create([Bind(Include = "ID,ReceiptNo,Payment1,PaymentDate,JobID,Reference,PaymentType,CollectedBy,CreationDate,CreatedBy,LastModifiedBy,InvoiceID,PaymentTypeID,PaymentMethodId")] PAYMENT paymentModelView) { if (ModelState.IsValid) { paymentModelView.ID = Guid.NewGuid(); db.PAYMENTs.Add(paymentModelView); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(paymentModelView)); }
public ActionResult FinishUpdateReport(PAYMENT _payment, int _id) { var report = db.PAYMENTs.Find(_id); report.DATE = _payment.DATE; report.ID_INOUT = _payment.ID_INOUT; report.PAYMENT_TYPE_ID = _payment.PAYMENT_TYPE_ID; report.MAIN_PAYMENT = _payment.MAIN_PAYMENT; report.VAT = _payment.VAT; report.ALL_PAYMENT = _payment.ALL_PAYMENT; report.RELEASE = _payment.RELEASE; report.REMNANT = 0; report.NOTE = _payment.NOTE; db.SaveChanges(); List <PAYMENT> allPayments = db.PAYMENTs.ToList(); for (int i = 0; i < allPayments.Count; i++) { if (allPayments[i].OBJECTID >= _id) { if (allPayments[i].ID_INOUT == 1) { allPayments[i].REMNANT = (allPayments[i - 1].REMNANT + allPayments[i].MAIN_PAYMENT); db.SaveChanges(); } if (allPayments[i].ID_INOUT == 2) { allPayments[i].REMNANT = (allPayments[i - 1].REMNANT - allPayments[i].MAIN_PAYMENT); db.SaveChanges(); } } } db.Configuration.ProxyCreationEnabled = false; List <CopyPayment> PaymentList = db.PAYMENTs.OrderByDescending(s => s.OBJECTID).Select(s => new CopyPayment { OBJECTID = s.OBJECTID, DATE = (DateTime)s.DATE, ID_INOUT = s.PAYMENT_INOUT.NAME, PAYMENT_TYPE_ID = s.PAYMENT_TYPE.NAME, MAIN_PAYMENT = (decimal)s.MAIN_PAYMENT, VAT = (decimal)s.VAT, ALL_PAYMENT = (decimal)s.ALL_PAYMENT, RELEASE = s.RELEASE, REMNANT = (decimal)s.REMNANT, NOTE = s.NOTE }).ToList(); return(Json(PaymentList, JsonRequestBehavior.AllowGet)); }
public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PAYMENT lst = db.PAYMENTS.Find(id); if (lst == null) { return(HttpNotFound()); } return(View(lst)); }
// GET: Default/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PAYMENT PAY = db.PAYMENTS.Find(id); if (PAY == null) { return(HttpNotFound()); } return(View(PAY)); }
// GET: Payments/Delete/5 public ActionResult Delete(Guid?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PAYMENT paymentModelView = db.PAYMENTs.Find(id); if (paymentModelView == null) { return(HttpNotFound()); } return(View(paymentModelView)); }
// Recurring entries not done yet // public static void _SA_RecallPayment_Other(PAYMENT_OTHER PaymentRecord) // recall recurring entry. other payment only // { // // recall and post a recurring entry // // if (Functions.GoodData(PaymentRecord.recurringName)) // { // Trace.WriteLine("Recalling the recurring entry " + PaymentRecord.recurringName + ""); // // if (!PaymentsJournal.repo.SelfInfo.Exists()) // { // PaymentsJournal._SA_Invoke(); // } // // PaymentsJournal.repo.Transaction.Select("Make Other Payment"); // // PaymentsJournal.repo.Self.PressKeys("{Ctrl+r}"); // invoke Recall Recurring dialog // RecallRecurringDialog._SA_SelectEntryToRecall(PaymentRecord.recurringName); // PaymentsJournal._SA_CreatePayment_Other(PaymentRecord); // } // else // log the error // { // Functions.Verify(false, true, "recurring name found"); // } // } public static void _SA_Open(PAYMENT Payment) // for common code amongst all the payment types { if (!PaymentsJournal.repo.SelfInfo.Exists()) { PaymentsJournal._SA_Invoke(); } if (Payment.GetType() == typeof(PAYMENT_REMIT)) { PaymentsJournal.repo.Transaction.Select("Pay Remittance"); } else if (Payment.GetType() == typeof(PAYMENT_PURCH)) { PaymentsJournal.repo.Transaction.Select("Pay Purchase Invoices"); } else if (Payment.GetType() == typeof(PAYMENT_OTHER)) { PaymentsJournal.repo.Transaction.Select("Make Other Payment"); } else if (Payment.GetType() == typeof(PAYMENT_CREDIT_CARD)) { Ranorex.Report.Info("Credit card payment can not be looked up"); return; } else { Ranorex.Report.Info("Invalid payment type"); return; } PaymentsJournal.repo.SearchDialog.Click(); DialogJournalSearch._SA_SelectLookupDateRange(); DialogJournalSearch.repo.Name.Select(Payment.Vendor.name); if (Functions.GoodData(Payment.chequeNumber)) // enter cheque number { DialogJournalSearch.repo.Source.TextValue = Payment.chequeNumber; } else if (Functions.GoodData(Payment.directDepositNo)) // enter source number { DialogJournalSearch.repo.Source.TextValue = Payment.directDepositNo; } else // enter source number { DialogJournalSearch.repo.Source.TextValue = Payment.source; } DialogJournalSearch.repo.OK.Click(); }
public void Delete(PAYMENT Entity) { _paymentDAO.Delete(Entity); if (Entity.Type == (int)PaymentType.CA) { _cashPaymentDAO.Delete(Entity.CASH_PAYMENT); } else if (Entity.Type == (int)PaymentType.PP) { _paypalPaymentDAO.Delete(Entity.PAYPAL_PAYMENT); } Context.SaveChanges(); }
// GET: PAYMENTs/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PAYMENT pAYMENT = db.PAYMENTs.Find(id); if (pAYMENT == null) { return(HttpNotFound()); } return(View(pAYMENT)); }
// GET: PAYMENTs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PAYMENT pAYMENT = db.PAYMENTs.Find(id); if (pAYMENT == null) { return(HttpNotFound()); } ViewBag.Student_ID = new SelectList(db.STUDENTs, "Student_ID", "StudentName", pAYMENT.Student_ID); return(View(pAYMENT)); }
public ActionResult Delete(string id, FormCollection collection) { try { // TODO: Add delete logic here PAYMENT pay = db.PAYMENTS.Find(id); db.PAYMENTS.Remove(pay); db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create([Bind(Include = "Payment_ID,PaymentAmount,PaymentDate,PaymentMonth")] PAYMENT pAYMENT) { if (ModelState.IsValid) { pAYMENT.Student_ID = Convert.ToInt32(Session["StudentId"]); db.PAYMENTs.Add(pAYMENT); db.SaveChanges(); //return RedirectToAction("Index"); } ViewBag.Student_ID = new SelectList(db.STUDENTs, "Student_ID", "StudentName", pAYMENT.Student_ID); ModelState.Clear(); ViewBag.Message = "successfully registered"; return(View()); // return View(pAYMENT); }
public void FormViewPayment_InsertItem() { String orderid = (String)Session["orderid"]; int orderidInt = Convert.ToInt32(Session["orderid"]); TextBox address = (TextBox)FormViewPayment.FindControl("txtboxAddress"); Session["address"] = address.Text; using (var _db1 = new GalleryEntities1()) { try { var myItem = (from c in _db1.ORDERs where c.OrderId == orderidInt select c).FirstOrDefault(); if (myItem != null) { myItem.status = "Paid"; _db1.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Update Order Status - " + exp.Message.ToString(), exp); } PAYMENT payment = new PAYMENT(); TryUpdateModel(payment); payment.Date = DateTime.Now; payment.OrderId = orderid; // Guid userId = (Guid)Membership.GetUser().ProviderUserKey; if (ModelState.IsValid) { GalleryEntities1 _db = new GalleryEntities1(); _db.PAYMENTs.Add(payment); _db.SaveChanges(); } Response.Redirect("~/PaymentSucess.aspx"); } }
public void Insert(PAYMENT Entity) { _paymentDAO.Insert(Entity); if (Entity.Type == (int)PaymentType.CA) { //Context.ObjectStateManager.ChangeObjectState(Entity.CASH_PAYMENT, System.Data.EntityState.Added); _cashPaymentDAO.Insert(Entity.CASH_PAYMENT); } else if (Entity.Type == (int)PaymentType.PP) { //Context.ObjectStateManager.ChangeObjectState(Entity.PAYPAL_PAYMENT, System.Data.EntityState.Added); _paypalPaymentDAO.Insert(Entity.PAYPAL_PAYMENT); } else if (Entity.Type == (int)PaymentType.EP) { //Context.ObjectStateManager.ChangeObjectState(Entity.PAYPAL_PAYMENT, System.Data.EntityState.Added); _easyPayPaymentDAO.Insert(Entity.EASYPAY_PAYMENT); } Context.SaveChanges(); }
private bool SetInvoiceNumberHelper(Payment payment) { try { PAYMENT entity = _da.GetSingleBy <PAYMENT>(p => p.Payment_Id == payment.Id); if (entity == null) { throw new Exception("NoItemFound"); } entity.Serial_Number = payment.SerialNumber; entity.Invoice_Number = payment.InvoiceNumber; return(_da.Update(entity)); } catch (Exception) { throw; } }
public dynamic GetAmount(PAYMENT Pay) { INF370Entities db = new INF370Entities(); db.Configuration.ProxyCreationEnabled = false; try { PAYMENT pay = new PAYMENT(); pay.PAYMENTDATETIME = DateTime.Today; pay.RENTALAGREEMENTID = Convert.ToInt32(db.RENTAL_AGREEMENT.Where(jj => jj.REFERENCE_NO == Pay.PAYMENT_REFERENCE_NO.ToString()).Select(ll => ll.RENTALAGREEMENTID).FirstOrDefault()); pay.PAYMENTTYPEID = Pay.PAYMENTTYPEID; pay.PAYMENT_AMOUNT = Pay.PAYMENT_AMOUNT; pay.PAYMENT_REFERENCE_NO = Pay.PAYMENT_REFERENCE_NO; db.PAYMENTs.Add(pay); db.SaveChanges(); RENTAL_AGREEMENT rent = db.RENTAL_AGREEMENT.Where(LL => LL.RENTALAGREEMENTID == pay.RENTALAGREEMENTID).FirstOrDefault(); if (rent.RENTALSTATUSID == 1) { rent.RENTALSTATUSID = 5; db.SaveChanges(); } else { rent.AMOUNTDUE = rent.AMOUNTDUE - Convert.ToInt32(Pay.PAYMENT_AMOUNT); db.SaveChanges(); } } catch (Exception) { return(null); } return(Ok()); }
public static void _SA_Delete(PAYMENT Payment) { // does one-step reversal by clicking on the reverse toolstrip button // the param has to be the type of PAYMENT, PAYMENT_OTHER, PAYMENT_CREDIT_CARD, or PAYMENT_REMIT string source; if (Functions.GoodData(Payment.chequeNumber)) { source = Payment.chequeNumber; } else { source = Payment.source; } Ranorex.Report.Info(String.Format("Deleting the payment record {0} ", source)); PaymentsJournal._SA_Open(Payment); // load the transaction for deletion PaymentsJournal.repo.Reverse.Click(); // handle the conformation message SimplyMessage._SA_HandleMessage(SimplyMessage.repo.Yes, SimplyMessage.sReversePaymentMsg, true); }
public static void _SA_printTransaction(string sFileName, PAYMENT PaymentRecord) { // payment paid by cheque only if (Functions.GoodData(PaymentRecord)) { if (PaymentRecord.GetType() != typeof(PAYMENT_CREDIT_CARD)) { PaymentsJournal._SA_Open(PaymentRecord); } Ranorex.Report.Info(String.Format("Printing payment {0} ", PaymentRecord.chequeNumber)); } PaymentsJournal.repo.Print.Click(); SimplyMessage._SA_HandleMessage(SimplyMessage.repo.Yes, SimplyMessage.sChqNumIsOutOfSequence); PrintToFileDialog.Print(sFileName); // Undo changes PaymentsJournal.ClickUndoChanges(); SimplyMessage._SA_HandleMessage(SimplyMessage.repo.Yes, SimplyMessage.sDiscardJournalMsg); }
public void Update(PAYMENT Entity) { Context.PAYMENT.Attach(Entity); Context.ObjectStateManager.ChangeObjectState(Entity, System.Data.EntityState.Modified); }
public void Delete(PAYMENT Entity) { Context.PAYMENT.Attach(Entity); Context.DeleteObject(Entity); }
protected object GetObjectById(int _id, bool _master, string _slaveType, string _masterType) { switch (typeof(T).Name) { case "FAMILY": FAMILY family = null; if (_id == 0) { family = egoEntities.FAMILY.FirstOrDefault(); } else { family = egoEntities.FAMILY.FirstOrDefault(x => x.FAMILYID == _id); } return(family == null ? new FAMILY() : family); case "PERSON": PERSON person = null; if (_master) { person = _id == 0 ? egoEntities.PERSON.FirstOrDefault() : egoEntities.PERSON.FirstOrDefault(x => x.PERSONID == _id); } else { if (_masterType == "GYMGROUP") { PERSON_GYMGROUP person_gymGroup = new PERSON_GYMGROUP(); person_gymGroup = _id == 0 ? egoEntities.PERSON_GYMGROUP.FirstOrDefault() : egoEntities.PERSON_GYMGROUP.FirstOrDefault(x => x.PERSON_GYMGROUP_ID == _id); return(person_gymGroup == null ? new PERSON_GYMGROUP() : person_gymGroup); } else if (_masterType == "FAMILY") { person = _id == 0 ? egoEntities.PERSON.FirstOrDefault() : egoEntities.PERSON.FirstOrDefault(x => x.PERSONID == _id); } } return(person == null ? new PERSON() : person); case "PHONE": PHONE Phone = null; Phone = _id == 0 ? egoEntities.PHONE.FirstOrDefault() : egoEntities.PHONE.FirstOrDefault(x => x.PHONEID == _id); return(Phone == null ? new PHONE() : Phone); case "DISCOUNT": DISCOUNT Discount = null; Discount = _id == 0 ? egoEntities.DISCOUNT.FirstOrDefault() : egoEntities.DISCOUNT.FirstOrDefault(x => x.DISCOUNTID == _id); return(Discount == null ? new DISCOUNT() : Discount); case "PAYMENT": PAYMENT Payment = null; Payment = _id == 0 ? egoEntities.PAYMENT.FirstOrDefault() : egoEntities.PAYMENT.FirstOrDefault(x => x.PAYMENTID == _id); return(Payment == null ? new PAYMENT() : Payment); case "DOCUMENT": DOCUMENT Document = null; Document = _id == 0 ? egoEntities.DOCUMENT.FirstOrDefault() : egoEntities.DOCUMENT.FirstOrDefault(x => x.DOCUMENTID == _id); return(Document == null ? new DOCUMENT() : Document); case "GYMGROUP": if (_master) { GYMGROUP GymGroup = null; GymGroup = _id == 0 ? egoEntities.GYMGROUP.FirstOrDefault() : egoEntities.GYMGROUP.FirstOrDefault(x => x.GYMGROUPID == _id); return(GymGroup == null ? new GYMGROUP() : GymGroup); } else { PERSON_GYMGROUP Person_GymGroup = new PERSON_GYMGROUP(); Person_GymGroup = _id == 0 ? egoEntities.PERSON_GYMGROUP.FirstOrDefault() : egoEntities.PERSON_GYMGROUP.First(x => x.PERSON_GYMGROUP_ID == _id); return(Person_GymGroup == null ? new PERSON_GYMGROUP() : Person_GymGroup); } } return(null); }
public List <PAYMENT> Search(PAYMENT Entity, int PageSize, int PageIndex, out int TotalRecords, string OrderExp, Util.SortDirection SortDirection) { throw new NotImplementedException(); }