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