//Convert DataTable To object method public institutiontypeClass ConvertToOjbect(DataTable dt) { institutiontypeClass obj_institutiontype = new institutiontypeClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Institutiontypeid"]) != "") { obj_institutiontype.Institutiontypeid = Convert.ToInt32(dt.Rows[i]["Institutiontypeid"]); } else { obj_institutiontype.Institutiontypeid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Institutiontypename"]) != "") { obj_institutiontype.Institutiontypename = Convert.ToString(dt.Rows[i]["Institutiontypename"]); } else { obj_institutiontype.Institutiontypename = Convert.ToString(""); } } return(obj_institutiontype); }
//Convert DataTable To List method public List <institutiontypeClass> ConvertToList(DataTable dt) { List <institutiontypeClass> institutiontypelist = new List <institutiontypeClass>(); for (int i = 0; i < dt.Rows.Count; i++) { institutiontypeClass obj_institutiontype = new institutiontypeClass(); if (Convert.ToString(dt.Rows[i]["Institutiontypeid"]) != "") { obj_institutiontype.Institutiontypeid = Convert.ToInt32(dt.Rows[i]["Institutiontypeid"]); } else { obj_institutiontype.Institutiontypeid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Institutiontypename"]) != "") { obj_institutiontype.Institutiontypename = Convert.ToString(dt.Rows[i]["Institutiontypename"]); } else { obj_institutiontype.Institutiontypename = Convert.ToString(""); } institutiontypelist.Add(obj_institutiontype); } return(institutiontypelist); }
//create parameter public void createParameter(institutiontypeClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); obj_con.addParameter("@Institutiontypename", string.IsNullOrEmpty(Convert.ToString(obj.Institutiontypename)) ? "" : obj.Institutiontypename); obj_con.addParameter("@Institutiontypeid", obj.Institutiontypeid, trans); } catch (Exception ex) { throw ex; } }
//Select Constructor public institutiontypeCtl(Int32 id) { obj_con = new ConnectionCls(); institutiontypeClass obj_ins = new institutiontypeClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_ins.Institutiontypeid = Convert.ToInt32(dt.Rows[0]["Institutiontypeid"]); obj_ins.Institutiontypename = Convert.ToString(dt.Rows[0]["Institutiontypename"]); } } }
//insert data into database public Int32 insert(institutiontypeClass obj) { try { obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_institutiontype_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Institutiontypeid = Convert.ToInt32(obj_con.getValue("@Institutiontypeid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_institutiontype_insert"); } }
//update edited object public institutiontypeClass updateObject(institutiontypeClass obj) { try { institutiontypeClass oldObj = selectById(obj.Institutiontypeid); if (obj.Institutiontypename == null || obj.Institutiontypename.ToString().Trim() == "update") { obj.Institutiontypename = oldObj.Institutiontypename; } return(obj); } catch (Exception ex) { throw new Exception(ex.Message); } }