public static string GetAllDepartmentJSON(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
//Add into Query Statment
var Query = (from c in dc.Mst_DepartmentViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.DepartmentName
select new Mst_DepartmentView
{
DepartmentID = c.DepartmentID,
DepartmentName = c.DepartmentName,
NotifyEmail = c.NotifyEmail,
Protocol = c.Protocol,
Description = c.Description,
Remark = c.Remark,
}).ToList();
string return_str = new JavaScriptSerializer().Serialize(Query);
return(return_str);
}
public static List <SYS_UserView> GetAllUser(string search_text, string org_id, string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
return((from c in dc.SYS_UserViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID)) &&
((search_text == "") ||
(search_text != "" && (
c.UserID.Contains(search_text) ||
c.UserCode.Contains(search_text) ||
c.UserName.Contains(search_text) ||
c.Email.Contains(search_text)
)))
orderby c.UserName
select c).ToList());
}
public static string GetAllPositionJSON(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Add into Query Statment
var Query = (from c in dc.Mst_PositionViews
where c.Active == true
orderby c.PositionName
select new Mst_PositionView
{
PositionID = c.PositionID,
PositionName = c.PositionName,
PositionCode = c.PositionCode,
Protocol = c.Protocol,
Description = c.Description,
Remark = c.Remark,
}).ToList();
string return_str = new JavaScriptSerializer().Serialize(Query);
return(return_str);
}
public static string GetAllUserJson(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
SYS_UserView current_user = GetUser(RequestID, RequestID);
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
List <SYS_UserView> user_list = (from c in dc.SYS_UserViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.UserName
select new SYS_UserView
{
UserID = c.UserID,
UserCode = c.UserCode,
UserName = c.UserName,
RoleName = c.RoleName,
Email = c.Email,
PositionName = c.PositionName,
DepartmentName = c.DepartmentName
}).ToList();
string return_str = new JavaScriptSerializer().Serialize(user_list);
return(return_str);
}
public static string GetAllRequestJSON(string search_text, string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
List <MET_RequestView> the_requestlist = (from c in dc.MET_RequestViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID)) &&
((search_text == "") ||
(search_text != "" && (
c.RequestNo.Contains(search_text) ||
c.RequestStatus.Contains(search_text) ||
c.RequestTitle.Contains(search_text) ||
c.RequestType.Contains(search_text) ||
c.Description.Contains(search_text) ||
c.Remark.Contains(search_text) ||
c.DepartmentName.Contains(search_text))))
orderby c.CreatedOn descending
select c
).ToList();
var lists = new Newtonsoft.Json.Linq.JArray() as dynamic;
foreach (var row in the_requestlist)
{
dynamic request = new Newtonsoft.Json.Linq.JObject();
request.RequestID = row.RequestID;
request.DepartmentID = row.DepartmentID;
request.RequestType = row.RequestType;
request.RequestNo = row.RequestNo;
request.RequestUserName = row.RequestUserName;
request.RequestTitle = row.RequestTitle;
request.RequestStatus = row.RequestStatus;
request.RequestOn = row.RequestOn;
request.DepartmentName = row.DepartmentName;
request.ApprovalStatus = row.ApprovalStatus;
lists.Add(request);
}
return(lists.ToString());
}
public static string ChangeCombineDecision(string agendaID, string meetingreq_id, string edited_decision, string user_id)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, user_id, "update"))
{
throw new Exception("No Access.");
}
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
try
{
MET_Request request_record = new MET_Request();
request_record = (from c in dc.MET_Requests where c.RequestID == meetingreq_id && c.Active == true select c).FirstOrDefault();
if (request_record == null)
{
return("Error~We can't find");
}
request_record.CombineDecision = edited_decision;
request_record.ModifiedOn = DateTime.Now;
request_record.ModifiedBy = user_id;
request_record.LastAction = Guid.NewGuid().ToString();
dc.SubmitChanges(ConflictMode.ContinueOnConflict);
#region get all request
SYS_UserView current_user = Controller_User.GetUser(user_id, user_id);
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, user_id, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
List <MET_RequestView> reqs_list = (from c in dc.MET_RequestViews
where c.Active == true && c.AgendaID == agendaID && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.Protocol ascending
select c).ToList();
string return_str = new JavaScriptSerializer().Serialize(reqs_list);
#endregion
return("Success~" + return_str);
}
catch (ChangeConflictException ex)
{
return("Success~");
}
}
public static List <Mst_PositionView> GetAllPosition(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
return((from c in dc.Mst_PositionViews
where c.Active == true
orderby c.PositionName
select c).ToList());
}
public static string GetAllAgendaJSON(string search_text, string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
List <MET_AgendaView> the_agendalist = (from c in dc.MET_AgendaViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID)) &&
((search_text == "") ||
(search_text != "" && (
c.AgendaNo.Contains(search_text) ||
c.AgendaRemark.Contains(search_text) ||
c.AgendaStatus.Contains(search_text) ||
c.CUserCode.Contains(search_text) ||
c.MUserCode.Contains(search_text)
)))
orderby c.CreatedOn descending
select c
).ToList();
var lists = new Newtonsoft.Json.Linq.JArray() as dynamic;
foreach (var row in the_agendalist)
{
dynamic agenda = new Newtonsoft.Json.Linq.JObject();
agenda.AgendaID = row.AgendaID;
agenda.AgendaNo = row.AgendaNo;
agenda.AgendaDate = row.AgendaDate.ToString();
agenda.AgendaRemark = row.AgendaRemark;
agenda.AgendaStatus = row.AgendaStatus;
lists.Add(agenda);
}
return(lists.ToString());
}
public static string LoadRequestByAgendaID(string agendaID, string user_id)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, user_id, "read"))
{
throw new Exception("No Access.");
}
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
try
{
#region get all request
//Security Check For AllDepartment
SYS_UserView current_user = Controller_User.GetUser(user_id, user_id);
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, user_id, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
List <MET_RequestView> reqs_list = (from c in dc.MET_RequestViews
where c.Active == true && c.AgendaID == agendaID && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.Protocol ascending
select c).ToList();
string return_str = new JavaScriptSerializer().Serialize(reqs_list);
#endregion
return("Success~" + return_str);
}
catch (Exception ex)
{
return("Success~");
}
}
public static List <Mst_DepartmentView> GetAllDepartment(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
LINQ_MasterDataContext dc = new LINQ_MasterDataContext();
return((from c in dc.Mst_DepartmentViews
where c.Active == true && (departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.DepartmentName descending
select c).ToList());
}
public static string GetAllUserRoleJSON(string RequestID)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
//Get current user info
SYS_UserView current_user = Controller_User.GetUser(RequestID, RequestID);
//Add into Query Statment
var Query = (from c in dc.SYS_UserRoleViews
where c.Active == true
orderby c.RoleName
select new SYS_UserRoleView
{
RoleID = c.RoleID,
RoleCode = c.RoleCode,
RoleName = c.RoleName,
}).ToList();
string return_str = new JavaScriptSerializer().Serialize(Query);
return(return_str);
}
public static string SaveUser(
string record_id, string user_id, string user_code, string user_name,
string user_email, string password, string contactinfo, string note, string role_id, string dep_id, string pos_id,
string RequestID)
{
try
{
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
SYS_User the_record = new SYS_User();
SYS_UserView the_view = new SYS_UserView();
if (record_id == "" || record_id == null)
{
the_record = (from c in dc.SYS_Users where c.UserCode == user_code && c.Active == true && ((user_id == "") || (user_id != "" && c.UserID != user_id)) select c).FirstOrDefault();
if (the_record == null)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "create"))
{
throw new Exception("No Access.");
}
string encryptpassword = Controller_TextEncryption.Encrypt(password, "");
the_record = new SYS_User()
{
Password = encryptpassword,
LastLogin = DateTime.Now,
CreatedBy = user_id,
CreatedOn = DateTime.Now,
Active = true,
UserID = Guid.NewGuid().ToString(),
LastAction = Guid.NewGuid().ToString(),
Ref_ID = "",
IsLoggedIn = true,
Ref_Type = "",
OrgID = "",
};
dc.SYS_Users.InsertOnSubmit(the_record);
}
else
{
return("DuplicateCode~");
}
}
else
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "update"))
{
throw new Exception("No Access.");
}
the_record = (from c in dc.SYS_Users where c.UserID == record_id select c).FirstOrDefault();
if (the_record == null)
{
throw new Exception("System cannot find the record");
}
}
the_record.ModifiedBy = user_id;
the_record.ModifiedOn = DateTime.Now;
the_record.LastAction = Guid.NewGuid().ToString();
the_record.UserName = user_name;
the_record.UserCode = user_code;
the_record.Email = user_email;
the_record.ContactInfo = contactinfo;
the_record.Note = note;
the_record.RoleID = role_id;
the_record.DepartmentID = dep_id;
the_record.PositionID = pos_id;
dc.SubmitChanges();
return("Success~" + the_record.UserID);
}
catch (Exception ex)
{
return("Error~" + ex.Message);
}
}
public static List <Object> GetAllOrganizationWithPagination(string search_text, string search_org, string RequestID, string PageNoString)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess(AccessProgramCode, RequestID, "read"))
{
throw new Exception("No Access.");
}
//Check Agent Access
LINQ_SystemDataContext dc_system = new LINQ_SystemDataContext();
SYS_UserView the_user = (from c in dc_system.SYS_UserViews where c.UserID == RequestID select c).FirstOrDefault();
if (the_user == null)
{
throw new Exception("System cannot find the user");
}
int pageNo = 0; int.TryParse(PageNoString, out pageNo);
//Get Skip Count
int skip_count = (pageNo - 1) * RecordCountPerPage;
LINQ_SystemDataContext dc = new LINQ_SystemDataContext();
SYS_Organization org = new SYS_Organization();
//Add into Query Statment
var Query = (from c in dc.SYS_OrganizationViews
where c.Active == true &&
((search_text == "") ||
(search_text != "" && (
c.LastAction.Contains(search_text) ||
c.OrgName.Contains(search_text) ||
c.OrgCode.Contains(search_text) ||
c.UserCount.Contains(search_text) ||
c.OrgPlan.Contains(search_text)
))) &&
((search_org == "") ||
(search_org != "" && (
c.LastAction.Contains(search_org) ||
c.OrgName.Contains(search_org) ||
c.OrgCode.Contains(search_org) ||
c.UserCount.Contains(search_org) ||
c.OrgPlan.Contains(search_org)
)))
select c).OrderByDescending(x => x.OrgName);
//Get Total Record Count
int TotalCount = Query.Count();
//Get Total Number of Page
int TotalPage = (TotalCount / RecordCountPerPage) + (TotalCount % RecordCountPerPage == 0 ? 0 : 1);
List <Object> result = new List <object>();
//Add overall pagination info on Index 0
string previous_button = "y";
if (pageNo == 1 || TotalPage == 1)
{
previous_button = "n";
}
string next_button = "y";
if (pageNo == TotalPage)
{
next_button = "n";
}
if (TotalPage == 1)
{
previous_button = "n"; next_button = "n";
}
result.Add(TotalCount.ToString() + "~" + TotalPage.ToString() + "~" + pageNo.ToString() + "~" + previous_button + "~" + next_button);
//Add Real Record Data from Index 1
result.AddRange(new List <Object>(
Query
.Skip(skip_count).Take(RecordCountPerPage) // Add Skip and Take Function
.ToList()));
return(result);
}
public static string AddRequestToAgenda(string agendaID, string user_id)
{
//Security Check
if (!Controller_User_Access.CheckProgramAccess("MeetingRequest", user_id, "update"))
{
throw new Exception("No Access.");
}
SYS_UserView current_user = Controller_User.GetUser(user_id, user_id);
LINQ_MeetingDataContext dc = new LINQ_MeetingDataContext();
try
{
MET_Agenda agenda_record = new MET_Agenda();
string return_str = "";
agenda_record = (from c in dc.MET_Agendas where c.AgendaID == agendaID && c.Active == true select c).FirstOrDefault();
if (agenda_record == null)
{
return("Error~We can't find");
}
#region Request in agenda
//Security Check For AllDepartment
string departmentID = "";
if (!Controller_User_Access.CheckProgramAccess("MeetingRequest", user_id, "allDepartment"))
{
departmentID = current_user.DepartmentID;
}
List <MET_Request> req_list = new List <MET_Request>();
req_list = (from c in dc.MET_Requests where c.ApprovalStatus == "Approved" &&
(departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID)) &&
c.Active == true select c).ToList();
if (req_list.Count > 0)
{
foreach (MET_Request i in req_list)
{
i.AgendaID = agenda_record.AgendaID;
i.RequestStatus = "Agenda";
i.ModifiedBy = user_id;
i.ModifiedOn = DateTime.Now;
}
dc.SubmitChanges(ConflictMode.ContinueOnConflict);
#region get all request
List <MET_RequestView> reqs_list = (from c in dc.MET_RequestViews
where c.Active == true && c.AgendaID == agendaID &&
(departmentID == "" || (departmentID != "" && c.DepartmentID == departmentID))
orderby c.Protocol ascending
select c).ToList();
return_str = new JavaScriptSerializer().Serialize(reqs_list);
#endregion
return("Success~" + return_str);
}
else
{
return("Error~" + "There is no approved requests!");
}
#endregion
}
catch (ChangeConflictException ex)
{
return("Success~");
}
}
