public ActionResult Table(string id = "")
{
if (! String.IsNullOrWhiteSpace(id))
{
string last_update = (from u in this._db.recsys_users
orderby u.last_update descending
select u.last_update).FirstOrDefault().ToString();
return Content(String.IsNullOrWhiteSpace(last_update) ? "null" : last_update);
}
else
{
Grid _grid = new Grid();
String sql = _grid.sql("users");
ArrayList table = Common.query(this._db.ExecuteStoreQuery<recsys_users>(sql));
Hashtable result = _grid.get(table);
if (((ArrayList)result["rows"]).Count > 0)
{
Hashtable type = this.getType();
Hashtable user_group = this.getUserGroup();
Hashtable country = this.getCountry();
Dictionary<string, string> grade = this.getGrade();
ArrayList sort = new ArrayList();
string path = Server.MapPath("~/") + "/";
string subContractor_userGroup_name = UserGroup.SubCon;
string subContractor_id = (from o in this._db.recsys_option
where o.type_code == "UG" && o.active == true && o.name == subContractor_userGroup_name
select o.value).FirstOrDefault();
foreach (Hashtable rs in (ArrayList)result["rows"])
{
Hashtable hash = new Hashtable();
string filePath = "Upload/users/" + rs["id"] + "/photo/";
string realPath = path + filePath;
ArrayList filelist = Common.fileList(realPath, filePath);
Boolean subcon = rs["user_group"].ToString() == subContractor_id;
object user_group_id = rs["user_group"];
object user_group_name = user_group_id != null ? user_group[user_group_id.ToString()] : string.Empty;
object grade_name = rs["grade"] != null ? grade[rs["grade"].ToString()] : string.Empty;
object country_id = rs["country_id"];
object country_name = country_id != null ? country[country_id.ToString()] : string.Empty;
hash["id"] = rs["id"];
hash["cell"] = new ArrayList {
rs["id"],
rs["name"],
type[rs["type_id"].ToString()],
subcon ? "--" : type[rs["type_id"].ToString()],
user_group_name,
rs["center"],
subcon ? "--" : rs["center"],
grade_name,
grade_name,
rs["employee_number"],
rs["username"],
subcon ? "--" : rs["username"],
"",
"",
"",
country_name,
country_name,
rs["phone_number"],
rs["email"],
(filelist.Count > 0 ? "<img src=\"/img.ashx?width=53&height=53&bg=ffffff&file=" + ((String[]) filelist[0])[0] + "\" alt=\"" + ((String[]) filelist[0])[1] + "\" style=\"border: 1px solid #d4d4d4;\" />" : ""),
"<span class=\"status-" + (Convert.ToInt32(rs["status"]) == 1 ? "on" : "off") + "\" title=\"" + this._status[rs["status"].ToString()] + "\"></span>",
this._status[rs["status"].ToString()],
Common.to_date("dd-MM-yyyy hh:mm:ss", rs["create_date"]),
Common.lastUpdate(rs["last_update"], rs["update_user_id"])
};
sort.Add(hash);
}
result["rows"] = sort;
}
return Content(Common.json_encode(result));
}
}
public ActionResult Items_Template(string id = "")
{
if (!String.IsNullOrWhiteSpace(id))
{
string last_update = (from it in this._db.recsys_quotation_items_template
orderby it.last_update descending
select it.last_update).FirstOrDefault().ToString();
return Content(String.IsNullOrWhiteSpace(last_update) ? "null" : last_update);
}
else
{
Grid _grid = new Grid();
String sql = _grid.sql("quotation_items_template");
ArrayList table = Common.query(this._db.ExecuteStoreQuery<recsys_quotation_items_template>(sql));
Hashtable result = _grid.get(table);
if (((ArrayList)result["rows"]).Count > 0)
{
ArrayList sort = new ArrayList();
foreach (Hashtable rs in (ArrayList)result["rows"])
{
Hashtable hash = new Hashtable();
hash["id"] = rs["id"];
hash["cell"] = new ArrayList {
rs["id"],
rs["code"],
rs["detail"],
rs["detail2"],
rs["price"],
Common.lastUpdate(rs["last_update"], rs["update_user_id"])
};
sort.Add(hash);
}
result["rows"] = sort;
}
return Content(Common.json_encode(result));
}
}
public ActionResult Table(string id = "")
{
if (!String.IsNullOrWhiteSpace(id))
{
string last_update = (from s in this._db.recsys_supplier
orderby s.last_update descending
select s.last_update).FirstOrDefault().ToString();
return Content(String.IsNullOrWhiteSpace(last_update) ? "null" : last_update);
}
else
{
Grid _grid = new Grid();
String sql = _grid.sql("supplier");
ArrayList table = Common.query(this._db.ExecuteStoreQuery<recsys_supplier>(sql));
Hashtable result = _grid.get(table);
if (((ArrayList)result["rows"]).Count > 0)
{
ArrayList sort = new ArrayList();
foreach (Hashtable rs in (ArrayList)result["rows"])
{
Hashtable hash = new Hashtable();
hash["id"] = rs["id"];
hash["cell"] = new ArrayList {
rs["id"],
rs["name"],
"<span class=\"status-" + (Convert.ToInt32(rs["status"]) == 1 ? "on" : "off") + "\" title=\"" + this._status[rs["status"].ToString()] + "\"></span>",
this._status[rs["status"].ToString()],
Common.lastUpdate(rs["last_update"], rs["update_user_id"])
};
sort.Add(hash);
}
result["rows"] = sort;
}
return Content(Common.json_encode(result));
}
}
public ActionResult Jobs(string id = "")
{
string order_id = Common.doPost("order_id");
if (!String.IsNullOrWhiteSpace(id))
{
String sql = Common.doSql("SELECT j.last_update FROM {p}_job AS j LEFT JOIN {p}_relate AS r ON r.id2 = j.id WHERE r.table1 = 'order' AND r.table2 = 'job' AND r.id1 = '" + order_id + "' ORDER BY j.last_update DESC");
string last_update = this._db.ExecuteStoreQuery<DateTime>(sql).FirstOrDefault().ToString();
return Content(String.IsNullOrWhiteSpace(last_update) ? "null" : last_update);
}
else
{
Grid _grid = new Grid();
String sql = Common.doSql(_grid.sql("", "SELECT j.* FROM {p}_job AS j LEFT JOIN {p}_relate AS r ON r.id2 = j.id WHERE r.table1 = 'order' AND r.table2 = 'job' AND r.id1 = '" + order_id + "'"));
ArrayList table = Common.query(this._db.ExecuteStoreQuery<recsys_job>(sql));
Hashtable result = _grid.get(table);
if (((ArrayList)result["rows"]).Count > 0)
{
ArrayList sort = new ArrayList();
foreach (Hashtable rs in (ArrayList)result["rows"])
{
Hashtable hash = new Hashtable();
hash["id"] = rs["id"];
hash["cell"] = new ArrayList {
rs["id"],
rs["detail1"],
rs["detail2"],
Common.lastUpdate(rs["last_update"], rs["update_user_id"])
};
sort.Add(hash);
}
result["rows"] = sort;
}
return Content(Common.json_encode(result));
}
}
public ActionResult Parts_Table(string id = "")
{
int order_id = Convert.ToInt32(Common.doPost("order_id"));
if (!String.IsNullOrWhiteSpace(id))
{
String sql = Common.doSql("SELECT p.last_update FROM {p}_parts AS p LEFT JOIN {p}_relate AS r ON r.id1 = p.id WHERE r.table1 = 'parts' AND r.table2 = 'order' AND r.id2 = '" + order_id + "' ORDER BY p.last_update DESC");
string last_update = this._db.ExecuteStoreQuery<DateTime>(sql).FirstOrDefault().ToString();
return Content(String.IsNullOrWhiteSpace(last_update) ? "null" : last_update);
}
else
{
Grid _grid = new Grid();
String sql = Common.doSql(_grid.sql("", "SELECT p.*, s.name as supplier_name FROM {p}_parts AS p LEFT JOIN {p}_supplier AS s ON p.supplier_id = s.id LEFT JOIN {p}_relate AS r ON r.id1 = p.id", "r.table1 = 'parts' AND r.table2 = 'order' AND r.id2 = '" + order_id + "'"));
ArrayList table = Common.query(this._db.ExecuteStoreQuery<parts>(sql));
Hashtable result = _grid.get(table);
if (((ArrayList)result["rows"]).Count > 0)
{
ArrayList sort = new ArrayList();
foreach (Hashtable rs in (ArrayList)result["rows"])
{
Hashtable hash = new Hashtable();
hash["id"] = rs["id"];
hash["cell"] = new ArrayList {
rs["id"],
rs["name"],
rs["invoice"],
rs["price1"],
rs["price2"],
rs["detail"],
rs["supplier_name"],
rs["supplier_id"],
Common.to_date("dd-MM-yyyy", rs["account_date"]),
Common.to_date("dd-MM-yyyy", rs["account_date"]),
"<span class=\"status-" + (Convert.ToInt32(rs["status"]) == 1 ? "on" : "off") + "\" title=\"" + this._status[rs["status"].ToString()] + "\"></span>",
this._status[rs["status"].ToString()],
rs["remark"],
Common.lastUpdate(rs["last_update"], rs["update_user_id"])
};
sort.Add(hash);
}
result["rows"] = sort;
}
return Content(Common.json_encode(result));
}
}
public ActionResult Table(string id = "")
{
if (!String.IsNullOrWhiteSpace(id))
{
string last_update = (from g in this._db.recsys_group
orderby g.last_update descending
select g.last_update).FirstOrDefault().ToString();
return Content(String.IsNullOrWhiteSpace(last_update) ? "null" : last_update);
}
else
{
Grid _grid = new Grid();
String sql = Common.doSql(_grid.sql("", "SELECT g.* FROM {p}_group AS g LEFT JOIN {p}_users AS u ON g.supervisor_id = u.id"));
ArrayList table = Common.query(this._db.ExecuteStoreQuery<recsys_group>(sql));
Hashtable result = _grid.get(table);
if (((ArrayList)result["rows"]).Count > 0)
{
Member _member = new Member("users");
ArrayList sort = new ArrayList();
foreach (Hashtable rs in (ArrayList)result["rows"])
{
sql = Common.doSql("SELECT u.* FROM {p}_relate AS r LEFT JOIN {p}_users AS u ON r.id2 = u.id WHERE r.id1 = '" + rs["id"] + "' AND r.table1 = 'group' AND r.table2 = 'users' ORDER BY u.name ASC");
ArrayList engineer = Common.query(this._db.ExecuteStoreQuery<recsys_users>(sql));
ArrayList arr1 = new ArrayList();
ArrayList arr2 = new ArrayList();
Hashtable supervisor = _member.get(rs["supervisor_id"].ToString(), "id");
if (engineer.Count > 0)
{
foreach (Hashtable item in engineer)
{
arr1.Add(item["name"]);
arr2.Add(item["id"]);
}
}
Hashtable hash = new Hashtable();
hash["id"] = rs["id"];
hash["cell"] = new ArrayList {
rs["id"],
rs["name"],
supervisor["name"],
rs["supervisor_id"],
string.Join(", ", arr1.ToArray()),
string.Join(",", arr2.ToArray()),
"<span class=\"status-" + (Convert.ToInt32(rs["status"]) == 1 ? "on" : "off") + "\" title=\"" + this._status[rs["status"].ToString()] + "\"></span>",
this._status[rs["status"].ToString()],
Common.lastUpdate(rs["last_update"], rs["update_user_id"])
};
sort.Add(hash);
}
result["rows"] = sort;
}
return Content(Common.json_encode(result));
}
}