public IHttpActionResult GetUser(Login login)
{
try
{
DataSet dsUser = ExecuteStaticQuery.Get("STMTrackJobUser");
var acc = (from a in dsUser.Tables[0].AsEnumerable()
where a.Field <string>("UserName").ToString() == login.UserName &&
a.Field <string>("Password").ToString() == login.Password
select a).ToList();
if (login.UserName == "admin" && login.Password == "admin0001")
{
return(Json("OK"));
}
else if (acc.Count == 0)
{
return(Json("NOK"));
}
else
{
return(Json(acc));
}
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
public IHttpActionResult GetData()
{
List <TrackJob> trackJobList = new List <TrackJob>();
DataSet dataSet = ExecuteStaticQuery.Get("STMTrackJobQry");
foreach (DataTable table in dataSet.Tables)
{
foreach (DataRow row in table.Rows)
{
string bu = Enum.GetName(typeof(AxdEnum_STMMBU), row["STMMBU"]);
string typeroom = Enum.GetName(typeof(AxdEnum_STMTypeRoomJIS), row["STMTypeRoom"]);
string status = Enum.GetName(typeof(AxdEnum_STMTrackStatus), row["STMTrackStatus"]);
trackJobList.Add(new TrackJob
{
RecId = row["RecId"].ToString(),
TrackId = row["StmTrackId"].ToString(),
BU = bu,
CreateDate = Convert.ToDateTime(row["CreatedDate"]),
FinishDate = Convert.ToDateTime(row["FinishDate"]),
Name = row["Name"].ToString(),
ProjId = row["ProjId"].ToString(),
RefTrackId = row["RefTrackId"].ToString(),
Stage = row["ProjStage"].ToString(),
StartDate = Convert.ToDateTime(row["StartDate"]),
TypeRoom = typeroom,
Unit = Convert.ToInt32(row["Unit"]),
ProjAmount = Convert.ToDouble(row["ProjAmount"]),
TrackStatus = status
});
}
}
return(Json(trackJobList));
}
public IHttpActionResult GetDataLine(string username, string password)
{
List <TrackJobLine> trackJobList = new List <TrackJobLine>();
CultureInfo us = new CultureInfo("en-US");
try
{
DataSet dsTable = ExecuteStaticQuery.Get("STMTrackJob");
if (username == "admin" && password == "admin0001")
{
trackJobList = (from a in dsTable.Tables[0].AsEnumerable()
join b in dsTable.Tables[1].AsEnumerable()
on a.Field <string>("StmTrackId") equals b.Field <string>("StmTrackId")
where b.Field <DateTime>("ActEndDate").ToString("dd/MM/yyyy", us) == "01/01/1900"
orderby b.Field <DateTime>("PlanStartDate"), a.Field <string>("ProjId"), b.Field <string>("UserId")
select new TrackJobLine()
{
ProjId = a.Field <string>("ProjId").ToString(),
ProjName = a.Field <string>("Name").ToString(),
RecId = b.Field <Int64>("RecId").ToString(),
ActStartDate = b.Field <DateTime>("ActStartDate"),
ActEndDate = b.Field <DateTime>("ActEndDate"),
Delay = b.Field <int>("Delay"),
DelayPlan = b.Field <int>("DelayPlan"),
OperName = b.Field <string>("OperName").ToString(),
OperNo = b.Field <string>("OperNo").ToString(),
PlanDays = b.Field <int>("PlanDays"),
PlanEndDate = b.Field <DateTime>("PlanEndDate"),
PlanStartDate = b.Field <DateTime>("PlanStartDate"),
Remark = b.Field <string>("Remark").ToString(),
SideDesign = b.Field <string>("SideDesign").ToString(),
StmTrackId = b.Field <string>("StmTrackId").ToString(),
TypeDesign = b.Field <string>("TypeDesign").ToString(),
UserId = b.Field <string>("UserId").ToString(),
UserName = b.Field <string>("UserName").ToString(),
}).ToList();
}
else
{
trackJobList = (from a in dsTable.Tables[0].AsEnumerable()
join b in dsTable.Tables[1].AsEnumerable()
on a.Field <string>("StmTrackId") equals b.Field <string>("StmTrackId")
where b.Field <DateTime>("ActEndDate").ToString("dd/MM/yyyy", us) == "01/01/1900" &&
b.Field <string>("UserId").ToString() == username
orderby b.Field <DateTime>("PlanStartDate"), a.Field <string>("ProjId"), b.Field <string>("UserId")
select new TrackJobLine()
{
ProjId = a.Field <string>("ProjId").ToString(),
ProjName = a.Field <string>("Name").ToString(),
RecId = b.Field <Int64>("RecId").ToString(),
ActStartDate = b.Field <DateTime>("ActStartDate"),
ActEndDate = b.Field <DateTime>("ActEndDate"),
Delay = b.Field <int>("Delay"),
DelayPlan = b.Field <int>("DelayPlan"),
OperName = b.Field <string>("OperName").ToString(),
OperNo = b.Field <string>("OperNo").ToString(),
PlanDays = b.Field <int>("PlanDays"),
PlanEndDate = b.Field <DateTime>("PlanEndDate"),
PlanStartDate = b.Field <DateTime>("PlanStartDate"),
Remark = b.Field <string>("Remark").ToString(),
SideDesign = b.Field <string>("SideDesign").ToString(),
StmTrackId = b.Field <string>("StmTrackId").ToString(),
TypeDesign = b.Field <string>("TypeDesign").ToString(),
UserId = b.Field <string>("UserId").ToString(),
UserName = b.Field <string>("UserName").ToString(),
}).ToList();
}
return(Json(trackJobList));
}
catch (Exception ex)
{
return(Json(ex.Message));
}
}
