public string GetDailInf(int rfpId, int obj) { //DataTable dt = Mydb.ExecuteReadertoDataTable("select dt.ACCURED_SUMM,dt.PAYED,dt.PAY_GUID,rs.SERVICE_NAME from DETAIL_INF dt inner join RFP_SERVICES rs on rs.RFP_SERVICE_ID=dt.RFP_SERVICE_ID and dt.RECIEPT_FOR_PAYMENT_ID=@rfpId", new SqlParameter[] { new SqlParameter("@rfpId", rfpId) }, CommandType.Text); DataTable dt = Mydb.ExecuteReadertoDataTable("GetDailInf", new SqlParameter[] { new SqlParameter("@rfpId", rfpId) }, CommandType.StoredProcedure); List <Payment_Details> pds = new List <Payment_Details>(); Payment_Details p_d = new Payment_Details(); p_d.PAYMENT_SUM = Mydb.ExecuteScalar("TestDB.dbo.sp_QUICK_API_get_shopId", new SqlParameter[] { new SqlParameter("@tokenid", ""), new SqlParameter("@login", ""), new SqlParameter("@obj", obj) }, CommandType.StoredProcedure).ToString(); pds.Add(p_d); foreach (DataRow item in dt.Rows) { Payment_Details pd = new Payment_Details(); pd.ACCURED_SUMM = item["ACCURED_SUMM"].ToString(); pd.SERVICE_NAME = item["SERVICE_NAME"].ToString(); pd.PAYMENT_SUM = item["PAYED"].ToString(); pd.PAY_GUID = item["PAY_GUID"].ToString(); pd.VOLUME = item["VOLUME"].ToString(); pd.EDIZM = item["EDIZM"].ToString(); pd.TARIF = item["TARIF"].ToString(); pd.PRIVILEGES = item["PRIVILEGES"].ToString(); pd.RECALCULATIONS = item["RECALCULATIONS"].ToString(); pds.Add(pd); } return(JsonConvert.SerializeObject(pds)); }
public async Task <IActionResult> Payment_Details(string prod_id) { var prod_info = await _context.Bill_Information.FindAsync(prod_id); Payment_Details pd = new Payment_Details { prod_id = prod_id, desc = "JPS BILL", prod_amount = prod_info.amount }; return(View(pd)); }
public ActionResult Pay(Payment_Details model) { using (var context = new RailwayReservationSystemEntities1()) { if (context.Payment_Details.Any(x => x.Card_No == model.Card_No && x.CVV == model.CVV && x.Expiry_Date == model.Expiry_Date)) { return(RedirectToAction("RedirectFromPayment", "Payment")); } else { ModelState.AddModelError("", "Enter Correct Details"); return(View()); } } }
public bool Post(int uid, [FromBody] Payment_Details pd) { try { pd.User_Id = uid; db.Payment_Details.Add(pd); var res = db.SaveChanges(); if (res > 0) { return(true); } } catch (Exception ex) { throw ex; } return(false); }
public string GetDailInf2(string sc, string period) { DataTable dt = Mydb.ExecuteReadertoDataTable("TestDB.dbo.sp_Get_EPD_Details", new SqlParameter[] { new SqlParameter("@LS", sc), new SqlParameter("@MNTH", period) }, CommandType.StoredProcedure); List <Payment_Details> pds = new List <Payment_Details>(); Payment_Details p_d = new Payment_Details(); //p_d.PAYMENT_SUM = Mydb.ExecuteScalar("select SHOP_ID from MAN_COMPANY where MAN_COMPANY_ID=(select MAN_COMP_ID from OBJECT where OBJECT_ID=358)", new SqlParameter[] { new SqlParameter("@obj", obj) }, CommandType.Text).ToString(); //pds.Add(p_d); foreach (DataRow item in dt.Rows) { Payment_Details pd = new Payment_Details(); pd.ACCURED_SUMM = item["ITOGO"].ToString(); pd.SERVICE_NAME = item["SERVICES"].ToString(); //pd.PAYMENT_SUM = item["PAYED"].ToString(); //pd.PAY_GUID = item["PAY_GUID"].ToString(); pds.Add(pd); } return(JsonConvert.SerializeObject(pds)); }
public ActionResult ValidationForPayment([Bind(Include = "cardtype,name,creditcardnumber,expirymonth,expiry_year")] Payment_Details paymentdetails) { Session["errormessage"] = null; if (ModelState.IsValid) { String cardtype = paymentdetails.cardtype.ToString(); String name = paymentdetails.name; String number = paymentdetails.creditcardnumber.ToString(); int expmonth = paymentdetails.expirymonth; int expyear = paymentdetails.expiry_year; if (cardtype.Equals("visa")) { int length = number.Length; if (length != 16) { Session["errormessage"] = "Visa Card Number should have 16 digits!"; return(View("Payment_Page")); } if (number[0] != '4') { Session["errormessage"] = "Visa Card Number should start by 4"; return(View("Payment_Page")); } if (expmonth < 1) { Session["errormessage"] = "Sorry, Expiry month is out of range!"; String error = Session["errormessage"].ToString(); return(View("Payment_Page")); } if (expmonth > 12) { Session["errormessage"] = "Sorry, Expiry month is out of range!"; String error = Session["errormessage"].ToString(); return(View("Payment_Page")); } if (expyear < 2016) { Session["errormessage"] = "Sorry, Expiry Year is out of range!"; return(View("Payment_Page")); } if (expyear > 2031) { Session["errormessage"] = "Sorry, Expiry Year is out of range!"; return(View("Payment_Page")); } } if (cardtype.Equals("mastercard")) { int length = number.Length; if (length != 16) { Session["errormessage"] = "MasterCard Number should have 16 digits!"; return(View("Payment_Page")); } if (number[0] != '5') { Session["errormessage"] = "Master Card Number should start by 51-55!"; return(View("Payment_Page")); } char secchar = number[1]; int secondnumber = (int)Char.GetNumericValue(secchar); if (secondnumber > 6) { Session["errormessage"] = "Master Card Number should start by 51-55!"; return(View("Payment_Page")); } if (expmonth < 1) { Session["errormessage"] = "Sorry, Expiry month is out of range!"; return(View("Payment_Page")); } if (expmonth > 12) { Session["errormessage"] = "Sorry, Expiry month is out of range!"; return(View("Payment_Page")); } if (expyear < 2016) { Session["errormessage"] = "Sorry, Expiry year is out of range!"; return(View("Payment_Page")); } if (expyear > 2031) { Session["errormessage"] = "Sorry, Expiry year is out of range!"; return(View("Payment_Page")); } } if (cardtype.Equals("americanexpress")) { int length = number.Length; if (length != 15) { Session["errormessage"] = "American Card Number should have 15 digits!"; return(View("Payment_Page")); } if (number[0] != '3') { Session["errormessage"] = "American Card Number should start by 34 or 37!"; return(View("Payment_Page")); } else if (number[1] != '4' && number[1] != '7') { Session["errormessage"] = "American Card Number should start by 34 or 37!"; return(View("Payment_Page")); } char secchar = number[1]; int secondnumber = (int)Char.GetNumericValue(secchar); if (secondnumber < 4 || secondnumber > 7) { Session["errormessage"] = "Amrican Card Number should start by 34-37!"; return(View("Payment_Page")); } if (expmonth < 1) { Session["errormessage"] = "Sorry, Expiry month is out of range!"; return(View("Payment_Page")); } if (expmonth > 12) { Session["errormessage"] = "Sorry, Expiry month is out of range!"; return(View("Payment_Page")); } if (expyear < 2016) { Session["errormessage"] = "Sorry, Expiry year is out of range!"; return(View("Payment_Page")); } if (expyear > 2031) { Session["errormessage"] = "Sorry, Expiry year is out of range!"; return(View("Payment_Page")); } } Console.WriteLine(cardtype); Console.WriteLine(name); Console.WriteLine(number); List <int> passids = new List <int>(); if (Session["errormessage"] == null) { List <Passenger_Details> passengerlist = (List <TrainReserveSystem.Models.Passenger_Details>)Session["passengerlist"]; foreach (var passenger in passengerlist) { db.Passenger_Details.Add(passenger); db.SaveChanges(); passids.Add(passenger.ID); } var rawQuery = db.Database.SqlQuery <int>("SELECT COUNT(*) VALUE FROM Booking;"); var task = rawQuery.SingleAsync(); int bookingid = (int)task.Result + 1; int passengercount = (int)Session["passengercount"]; int fare = (int)Session["trainfare"]; int totalfare = passengercount * fare; int trainid = (int)Session["id"]; Booking booking = new Booking(); booking.Booking_ID = bookingid; booking.Total_Fare = totalfare; booking.FK_Train_Detail_ID = trainid; db.Bookings.Add(booking); db.SaveChanges(); Session["bookingid"] = bookingid; foreach (var id in passids) { var rawQuery2 = db.Database.SqlQuery <int>("SELECT COUNT(*) VALUE FROM Passenger_Booking;"); var task2 = rawQuery2.SingleAsync(); int passengerbookingid = (int)task2.Result + 1; Passenger_Booking pb = new Passenger_Booking(); pb.PB_ID = passengerbookingid; pb.FK_Booking_ID = bookingid; pb.FK_ID = id; db.Passenger_Booking.Add(pb); db.SaveChanges(); } return(View("PaymentConfirmation")); } } return(View("Payment_Page")); }