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();
}
