private string GetCorrectedDate()
{
using (mazakdaqEntities1 db = new mazakdaqEntities1())
{
string correctedDateformat = "";
try
{
DateTime correctedDate = DateTime.Now;
var daytimings = db.tbldaytimings.Where(m => m.IsDeleted == 0).FirstOrDefault();
if (daytimings != null)
{
DateTime Start = Convert.ToDateTime(correctedDate.ToString("yyyy-MM-dd") + " " + daytimings.StartTime);
if (Start <= DateTime.Now)
{
correctedDate = DateTime.Now.Date;
}
else
{
correctedDate = DateTime.Now.AddDays(-1).Date;
}
}
correctedDateformat = correctedDate.ToString("yyyy-MM-dd");
}
catch (Exception ex)
{
}
// DateTime date = correctedDate.Date;
return(correctedDateformat);
}
}
public List <tblddl> ddllistmysql2()
{
var ddllistsqls = new List <tblddl>();
using (mazakdaqEntities1 db = new mazakdaqEntities1())
{
string correcteddate = GetCorrectedDate();
//DateTime newdate = Convert.ToDateTime(correcteddate);
ddllistsqls = db.tblddls.Where(m => m.CorrectedDate == correcteddate && m.IsCompleted == 1).OrderBy(m => m.DDLID).ToList();
}
return(ddllistsqls);
}
public List <tblddl> ddllistmysql1()
{
var ddllistsqls = new List <tblddl>();
using (mazakdaqEntities1 db = new mazakdaqEntities1())
{
string correcteddate = GetCorrectedDate();
//DateTime newdate = Convert.ToDateTime(correcteddate);
try
{
ddllistsqls = db.tblddls.Where(m => m.CorrectedDate == correcteddate).OrderBy(m => m.DDLID).ToList();
}
catch (Exception ex)
{
}
}
return(ddllistsqls);
}
