public HttpResponseMessage ExtractionProgressInfo(HttpRequestMessage request)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage res = null;
OtherInfo obj = new OtherInfo();
ExtractionProgressModel extractionProgressInfo = obj.GetExtractionProgressInfo();
res = request.CreateResponse(HttpStatusCode.OK, extractionProgressInfo);
return res;
}));
}
} //========== end of the mtd
public ExtractionProgressModel GetExtractionProgressInfo()
{
List <ExtractionProgressTableModel> progressInfo = new List <ExtractionProgressTableModel>();
ExtractionProgressModel exProg = new ExtractionProgressModel();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("spp_extractionprogressinfo", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
con.Open();
//cmd.ExecuteNonQuery();
//cmd2.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ExtractionProgressTableModel pObj = new ExtractionProgressTableModel();
// progressInfo.TotalCount = reader["teambankid"] != DBNull.Value ? int.Parse(reader["teambankid"].ToString()) : 0;
pObj.PackageName = reader["processname"] != DBNull.Value ? reader["processname"].ToString() : "";
pObj.EstimatedTime = reader["EstimatedTime"] != DBNull.Value ? Convert.ToDateTime(reader["EstimatedTime"].ToString()) : Convert.ToDateTime("00:00:00.000");
pObj.Status = reader["Status"] != DBNull.Value ? reader["Status"].ToString() : "";
//pObj.Status = pObj.Status.ToUpper().Trim();
progressInfo.Add(pObj);
}
con.Close();
string status = "DONE";
exProg.TotalCount = progressInfo.Count();
exProg.CompletedPkgCount = progressInfo.Where(x => x.Status.ToUpper().Trim() == status).Count();
exProg.PackageName = progressInfo.Select(x => x.PackageName).FirstOrDefault();
exProg.EstimatedTimeString = progressInfo.Select(x => x.EstimatedTime).FirstOrDefault().ToString("HH:mm:ss");
//exProg.EstimatedTimeString = progressInfo.Select(x => x.EstimatedTime).FirstOrDefault().ToString("yyyy-MM-dd");
//string dt = DateTime.Now.ToString("MM-dd-yyyy hh:mm:ss tt");
if (exProg.TotalCount == 0)
{
exProg.CompletedPkgCount = exProg.TotalCount;
}
}
return(exProg);
} //========== end of the mtd
