public IEnumerable <DesignationEntity> GetDesignations()
{
var dsDesignation = OracleHelper.ExecuteDataset(connectionString, CommandType.Text,
QueryToGetDesignation);
DataTable dtDesignation = dsDesignation.Tables[0];
IList <DesignationEntity> designations = new List <DesignationEntity>();
DesignationEntity designation;
foreach (DataRow row in dtDesignation.Rows)
{
designation = new DesignationEntity();
designation.Designation = Convert.ToString(row["designation"]);
designation.IsConsulted = string.IsNullOrEmpty(Convert.ToString(row["consulted"])) ? false : true;
designation.IsReferencedInRegulation = string.IsNullOrEmpty(Convert.ToString(row["referenced"])) ? false : true;
designation.IsNormativeReference = string.IsNullOrEmpty(Convert.ToString(row["normative_ref"])) ? false : true;
designation.IsUsedAsBasisForNationalStandard = string.IsNullOrEmpty(Convert.ToString(row["used"])) ? false : true;
designation.IsAdoption = string.IsNullOrEmpty(Convert.ToString(row["adoption"])) ? false : true;
designation.QuantitySold = string.IsNullOrEmpty(Convert.ToString(row["sold"])) ? 0 : Convert.ToInt32(row["sold"]);
designations.Add(designation);
}
return(designations);
}
public DesignationEntity GetDesignation(string name)
{
var dsDesignation = OracleHelper.ExecuteDataset(connectionString, CommandType.Text,
QueryToGetDesignation);
//dsDesignation = db.ExecuteDataSet(CommandType.Text, QueryToGetDesignation);
DataTable dtDesignation = dsDesignation.Tables[0];
DataRow designationDetails = dtDesignation.AsEnumerable()
.Where(s => s.Field <string>("designation") == name)
.FirstOrDefault();
DesignationEntity designation = new DesignationEntity();
designation.Designation = Convert.ToString(designationDetails["designation"]);
designation.IsConsulted = string.IsNullOrEmpty(Convert.ToString(designationDetails["consulted"])) ? false : true;
designation.IsReferencedInRegulation = string.IsNullOrEmpty(Convert.ToString(designationDetails["referenced"])) ? false : true;
designation.IsNormativeReference = string.IsNullOrEmpty(Convert.ToString(designationDetails["normative_ref"])) ? false : true;
designation.IsUsedAsBasisForNationalStandard = string.IsNullOrEmpty(Convert.ToString(designationDetails["used"])) ? false : true;
designation.IsAdoption = string.IsNullOrEmpty(Convert.ToString(designationDetails["adoption"])) ? false : true;
designation.QuantitySold = string.IsNullOrEmpty(Convert.ToString(designationDetails["sold"])) ? 0 : Convert.ToInt32(designationDetails["sold"]);
return(designation);
}
