private objfin_Modules Select_Obj(IDataReader idr) { objfin_Modules o = new objfin_Modules(); bool rtNull = true; if (idr != null) { while (idr.Read()) { rtNull = false; if (idr["moduleId"] != DBNull.Value) { o.moduleId = Convert.ToInt32(idr["moduleId"]); } if (idr["moduleTitle"] != DBNull.Value) { o.moduleTitle = Convert.ToString(idr["moduleTitle"]); } if (idr["moduleDescription"] != DBNull.Value) { o.moduleDescription = Convert.ToString(idr["moduleDescription"]); } if (idr["moduleIsOffial"] != DBNull.Value) { o.moduleIsOffial = Convert.ToBoolean(idr["moduleIsOffial"]); } if (idr["CField1"] != DBNull.Value) { o.CField1 = Convert.ToString(idr["CField1"]); } if (idr["CField2"] != DBNull.Value) { o.CField2 = Convert.ToString(idr["CField2"]); } if (idr["CField3"] != DBNull.Value) { o.CField3 = Convert.ToString(idr["CField3"]); } if (idr["CField4"] != DBNull.Value) { o.CField4 = Convert.ToString(idr["CField4"]); } } } if (rtNull) { o = null; } return(o); }
public void Update(objfin_Modules i) { db.Update(i.moduleId, i.moduleTitle, i.moduleDescription, i.moduleIsOffial, i.CField1, i.CField2, i.CField3, i.CField4); }