internal HttpResponseMessage DownTimes(HttpRequestMessage request, DownTimeDTO cqDTO)
{
string key;
var aur = new AppUserRepository();
var companyId = 0;
var userId = aur.ValidateUser(cqDTO.Key, out key, ref companyId);
if (userId > 0)
{
var ur = new DownTimeRepository();
var u = new DownTime();
if (cqDTO.DownTimeDate != null)
{
cqDTO.Start_DownTimeDate = DateTime.Parse(cqDTO.DownTimeDate).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse(cqDTO.DownTimeDate).AddDays(1).ToString();
}
else
{
int sm = int.Parse(cqDTO.StartDateMonth);
if (sm == 1)
{
cqDTO.Start_DownTimeDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString();
}
else if (sm == 12)
{
cqDTO.Start_DownTimeDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString();
}
else
{
cqDTO.Start_DownTimeDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString();
}
cqDTO.StartDateMonth = null;
cqDTO.StartDateYear = null;
}
var predicate = ur.GetPredicate(cqDTO, u, companyId);
var data = ur.GetByPredicate(predicate);
var col = new Collection <Dictionary <string, string> >();
data = data.OrderBy(x => x.DownTimeDate).ToList();
foreach (var item in data)
{
var dic = new Dictionary <string, string>();
dic.Add("DownTimeID", item.DownTimeID.ToString());
dic.Add("DepartmentID", item.DownTimeType.DepartmentID.ToString());
dic.Add("DepartmentName", item.DownTimeType.Department.DepartmentName);
dic.Add("DownTimeDate", item.DownTimeDate.ToShortDateString());
dic.Add("DownTimeTypeID", item.DownTimeTypeID.ToString());
dic.Add("DownTimeType", item.DownTimeType.DownTimeName.ToString());
dic.Add("Minutes", item.Minutes.ToString());
dic.Add("Note", item.DownTimeNote.ToString());
col.Add(dic);
var ufdic = new Dictionary <string, string>();
}
var dttr = new DownTimeTypeRepository();
var dtts = dttr.GetDownTimeTypesByDept(int.Parse(cqDTO.DepartmentID));
var col2 = new Collection <Dictionary <string, string> >();
foreach (var dtt in dtts)
{
var dic = new Dictionary <string, string>();
dic.Add("DownTimeTypeID", dtt.DownTimeTypeID.ToString());
dic.Add("DownTypeName", dtt.DownTimeName);
col2.Add(dic);
}
var retVal = new GenericDTO
{
Key = key,
ReturnData = col,
ReturnData1 = col2
};
return(Request.CreateResponse(HttpStatusCode.OK, retVal));
}
var message = "validation failed";
return(request.CreateResponse(HttpStatusCode.NotFound, message));
}
internal HttpResponseMessage DownTimes(HttpRequestMessage request, DownTimeDTO cqDTO)
{
string key;
var aur = new AppUserRepository();
var companyId = 0;
var userId = aur.ValidateUser(cqDTO.Key, out key, ref companyId);
if (userId > 0)
{
var ur = new DownTimeRepository();
var u = new DownTime();
if (cqDTO.DownTimeDate != null)
{
cqDTO.Start_DownTimeDate = DateTime.Parse(cqDTO.DownTimeDate).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse(cqDTO.DownTimeDate).AddDays(1).ToString();
}
else
{
int sm = int.Parse(cqDTO.StartDateMonth);
if (sm == 1)
{
cqDTO.Start_DownTimeDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString();
}
else if (sm == 12)
{
cqDTO.Start_DownTimeDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString();
}
else
{
cqDTO.Start_DownTimeDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString();
cqDTO.End_DownTimeDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString();
}
cqDTO.StartDateMonth = null;
cqDTO.StartDateYear = null;
}
var predicate = ur.GetPredicate(cqDTO, u, companyId);
var data = ur.GetByPredicate(predicate);
var col = new Collection<Dictionary<string, string>>();
data = data.OrderBy(x => x.DownTimeDate).ToList();
foreach (var item in data)
{
var dic = new Dictionary<string, string>();
dic.Add("DownTimeID", item.DownTimeID.ToString());
dic.Add("DepartmentID", item.DownTimeType.DepartmentID.ToString());
dic.Add("DepartmentName", item.DownTimeType.Department.DepartmentName);
dic.Add("DownTimeDate", item.DownTimeDate.ToShortDateString());
dic.Add("DownTimeTypeID", item.DownTimeTypeID.ToString());
dic.Add("DownTimeType", item.DownTimeType.DownTimeName.ToString());
dic.Add("Minutes", item.Minutes.ToString());
dic.Add("Note", item.DownTimeNote.ToString());
col.Add(dic);
var ufdic = new Dictionary<string, string>();
}
var dttr = new DownTimeTypeRepository();
var dtts = dttr.GetDownTimeTypesByDept(int.Parse(cqDTO.DepartmentID));
var col2 = new Collection<Dictionary<string, string>>();
foreach (var dtt in dtts)
{
var dic = new Dictionary<string, string>();
dic.Add("DownTimeTypeID", dtt.DownTimeTypeID.ToString());
dic.Add("DownTypeName", dtt.DownTimeName);
col2.Add(dic);
}
var retVal = new GenericDTO
{
Key = key,
ReturnData = col,
ReturnData1 = col2
};
return Request.CreateResponse(HttpStatusCode.OK, retVal);
}
var message = "validation failed";
return request.CreateResponse(HttpStatusCode.NotFound, message);
}
