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