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