public ActionResult Details(string id, string aduan)
{
string noAduan = aduan;
JobDistribution jd = JobDistribution.Get(noAduan);
return(View(jd));
}
public static List<JobDistribution> GetList()
{
SQLHelper helper = new SQLHelper();
string sqlString = "select Id, Nama, NoAduan, CreatedTime, ArrivalTime, AcceptedTime, ClosedTime, [Location] from JobDistribution ";
DataTable dt = helper.QueryTable(sqlString);
List<JobDistribution> listJd = new List<JobDistribution>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
JobDistribution jd = ConvertToModel(dr);
listJd.Add(jd);
}
}
return listJd;
}
public static JobDistribution Get(string NoAduan)
{
SQLHelper helper = new DataContext.SQLHelper();
string sqlString = "select Id, NoAduan, CreatedTime, Nama, AcceptedTime, ArrivalTime, ClosedTime, [Location] from JobDistribution "
+ "WHERE NoAduan = @NoAduan;";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@NoAduan", NoAduan)
};
DataTable dt = helper.QueryTable(sqlString, parameter);
JobDistribution jd = new JobDistribution();
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
jd = ConvertToModel(dr);
}
return jd;
}
private static JobDistribution ConvertToModel(DataRow dr)
{
JobDistribution jd = new JobDistribution();
jd.Id = Convert.ToInt32(dr["Id"]);
jd.Location = dr["Location"].ToString();
jd.Nama = dr["Nama"].ToString();
jd.NoAduan = dr["NoAduan"].ToString();
if (dr["CreatedTime"] != DBNull.Value)
jd.TimeStamp.CreatedTime = Convert.ToDateTime(dr["CreatedTime"]);
if (dr["AcceptedTime"] != DBNull.Value)
jd.TimeStamp.AcceptedTime = Convert.ToDateTime(dr["AcceptedTime"]);
if (dr["ArrivalTime"] != DBNull.Value)
jd.TimeStamp.ArrivalTime = Convert.ToDateTime(dr["ArrivalTime"]);
if (dr["ClosedTime"] != DBNull.Value)
jd.TimeStamp.ClosedTime = Convert.ToDateTime(dr["ClosedTime"]);
return jd;
}
// GET: Job
public ActionResult Index()
{
//EDIT job controller in Master
ViewBag.Dropdown = JobDistribution.GetList();
return(View());
}
