protected void parseTransaction()
{
transitem = new Transaction_Item();
// string content = "";
PropertyInfo[] props = transitem.GetType().GetProperties();
foreach (PropertyInfo prop in props)
{
try
{
prop.SetValue(transitem, Convert.ChangeType(context.Request[prop.Name], prop.PropertyType), null);
// content += String.Format("Name:{0} =>Value:{1} ******", prop.Name, prop.GetValue(transitem, null));
}
catch (Exception e)
{
}
}
/*
* System.IO.StreamWriter file = new System.IO.StreamWriter(Server.MapPath("/logwritex.txt"));
* file.Write(content);
* file.Close();
*/
}
public static bool addPaymentHistory(Transaction_Item item, InquiryInfo inquiry)
{
try
{
using (SqlConnection con = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("dbo.uspAddBookHistory", con)) //payment history completed
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@item_number", SqlDbType.Int).Value = item.item_number;
cmd.Parameters.Add("@mc_gross", SqlDbType.Decimal).Value = item.mc_gross;
cmd.Parameters.Add("@mc_fee", SqlDbType.Decimal).Value = item.mc_fee;
cmd.Parameters.Add("@txn_id", SqlDbType.NVarChar, 1000).Value = item.txn_id;
cmd.Parameters.Add("@payment_date", SqlDbType.DateTime).Value = item.payment_date;
cmd.Parameters.Add("@business", SqlDbType.NVarChar, 1000).Value = item.business;
cmd.Parameters.Add("@payer_email", SqlDbType.NVarChar, 300).Value = item.payer_email;
cmd.Parameters.Add("@payer_id", SqlDbType.NVarChar, 200).Value = item.payer_id;
cmd.Parameters.Add("@mc_currency", SqlDbType.NVarChar, 10).Value = item.mc_currency;
cmd.Parameters.Add("@ownerid", SqlDbType.Int).Value = inquiry.PropertyOwnerID;
cmd.Parameters.Add("@travelerid", SqlDbType.Int).Value = inquiry.UserID;
cmd.Parameters.Add("@propertyid", SqlDbType.Int).Value = inquiry.PropertyID;
cmd.Parameters.Add("@arrivedate", SqlDbType.DateTime).Value = inquiry.ArrivalDate;
// cmd.Parameters.Add("@txn_type", SqlDbType.NVarChar, 20).Value = item.item_number;
// cmd.Parameters.Add("@payment_status", SqlDbType.NVarChar, 30).Value = item.item_number;
// cmd.Parameters.Add("@payment_type", SqlDbType.NVarChar, 30).Value = item.item_number;
// cmd.Parameters.Add("@pending_reason", SqlDbType.NVarChar, 30).Value = item.item_number;
//cmd.Parameters.Add("@item_name", SqlDbType.NVarChar, 100).Value = item.item_number;
int rows = cmd.ExecuteNonQuery();
con.Close();
}
}
}
catch (Exception ex)
{
// throw ex;
return(false);
}
return(true);
}
public static bool addPaymentLog(Transaction_Item item)
{
try
{
using (SqlConnection con = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("dbo.uspAddTransactionHistory", con))
{
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@item_number", SqlDbType.Int).Value = item.item_number;
cmd.Parameters.Add("@mc_gross", SqlDbType.Decimal).Value = item.mc_gross;
cmd.Parameters.Add("@mc_fee", SqlDbType.Decimal).Value = item.mc_fee;
cmd.Parameters.Add("@txn_id", SqlDbType.NVarChar, 1000).Value = item.txn_id;
cmd.Parameters.Add("@payment_date", SqlDbType.DateTime).Value = item.payment_date;
cmd.Parameters.Add("@business", SqlDbType.NVarChar, 1000).Value = item.business;
cmd.Parameters.Add("@payer_email", SqlDbType.NVarChar, 300).Value = item.payer_email;
cmd.Parameters.Add("@payer_id", SqlDbType.NVarChar, 200).Value = item.payer_id;
cmd.Parameters.Add("@mc_currency", SqlDbType.NVarChar, 10).Value = item.mc_currency;
cmd.Parameters.Add("@txn_type", SqlDbType.NVarChar, 20).Value = item.txn_type;
cmd.Parameters.Add("@payment_status", SqlDbType.NVarChar, 30).Value = item.payment_status;
cmd.Parameters.Add("@payment_type", SqlDbType.NVarChar, 30).Value = item.payment_type;
cmd.Parameters.Add("@pending_reason", SqlDbType.NVarChar, 30).Value = item.pending_reason;
cmd.Parameters.Add("@item_name", SqlDbType.NVarChar, 100).Value = item.item_name;
int rows = cmd.ExecuteNonQuery();
con.Close();
}
}
}
catch (Exception ex)
{
// throw ex;
return(false);
}
return(true);
}
protected void saveLog()
{
transitem = new Transaction_Item();
PropertyInfo[] props = transitem.GetType().GetProperties();
foreach (PropertyInfo prop in props)
{
prop.SetValue(transitem, Convert.ChangeType(Request[prop.Name], prop.PropertyType), null);
}
/*
* int item_number = Convert.ToInt32(Request["item_number"]);
* decimal mc_gross = Convert.ToDecimal(Request["mc_gross"]);
* decimal mc_fee = Convert.ToDecimal(Request["mc_fee"]);
* string txn_id = Request["txn_id"];
* string paydate = Request["payment_date"];
* string business = Request["business"];
* string payer_email = Request["payer_email"];
* string payer_id = Request["payer_id"];
* string mc_currency = Request["mc_currency"];
* string txn_type = Request["txn_type"];
* string payment_status = Request["payment_status"];
* string payment_type = Request["payment_type"];
* string pending_reason = Request["pending_reason"];
* string item_name = Request["item_name"];
*
*/
email_resp = BookResponseEmail.getResponseInfo(transitem.item_number); //respid
// if (email_resp.ID == 0 || email_resp.IsValid < 1) Response.Redirect("/Error.aspx?error=Wrong Response number or not valid");
inquiryinfo = BookDBProvider.getQuoteInfo(email_resp.QuoteID);
countryinfo = BookDBProvider.getCountryInfo(inquiryinfo.PropertyID);
owner_info = BookDBProvider.getUserInfo(inquiryinfo.PropertyOwnerID);
traveler_info = BookDBProvider.getUserInfo(inquiryinfo.UserID);
prop_info = BookDBProvider.getPropertyInfo(inquiryinfo.PropertyID);
PaymentHelper.addPaymentLog(transitem);
}
