public SqlParameter[] GetParameters(M_MySubscription model)
{
SqlParameter[] sp = GetSP();
sp[0].Value = model.Id;
sp[1].Value = model.Reference_ID;
sp[2].Value = model.Order_Time;
sp[3].Value = model.Period;
sp[4].Value = model.Start_Date;
sp[5].Value = model.Order_Type;
sp[6].Value = model.User_Name;
sp[7].Value = model.Tel;
sp[8].Value = model.Email;
return(sp);
}
public M_MySubscription GetModelFromReader(DbDataReader rdr)
{
M_MySubscription model = new M_MySubscription();
model.Id = Convert.ToInt32(rdr["id"]);
model.Reference_ID = Convert.ToInt32(rdr["Reference_ID"]);
model.Order_Time = Convert.ToDateTime(rdr["Order_Time"]);
model.Period = Convert.ToInt32(rdr["Period"]);
model.Start_Date = Convert.ToDateTime(rdr["Start_Date"]);
model.Order_Type = Convert.ToInt32(rdr["Order_Type"]);
model.User_Name = rdr["User_Name"].ToString();
model.Tel = rdr["Tel"].ToString();
model.Email = rdr["Email"].ToString();
rdr.Close();
return(model);
}
