public static Repairs GetOutstandingRepairs(int EstateID)
{
string q = "select core.Repairs.ID, core.Repairs.ReportID, core.Repairs.RepairTitle, " +
"core.Repairs.RepairDetails, core.Repairs.RaisedDate, " +
"core.Repairs.TargetCompletionDate, core.RepairStatus.RepairStatus " +
"from core.Repairs inner join core.RepairStatus on core.Repairs.RepairStatusID " +
"= core.RepairStatus.id where core.repairs.EstateID = " + EstateID.ToString() +
" and core.Repairs.RepairStatusId = 1 " +
" order by core.repairs.raisedDate Asc";
DBConnectionObject db = GlobalVariables.GetConnection();
DataTable dt = db.Connection.GetDataTable(q);
Repairs repairs = new Repairs();
repairs.AllRepairs = new List <Repairs>();
if (dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
if (row[0].ToString() != "Error")
{
foreach (DataRow dr in dt.Rows)
{
//raised date
DateTime raised = new DateTime();
if (dr[4] != DBNull.Value)
{
raised = Convert.ToDateTime(dr[4]);
}
//Target Completion
DateTime target = new DateTime();
if (dr[5] != DBNull.Value)
{
target = Convert.ToDateTime(dr[5]);
}
repairs.AllRepairs.Add(new Repairs {
ID = Convert.ToInt32(dr[0]),
Title = dr[2].ToString(),
Details = dr[3].ToString(),
RaisedDate = raised,
RaisedDatestr = Controls.DateString(raised),
TargetDate = target,
TargetDatestr = Controls.DateString(target),
Status = dr[6].ToString()
});
}
}
}
return(repairs);
}
public static Repairs GetAllRepairDetails(int repairID)
{
string q = "select core.Repairs.RepairTitle, core.Repairs.RepairDetails, " +
"core.Repairs.RaisedDate, core.Repairs.TargetCompletionDate, " +
"core.Repairs.ScheduleName, core.Repairs.QupteID, core.RepairStatus.RepairStatus, " +
"core.Repairs.HeadAssetID, core.Repairs.SubAssetID, " +
"core.PurchaseOrders.EstCost, core.PurchaseOrders.ID from core.Repairs inner join core.RepairStatus on " +
"core.Repairs.RepairStatusID = core.RepairStatus.id " +
"inner join core.PurchaseOrders on " +
"core.Repairs.PONumber = core.PurchaseOrders.id where core.Repairs.ID = " + repairID.ToString();
DBConnectionObject db = GlobalVariables.GetConnection();
DataTable dt = db.Connection.GetDataTable(q);
Repairs c = new Repairs();
if (dt.Rows.Count > 0)
{
DataRow d = dt.Rows[0];
if (d[0].ToString() != "Error")
{
foreach (DataRow dr in dt.Rows)
{
//raised date
DateTime raised = new DateTime();
if (dr[2] != DBNull.Value)
{
raised = Convert.ToDateTime(dr[2]);
}
//Target Completion
DateTime target = new DateTime();
if (dr[3] != DBNull.Value)
{
target = Convert.ToDateTime(dr[3]);
}
//Estiated Cost
double est = 0;
if (dr[9] != DBNull.Value)
{
est = Convert.ToDouble(dr[9]);
}
string eststr = Controls.CurrencyString(est);
//po number
int po = 0;
if (dr[10] != DBNull.Value)
{
po = Convert.ToInt32(dr[10]);
}
Repairs r = new Repairs
{
Title = dr[0].ToString(),
Details = dr[1].ToString(),
RaisedDate = raised,
RaisedDatestr = Controls.DateString(raised),
TargetDate = target,
TargetDatestr = Controls.DateString(target),
Status = dr[6].ToString(),
EstimatedCostStr = eststr,
HeadAssetID = Convert.ToInt32(dr[7]),
SubAssetID = Convert.ToInt32(dr[8]),
PONumber = po
};
c = r;
}
//Get Asset Details
if (c.HeadAssetID != 0)
{
q = "Select AssetName, AssetLocation from core.headassets where id = " + c.HeadAssetID.ToString();
DataTable dt1 = db.Connection.GetDataTable(q);
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0][0] != DBNull.Value || dt1.Rows[0][0].ToString() != "Error")
{
c.HeadAssetName = dt1.Rows[0][0].ToString();
c.HeadAssetLocation = dt1.Rows[0][1].ToString();
}
}
}
if (c.SubAssetID != 0)
{
q = "Select AssetName, AssetLocation from core.subassets where id = " + c.SubAssetID.ToString();
DataTable dt1 = db.Connection.GetDataTable(q);
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0][0] != DBNull.Value || dt1.Rows[0][0].ToString() != "Error")
{
c.SubAssetName = dt1.Rows[0][0].ToString();
c.SubAssetLocation = dt1.Rows[0][1].ToString();
}
}
}
//sets head asset location to null if sub asset location present.
//view only needs one of the asset locations to be visible.
if (c.SubAssetLocation != null && c.SubAssetLocation != "")
{
c.HeadAssetLocation = null;
}
}
}
//if quote id is not 0 get quote details
return(c);
}
