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); }