public static PropertyInform getPropertyInfo(int propid)
{
PropertyInform propinfo = new PropertyInform();
try
{
using (SqlConnection con = new SqlConnection(connString))
{
using (SqlCommand cmd = new SqlCommand("select Name,UserID from Properties where ID=@id", con))
{
con.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = propid;
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
if (reader.Read())
{
//more code
propinfo.id = propid;
propinfo.name = reader[0].ToString();
propinfo.userid = Convert.ToInt32(reader[1]);
}
}
}
con.Close();
}
}
}
catch (Exception ex)
{
// throw ex;
// return 0;
}
return(propinfo);
}
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);
}
