public int SaveRideOffer(RideOffer rideOffer)
{
var conn = MyAdoHelper.ConnectToDb("Database.mdf");
try
{
var param = new System.Data.SqlClient.SqlParameter[11];
param[0] = new System.Data.SqlClient.SqlParameter("userId", SqlDbType.Int);
param[0].Value = rideOffer.GetUserId();
param[1] = new System.Data.SqlClient.SqlParameter("rideDate", SqlDbType.DateTime);
param[1].Value = rideOffer.GetRideDate();
param[2] = new System.Data.SqlClient.SqlParameter("minute", SqlDbType.Int);
param[2].Value = rideOffer.GetMinute();
param[3] = new System.Data.SqlClient.SqlParameter("hour", SqlDbType.Int);
param[3].Value = rideOffer.GetHour();
param[4] = new System.Data.SqlClient.SqlParameter("email", SqlDbType.NVarChar);
param[4].Value = rideOffer.GetEmail();
param[5] = new System.Data.SqlClient.SqlParameter("phone", SqlDbType.NVarChar);
param[5].Value = rideOffer.GetPhone();
param[6] = new System.Data.SqlClient.SqlParameter("notes", SqlDbType.NVarChar);
param[6].Value = rideOffer.GetNotes();
param[7] = new System.Data.SqlClient.SqlParameter("price", SqlDbType.Int);
param[7].Value = rideOffer.GetPrice();
param[8] = new System.Data.SqlClient.SqlParameter("genderPref", SqlDbType.Int);
param[8].Value = rideOffer.GetgenderPref();
param[9] = new System.Data.SqlClient.SqlParameter("originName", SqlDbType.NVarChar);
param[9].Value = rideOffer.GetOriginName();
param[10] = new System.Data.SqlClient.SqlParameter("destinationName", SqlDbType.NVarChar);
param[10].Value = rideOffer.GetDestinationName();
return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, "SaveRideOffer", param).ToString()));
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
