public List <ResourceCostDetail> GetResourceDetails()
{
var query = "Select Id, Practice, Skill ,Competency, CreatedDate, CreatedBy, OffshoreCost, OnsiteCost, IsActive from tbl_ResourceCost order by Practice, Skill, Competency";
var connectionString = _configuration.GetConnectionString("DefaultConnection");
var resourceCostDetailList = new List <ResourceCostDetail>();
using (var connection = new MySqlConnection(connectionString))
{
using (var cmd = new MySqlCommand(query, connection))
{
connection.Open();
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var detail = new ResourceCostDetail();
detail.Id = Convert.ToInt32(reader["Id"]);
detail.Competency = Convert.ToString(reader["Competency"]);
detail.CreatedBy = Convert.ToString(reader["CreatedBy"]);
detail.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
detail.IsActive = Convert.ToBoolean(reader["IsActive"]);
detail.Practice = Convert.ToString(reader["Practice"]);
detail.Skill = Convert.ToString(reader["Skill"]);
detail.OnsiteCost = Convert.ToDouble(reader["OnsiteCost"]);
detail.OffshoreCost = Convert.ToDouble(reader["OffshoreCost"]);
resourceCostDetailList.Add(detail);;
}
}
}
return(resourceCostDetailList);
}
public ResourceCostDetail GetCostForResource(string location, string practice, string skill, string competency)
{
var query = "Select Practice, Skill ,Competency, OnsiteCost, OffshoreCost, CreatedDate, CreatedBy, IsActive from tbl_ResourceCost" +
" Where Practice = @Practice AND Skill = @Skill AND Competency = @Competency ";
var connectionString = _configuration.GetConnectionString("DefaultConnection");
var detail = new ResourceCostDetail();
using (var connection = new MySqlConnection(connectionString))
{
using (var cmd = new MySqlCommand(query, connection))
{
connection.Open();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddRange(new MySqlParameter[] {
new MySqlParameter {
ParameterName = "@Practice", Value = practice.ToUpper()
},
new MySqlParameter {
ParameterName = "@Skill", Value = skill.ToUpper()
},
new MySqlParameter {
ParameterName = "@Competency", Value = competency.ToUpper()
},
});
var reader = cmd.ExecuteReader();
while (reader.Read())
{
detail.Competency = Convert.ToString(reader["Competency"]);
detail.CreatedBy = Convert.ToString(reader["CreatedBy"]);
detail.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
detail.IsActive = Convert.ToBoolean(reader["IsActive"]);
detail.OffshoreCost = Convert.ToDouble(reader["OffshoreCost"]);
detail.OnsiteCost = Convert.ToDouble(reader["OnsiteCost"]);
detail.Practice = Convert.ToString(reader["Practice"]);
detail.Skill = Convert.ToString(reader["Skill"]);
}
}
}
return(detail);
}
