public M_Log GetModelFromReader(SqlDataReader rdr) { M_Log model = new M_Log(); model.ID = Convert.ToInt32(rdr["id"]); model.UName = ConverToStr(rdr["UName"]); model.IP = ConverToStr(rdr["IP"]); model.AName = ConverToStr(rdr["AName"]); model.CDate = ConvertToDate(rdr["CDate"]); model.Source = ConverToStr(rdr["Source"]); model.Action = ConverToStr(rdr["Action"]); model.Message = ConverToStr(rdr["Message"]); model.Level = ConverToStr(rdr["Level"]); rdr.Close(); return(model); }
//FOR SQL public override SqlParameter[] GetParameters() { M_Log model = this; if (model.CDate <= DateTime.MinValue) { model.CDate = DateTime.Now; } SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.UName; sp[2].Value = model.IP; sp[3].Value = model.AName; sp[4].Value = model.CDate; sp[5].Value = model.Source; sp[6].Value = model.Action; sp[7].Value = model.Message; sp[8].Value = model.Level; return(sp); }