public MetricsDataDetails MetricsGetterByid(int id)
{
SqlCommand sda;
if (con.State != ConnectionState.Open)
{
con.Open();
}
sda = new SqlCommand(commonThings.metricsGetterbyId, con);
sda.Parameters.AddWithValue("@id", id);
SqlDataReader dr = sda.ExecuteReader();
MetricsDataDetails no = new MetricsDataDetails();
if (dr.Read())
{
MetricsDataDetails metricsDataDetails = new MetricsDataDetails()
{
id = Convert.ToInt32(dr[0]),
applicationName = Convert.ToString(dr[2]),
taskDescription = Convert.ToString(dr[3]),
taskClassification = Convert.ToString(dr[4]),
startDate = (Convert.ToDateTime(dr[5])).ToLongDateString(),
endDate = (Convert.ToDateTime(dr[6])).ToLongDateString(),
effortHours = Convert.ToDouble(dr[7])
};
con.Close();
return(metricsDataDetails);
}
return(no);
}
public List <NotFilled> AllEmployees()
{
List <NotFilled> emps = new List <NotFilled>();
SqlCommand sda;
if (con.State != ConnectionState.Open)
{
con.Open();
}
sda = new SqlCommand(commonThings.allEmployees, con);
SqlDataReader dr = sda.ExecuteReader();
MetricsDataDetails no = new MetricsDataDetails();;
while (dr.Read())
{
NotFilled notFilled = new NotFilled()
{
userName = Convert.ToString(dr[0]),
email = Convert.ToString(dr[1]),
applicationName = Convert.ToString(dr[2])
};
emps.Add(notFilled);
}
con.Close();
return(emps);
}
public List <MetricsDataDetails> AllMetricsGetter()
{
SqlCommand sda;
if (con.State != ConnectionState.Open)
{
con.Open();
}
sda = new SqlCommand(commonThings.allMetricsGetter, con);
SqlDataReader dr = sda.ExecuteReader();
List <MetricsDataDetails> list = new List <MetricsDataDetails>();
while (dr.Read())
{
MetricsDataDetails metrics = new MetricsDataDetails()
{
applicationName = Convert.ToString(dr[1]),
taskDescription = Convert.ToString(dr[2]),
taskClassification = Convert.ToString(dr[3]),
startDate = (Convert.ToDateTime(dr[4])).ToLongDateString(),
endDate = (Convert.ToDateTime(dr[5])).ToLongDateString(),
effortHours = Convert.ToDouble(dr[6]),
userName = Convert.ToString(dr[7])
};
list.Add(metrics);
}
con.Close();
return(list);
}
public void MetricsFiller(MetricsDataDetails metricsData, string userName)
{
SqlCommand sda;
if (con.State != ConnectionState.Open)
{
con.Open();
}
sda = new SqlCommand(commonThings.insertIntoMetricsData, con);
sda.Parameters.AddWithValue("@userName", userName);
sda.Parameters.AddWithValue("@applicationName", metricsData.applicationName.ToLower());
sda.Parameters.AddWithValue("@taskDescription", metricsData.taskDescription);
sda.Parameters.AddWithValue("@taskClassification", metricsData.taskClassification);
sda.Parameters.AddWithValue("@startDate", metricsData.startDate);
sda.Parameters.AddWithValue("@endDate", metricsData.endDate);
sda.Parameters.AddWithValue("@effortHours", metricsData.effortHours);
sda.ExecuteNonQuery();
con.Close();
}
public ActionResult MetricsData(MetricsDataDetails metricsData)
{
DataGetter.MetricsFiller(metricsData, Session["userName"].ToString());
return(RedirectToAction("MetricsData", "Admin"));;
}
