public List <PHControllerBO> LoadtblPHProjectName()
{
List <PHControllerBO> objPHControllerBO = new List <PHControllerBO>();
try
{
DatabaseContext objDBContext = new DatabaseContext();
HybridDictionary objHybirdTemplate = new HybridDictionary(true);
DataSet dsTemplate = objDBContext.DownloadDataFromDB(GlobalConstants.GET_PHProject, objHybirdTemplate);
PHControllerBO objStaffingfirmInfo = new PHControllerBO();
if (dsTemplate != null && dsTemplate.Tables != null && dsTemplate.Tables.Count > 0 && dsTemplate.Tables[0].Rows != null && dsTemplate.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsTemplate.Tables[0].Rows)
{
objPHControllerBO.Add(new PHControllerBO {
ProjectId = Formatter.ConvertToGuid(dr["ProjectId"]), ProjectName = Formatter.ConvertToString(dr["ProjectName"])
});
}
}
}
catch (Exception ex)
{
throw ex;
}
return(objPHControllerBO);
}
public List <PHControllerBO> Get(string ProjectName, string CabinetName)
{
List <PHControllerBO> objPHControllerBO = new List <PHControllerBO>();
try
{
DatabaseContext objDBContext = new DatabaseContext();
HybridDictionary objHybirdTemplate = new HybridDictionary(true);
objHybirdTemplate.Add("@ProjectName", ProjectName);
objHybirdTemplate.Add("@CabinetName", CabinetName);
DataSet dsTemplate = objDBContext.DownloadDataFromDB(GlobalConstants.GETPHArea, objHybirdTemplate);
PHControllerBO objStaffingfirmInfo = new PHControllerBO();
if (dsTemplate != null && dsTemplate.Tables != null && dsTemplate.Tables.Count > 0 && dsTemplate.Tables[0].Rows != null && dsTemplate.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsTemplate.Tables[0].Rows)
{
objPHControllerBO.Add(new PHControllerBO {
Area = Formatter.ConvertToString(dr["Area"])
});
}
}
}
catch (Exception ex)
{
throw ex;
}
return(objPHControllerBO);
}
// GET api/sm110/5
public List <SM110BO> Get(string ProjectName, string CabinetName, string AreaName, string LocationName, string CabinetTypeName, int ModelView)
{
List <SM110BO> objPHSM110BO = new List <SM110BO>();
List <GeneralClass> objIDCBO = new List <GeneralClass>();
List <GeneralClass> objHeatDissBO = new List <GeneralClass>();
try
{
DatabaseContext objDBContext = new DatabaseContext();
HybridDictionary objHybirdTemplate = new HybridDictionary(true);
objHybirdTemplate.Add("@ProjectName", ProjectName);
objHybirdTemplate.Add("@CabinetName", CabinetName);
objHybirdTemplate.Add("@AreaName", AreaName);
objHybirdTemplate.Add("@LocationName", LocationName);
objHybirdTemplate.Add("@CabinetTypeName", CabinetTypeName);
objHybirdTemplate.Add("@ModelView", ModelView);
DataSet dsTemplate = objDBContext.DownloadDataFromDB(GlobalConstants.GETPHSM110VDCps, objHybirdTemplate);
PHControllerBO objStaffingfirmInfo = new PHControllerBO();
string Name = "";
if (dsTemplate != null && dsTemplate.Tables != null && dsTemplate.Tables.Count > 0 && dsTemplate.Tables[0].Rows != null && dsTemplate.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsTemplate.Tables[0].Rows)
{
objIDCBO = new List <GeneralClass>();
objHeatDissBO = new List <GeneralClass>();
if (ModelView == 0)
{
objIDCBO.Add(new GeneralClass {
Name = "CurrentRating", Value = Formatter.ConvertToDecimal(dr["CurrentRating"])
});
objIDCBO.Add(new GeneralClass {
Name = "IDC", Value = Formatter.ConvertToDecimal(dr["IDC"])
});
objHeatDissBO.Add(new GeneralClass {
Name = "HeatDiss", Value = Formatter.ConvertToDecimal(dr["HeatDiss"])
});
Name = Formatter.ConvertToString(dr["CabinetName"]);
}
else
{
//objIDCBO.Add(new GeneralClass { Name = "CurrentRating", Value = Formatter.ConvertToDecimal(dr["CurrentRating"]) });
objIDCBO.Add(new GeneralClass {
Name = "IDC", Value = Formatter.ConvertToDecimal(dr["IDC"])
});
objHeatDissBO.Add(new GeneralClass {
Name = "HeatDiss", Value = Formatter.ConvertToDecimal(dr["HeatDiss"])
});
if (CabinetName == null || CabinetName == "")
{
Name = Formatter.ConvertToString(dr["CabinetName"]) + "/" + Formatter.ConvertToString(dr["ModuleName"]);
}
else
{
Name = Formatter.ConvertToString(dr["ModuleName"]);
}
}
objPHSM110BO.Add(new SM110BO {
ProjectName = Formatter.ConvertToString(dr["ProjectName"]), ModuleName = Formatter.ConvertToString(dr["ModuleName"]), Date = Name, Categories = objIDCBO, LineCategory = objHeatDissBO, IDC = Formatter.ConvertToDecimal(dr["IDC"]), CurrentRating = Formatter.ConvertToDecimal(dr["CurrentRating"]), HeatDiss = Formatter.ConvertToDecimal(dr["HeatDiss"])
});
}
}
}
catch (Exception ex)
{
throw ex;
}
return(objPHSM110BO);
}
