public Cable(Cable obj)
{
PropertyInfo[] p = obj.GetType().GetProperties(); // get entity properties
for (int i = 0; i < (p.Length); i++)
{
if (!p[i].PropertyType.Name.Contains("list") && !p[i].Name.Contains("arg"))
p[i].SetValue(this, p[i].GetValue(obj, null), null); // set entity's property values to obj properties
}
}
public object Fetch(object obj)
{
int id;
string type; // type of object passed
string objtype = obj.GetType().ToString(); // get object type
if (objtype == "System.String")
{
string[] strTemp = ((string)obj).Split(new char[] { '|' }); // if the object type is a string then extract the id and type
id = Convert.ToInt32(strTemp[0]);
type = strTemp[1];
}
else
{
id = ((Cable)obj).cable_id;
type = "all"; // object is a cable and get all information
}
_cable = new Cable();
_user = (User)System.Web.HttpContext.Current.Session[Constant.session.User];
_dbmgr = new DBManager(_user.plantDBStr);
_dbmgr.ConnectionString = _user.plantDBStr;
switch (type)
{
case "component":
FetchComponentList(id, _dbmgr);
return _cable.componentlist;
case "drawing":
FetchDrawingList(id, _dbmgr);
return _cable.drawinglist;
case "routechg":
FetchRoutechgList(id, _dbmgr);
return _cable.routechglist;
case "all":
FetchCable(id, _dbmgr);
FetchComponentList(id, _dbmgr);
FetchDrawingList(id, _dbmgr);
FetchRoutechgList(id, _dbmgr);
FetchRouteList(id, _dbmgr);
FetchCRDPowerList(id, _dbmgr);
return _cable;
}
return _cable;
}
private void UpdateStatus(IDBManager dbmgr, Cable item, int statustype_id, string user_id, DateTime status_date)
{
if ((user_id == "N/A") || (user_id == ""))
{
// delete status
dbmgr.CreateParameters(2);
dbmgr.AddParameters(0, "@cable_id", item.cable_id);
dbmgr.AddParameters(1, "@statustype_id", statustype_id);
dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.CABSTATUS_d");
}
else
{
// update status
dbmgr.CreateParameters(4);
dbmgr.AddParameters(0, "@cable_id", item.cable_id);
dbmgr.AddParameters(1, "@statustype_id", statustype_id);
dbmgr.AddParameters(2, "@user_id", user_id);
if (status_date == Convert.ToDateTime(null))
// set date to null
dbmgr.AddParameters(3, "@status_date", null);
else
// update date
dbmgr.AddParameters(3, "@status_date", status_date);
dbmgr.ExecuteNonQuery(CommandType.StoredProcedure, "dbo.CABSTATUS_u");
}
}
private void FetchCable(int id, IDBManager dbmgr)
{
string qryLocal = "SELECT *, dbo.GET_LOCATION(FR_EQUIP) AS FR_EQUIP_LOC, dbo.GET_LOCATION(TO_EQUIP) AS TO_EQUIP_LOC, " +
" dbo.GET_LOCATION(FR_EQUIP_ORIG) AS FR_EQUIP_ORIG_LOC, dbo.GET_LOCATION(TO_EQUIP_ORIG) AS TO_EQUIP_ORIG_LOC " +
" FROM viewCABLIST WHERE CABLE_ID = @id";
try
{
dbmgr.Open();
dbmgr.CreateParameters(1);
dbmgr.AddParameters(0, "@id", id);
dbmgr.ExecuteReader(CommandType.Text, qryLocal);
if (dbmgr.DataReader.Read())
{
PropertyInfo[] p = _cable.GetType().GetProperties(); // get properties of object
_cable = (Cable)FetchObject(_cable, p, dbmgr);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbmgr.Dispose();
}
}