/// <summary>
/// Get Dip Input values
/// </summary>
/// <returns>List of dip input</returns>
public List <DipInput> GetDipInputValues()
{
List <DipInput> dipInputs = new List <DipInput>();
var strDate = DateAndTime.Year(DateAndTime.Today) + Strings.Right("00" + CommonUtility.GetStringValue(DateAndTime.Month(DateAndTime.Today)), 2) + Strings.Right("00" + CommonUtility.GetStringValue(DateAndTime.Day(DateAndTime.Today)), 2);
var strSql = "select A.ID, A.GradeID, B.FullName from TankInfo as A INNER JOIN Grade as B ON A.GradeID=B.ID where B.FuelType=\'G\'";
var dt = GetRecords(strSql, DataSource.CSCPump);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
DipInput input = new DipInput
{
TankId = CommonUtility.GetStringValue(dr["ID"]),
Grade = CommonUtility.GetStringValue(dr["FullName"]),
GradeId = CommonUtility.GetStringValue(dr["GradeID"])
};
string query = "select * from DipInput where TankID=" + CommonUtility.GetStringValue(dr["ID"]) + " and CONVERT(char(8), DipDate, 112)=\'" + strDate + "\'";
var rsDip = GetRecords(query, DataSource.CSCTrans);
if (rsDip == null || rsDip.Rows.Count == 0)
{
input.DipValue = "";
}
else
{
input.DipValue = CommonUtility.GetStringValue(rsDip.Rows[0]["DipValue"]);
}
dipInputs.Add(input);
}
}
return(dipInputs);
}
/// <summary>
/// Get Dip Inputs for Report
/// </summary>
/// <returns>List of dip inputs</returns>
public List <DipInput> GetDipInputsForReport(string strDate)
{
List <DipInput> dipInputs = new List <DipInput>();
var dt = GetRecords("select * from DipInput where CONVERT(char(8), DipDate, 112)=\'" + strDate + "\'", DataSource.CSCTrans);
foreach (DataRow dr in dt.Rows)
{
DipInput input = new DipInput
{
TankId = CommonUtility.GetStringValue(dr["TankID"]),
Grade = CommonUtility.GetStringValue(dr["Grade"]),
DipValue = CommonUtility.GetStringValue(dr["DipValue"])
};
dipInputs.Add(input);
}
return(dipInputs);
}
