//update edited object public institutionClass updateObject(institutionClass obj) { try { institutionClass oldObj = selectById(obj.Institutionid); if (obj.Institutioncode == null || obj.Institutioncode.ToString().Trim() == "update") { obj.Institutioncode = oldObj.Institutioncode; } if (obj.Institutiontypeid == null || obj.Institutiontypeid.ToString().Trim() == "0") { obj.Institutiontypeid = oldObj.Institutiontypeid; } if (obj.Shortname == null || obj.Shortname.ToString().Trim() == "update") { obj.Shortname = oldObj.Shortname; } if (obj.Legalname == null || obj.Legalname.ToString().Trim() == "update") { obj.Legalname = oldObj.Legalname; } if (obj.Addressline1 == null || obj.Addressline1.ToString().Trim() == "update") { obj.Addressline1 = oldObj.Addressline1; } if (obj.Addressline2 == null || obj.Addressline2.ToString().Trim() == "update") { obj.Addressline2 = oldObj.Addressline2; } if (obj.Locationcity == null || obj.Locationcity.ToString().Trim() == "update") { obj.Locationcity = oldObj.Locationcity; } if (obj.Stateid == null || obj.Stateid.ToString().Trim() == "0") { obj.Stateid = oldObj.Stateid; } if (obj.Locationzip == null || obj.Locationzip.ToString().Trim() == "update") { obj.Locationzip = oldObj.Locationzip; } return(obj); } catch (Exception ex) { throw new Exception(ex.Message); } }
//insert data into database public Int32 insert(institutionClass obj) { try { obj_con.clearParameter(); createParameter(obj, DBTrans.Insert); obj_con.BeginTransaction(); obj_con.ExecuteNoneQuery("sp_institution_insert", CommandType.StoredProcedure); obj_con.CommitTransaction(); return(obj.Institutionid = Convert.ToInt32(obj_con.getValue("@Institutionid"))); } catch (Exception ex) { obj_con.RollbackTransaction(); throw new Exception("sp_institution_insert"); } }
//create parameter public void createParameter(institutionClass obj, DB_con.DBTrans trans) { try { obj_con.clearParameter(); obj_con.addParameter("@Institutioncode", string.IsNullOrEmpty(Convert.ToString(obj.Institutioncode)) ? "" : obj.Institutioncode); obj_con.addParameter("@Institutiontypeid", string.IsNullOrEmpty(Convert.ToString(obj.Institutiontypeid)) ? 0 : obj.Institutiontypeid); obj_con.addParameter("@Shortname", string.IsNullOrEmpty(Convert.ToString(obj.Shortname)) ? "" : obj.Shortname); obj_con.addParameter("@Legalname", string.IsNullOrEmpty(Convert.ToString(obj.Legalname)) ? "" : obj.Legalname); obj_con.addParameter("@Addressline1", string.IsNullOrEmpty(Convert.ToString(obj.Addressline1)) ? "" : obj.Addressline1); obj_con.addParameter("@Addressline2", string.IsNullOrEmpty(Convert.ToString(obj.Addressline2)) ? "" : obj.Addressline2); obj_con.addParameter("@Locationcity", string.IsNullOrEmpty(Convert.ToString(obj.Locationcity)) ? "" : obj.Locationcity); obj_con.addParameter("@Stateid", string.IsNullOrEmpty(Convert.ToString(obj.Stateid)) ? 0 : obj.Stateid); obj_con.addParameter("@Locationzip", string.IsNullOrEmpty(Convert.ToString(obj.Locationzip)) ? "" : obj.Locationzip); obj_con.addParameter("@Institutionid", obj.Institutionid, trans); } catch (Exception ex) { throw ex; } }
//Select Constructor public institutionCtl(Int32 id) { obj_con = new ConnectionCls(); institutionClass obj_ins = new institutionClass(); using (DataTable dt = selectdatatable(id)) { if (dt.Rows.Count > 0) { obj_ins.Institutionid = Convert.ToInt32(dt.Rows[0]["Institutionid"]); obj_ins.Institutioncode = Convert.ToString(dt.Rows[0]["Institutioncode"]); obj_ins.Institutiontypeid = Convert.ToInt32(dt.Rows[0]["Institutiontypeid"]); obj_ins.Shortname = Convert.ToString(dt.Rows[0]["Shortname"]); obj_ins.Legalname = Convert.ToString(dt.Rows[0]["Legalname"]); obj_ins.Addressline1 = Convert.ToString(dt.Rows[0]["Addressline1"]); obj_ins.Addressline2 = Convert.ToString(dt.Rows[0]["Addressline2"]); obj_ins.Locationcity = Convert.ToString(dt.Rows[0]["Locationcity"]); obj_ins.Stateid = Convert.ToInt32(dt.Rows[0]["Stateid"]); obj_ins.Locationzip = Convert.ToString(dt.Rows[0]["Locationzip"]); } } }
//Convert DataTable To object method public institutionClass ConvertToOjbect(DataTable dt) { institutionClass obj_institution = new institutionClass(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToString(dt.Rows[i]["Institutionid"]) != "") { obj_institution.Institutionid = Convert.ToInt32(dt.Rows[i]["Institutionid"]); } else { obj_institution.Institutionid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Institutioncode"]) != "") { obj_institution.Institutioncode = Convert.ToString(dt.Rows[i]["Institutioncode"]); } else { obj_institution.Institutioncode = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Institutiontypeid"]) != "") { obj_institution.Institutiontypeid = Convert.ToInt32(dt.Rows[i]["Institutiontypeid"]); } else { obj_institution.Institutiontypeid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Shortname"]) != "") { obj_institution.Shortname = Convert.ToString(dt.Rows[i]["Shortname"]); } else { obj_institution.Shortname = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Legalname"]) != "") { obj_institution.Legalname = Convert.ToString(dt.Rows[i]["Legalname"]); } else { obj_institution.Legalname = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Addressline1"]) != "") { obj_institution.Addressline1 = Convert.ToString(dt.Rows[i]["Addressline1"]); } else { obj_institution.Addressline1 = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Addressline2"]) != "") { obj_institution.Addressline2 = Convert.ToString(dt.Rows[i]["Addressline2"]); } else { obj_institution.Addressline2 = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Locationcity"]) != "") { obj_institution.Locationcity = Convert.ToString(dt.Rows[i]["Locationcity"]); } else { obj_institution.Locationcity = Convert.ToString(""); } if (Convert.ToString(dt.Rows[i]["Stateid"]) != "") { obj_institution.Stateid = Convert.ToInt32(dt.Rows[i]["Stateid"]); } else { obj_institution.Stateid = Convert.ToInt32("0"); } if (Convert.ToString(dt.Rows[i]["Locationzip"]) != "") { obj_institution.Locationzip = Convert.ToString(dt.Rows[i]["Locationzip"]); } else { obj_institution.Locationzip = Convert.ToString(""); } } return(obj_institution); }