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