public async Task <IList <ModelSelectOption> > GetAllProjectNumberC12Async()
{
string sql = "SELECT project_number, project_name_thai FROM Doc_Process WHERE doc_process_to='C12'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["project_number"].ToString();
item.label = reader["project_number"].ToString() + " : " + reader["project_name_thai"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IList <ModelSelectOption> > GetAllRegisterUserByCharacterAsync(string character)
{
string sql = "SELECT register_id, full_name FROM RegisterUser WHERE IsActive='1' ";
string condition = (!string.IsNullOrEmpty(character) ? "AND Character='" + character + "'" : "");
sql += condition + " ORDER BY full_name ASC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(reader["register_id"].ToString()));
item.label = reader["full_name"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IList <ModelSelectOption> > GetAllProjectHeadAsync()
{
string sql = "SELECT A.project_head, B.full_name " +
"FROM Transaction_Document A " +
"INNER JOIN RegisterUser B " +
"ON A.project_head = B.register_id " +
"GROUP BY A.project_head, B.full_name " +
"ORDER BY full_name ASC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(reader["project_head"].ToString()));
item.label = reader["full_name"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
// ระเบียบวาระที่ 4 ------------------------------------------------------------------------------
public async Task <ModelMenuR1_InterfaceData> MenuR1InterfaceDataAsync(string RegisterId)
{
ModelMenuR1_InterfaceData resp = new ModelMenuR1_InterfaceData();
resp.ListMeetingId = new List <ModelSelectOption>();
resp.ListMeetingId = await GetAllMeetingIdAsync();
ModelSelectOption all_meeting = new ModelSelectOption()
{
value = "", label = "เลือก..."
};
resp.ListMeetingId.Add(all_meeting);
resp.ListMeetingType = await GetAllMeetingTypeAsync();
ModelSelectOption all_meeting_type = new ModelSelectOption()
{
value = "", label = "เลือก..."
};
resp.ListMeetingType.Add(all_meeting_type);
resp.ListReportData = await GetAllReportHistoryDataR1Async(null);
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M019");
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllMeetingIdAsync()
{
string sql = "SELECT TOP(5) doc_id as meeting_id, " +
"('วันที่ ' + CONVERT(VARCHAR, meeting_date, 103) + " +
"' ครั้งที่ ' + CONVERT(VARCHAR, meeting_round) + " +
"' ปี ' + CONVERT(VARCHAR, year_of_meeting)) as meeting_name " +
"FROM Doc_MenuC3 " +
"ORDER BY meeting_id DESC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["meeting_id"].ToString();
item.label = reader["meeting_name"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IList <ModelSelectOption> > GetAllApprovalTypeAsync()
{
string sql = "SELECT id, (name_thai + ' ' + name_thai_sub) AS approval_name FROM MST_ApprovalType ORDER BY id ASC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["id"].ToString();
item.label = reader["approval_name"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelMenuB1_InterfaceData> MenuB1InterfaceDataAsync(string userid, string username)
{
ModelMenuB1_InterfaceData resp = new ModelMenuB1_InterfaceData();
resp.ListProjectHead = new List <ModelSelectOption>();
resp.ListProjectHead = await GetAllProjectHeadAsync();
ModelSelectOption all_project_head = new ModelSelectOption();
all_project_head.value = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes("all"));
all_project_head.label = "ทั้งหมด";
resp.ListProjectHead.Add(all_project_head);
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYearOfProject = new List <ModelSelectOption>();
resp.defaultyear = thai_year;
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.ListYearOfProject.Add(year_current);
ModelCountOfYear round_of_year = new ModelCountOfYear();
round_of_year = await _IDocMeetingRoundRepository.GetMeetingRoundOfProjectAsync(resp.defaultyear);
resp.defaultround = round_of_year.count;
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(userid, "M010");
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllAcronymsAsync()
{
string sql = "SELECT * FROM MST_Acronyms ";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["id"].ToString();
item.label = reader["name_thai"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelMenuB2_InterfaceData> MenuB2InterfaceDataAsync(string RegisterId)
{
ModelMenuB2_InterfaceData resp = new ModelMenuB2_InterfaceData();
resp.ListLabNumber = new List <ModelSelectOption>();
resp.ListLabNumber = await GetAllLabNumberAsync();
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYearOfProject = new List <ModelSelectOption>();
resp.defaultyear = thai_year;
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.ListYearOfProject.Add(year_current);
//for (int i = 1; i < 5; i++)
//{
// ModelSelectOption year_next = new ModelSelectOption();
// year_next.value = (thai_year + i).ToString();
// year_next.label = (thai_year + i).ToString();
// resp.ListYearOfProject.Add(year_next);
//}
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M010");
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllLabNumberAsync()
{
string sql = "SELECT doc_id, (room_number + ' : ' + ISNULL(labothername,'') + ' ' + faculty_laboratory) as name_thai FROM Doc_MenuA2 WHERE IsUsed=0 ";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["doc_id"].ToString();
item.label = reader["name_thai"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelMenuD2_InterfaceData> MenuD2InterfaceDataAsync(string RegisterId)
{
ModelMenuD2_InterfaceData resp = new ModelMenuD2_InterfaceData();
resp.ListProjectNumber = new List <ModelSelectOption>();
int thai_year = CommonData.GetYearOfPeriod();
resp.defaultyear = thai_year;
resp.listYearOfMeeting = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.listYearOfMeeting.Add(year_current);
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M021");
if (resp.UserPermission != null && resp.UserPermission.alldata == true)
{
resp.ListProjectNumber = await GetAllProjectForD2Async("", "D2");
}
else
{
resp.ListProjectNumber = await GetAllProjectForD2Async(RegisterId, "D2");
}
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllProjectForD2Async(string AssignerCode, string DocProcess)
{
string sql = "SELECT * FROM [dbo].[Doc_Process] " +
"WHERE project_type='PROJECT' AND doc_process_to='" + DocProcess + "' AND revert_type='InClose.D2'";
if (!string.IsNullOrEmpty(AssignerCode))
{
sql += " AND project_by='" + Encoding.UTF8.GetString(Convert.FromBase64String(AssignerCode)) + "' ";
}
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["project_number"].ToString();
item.label = reader["project_number"].ToString() + " : " + reader["project_name_thai"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IList <ModelSelectOption> > GetAllDownloadFileByProjectIdAsync(string project_Id)
{
string sql = "SELECT file1name,file2name,file3name,file4name,file5name FROM Doc_MenuA1 WHERE doc_id='" + project_Id + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
if (!string.IsNullOrEmpty(reader["file1name"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["file1name"].ToString();
item.label = "แบบเสนอเพื่อขอรับการพิจารณารับรองด้านความปลอดภัย";
e.Add(item);
}
if (!string.IsNullOrEmpty(reader["file2name"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["file2name"].ToString();
item.label = "โครงการวิจัยฉบับสมบูรณ์";
e.Add(item);
}
if (!string.IsNullOrEmpty(reader["file3name"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["file3name"].ToString();
item.label = "เอกสารชี้แจงรายละเอียดของเชื้อที่ใช้/แบบฟอร์มข้อตกลงการใช้ตัวอย่างชีวภาพ";
e.Add(item);
}
if (!string.IsNullOrEmpty(reader["file4name"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["file4name"].ToString();
item.label = "หนังสือรับรองและอนุมัติให้ใช้สถานะที่";
e.Add(item);
}
if (!string.IsNullOrEmpty(reader["file5name"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["file5name"].ToString();
item.label = "อื่นๆ";
e.Add(item);
}
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelMenuHome2_InterfaceData> MenuHome2InterfaceDataAsync(string RegisterId)
{
ModelMenuHome2_InterfaceData resp = new ModelMenuHome2_InterfaceData();
var cultureInfo = new CultureInfo("th-TH");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYear = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.ListYear.Add(year_current);
for (int i = 1; i < 5; i++)
{
ModelSelectOption year_next = new ModelSelectOption();
year_next.value = (thai_year + i).ToString();
year_next.label = (thai_year + i).ToString();
resp.ListYear.Add(year_next);
}
ModelSelectOption all_year = new ModelSelectOption();
all_year.value = "All";
all_year.label = "เลือก...";
resp.ListYear.Add(all_year);
//------------------------------------------------------------------------------------------
resp.ListAcceptType = new List <ModelSelectOption>();
ModelSelectOption accept_type_1 = new ModelSelectOption();
accept_type_1.value = "1";
accept_type_1.label = "แบบประเมินเบื้องต้นสำหรับห้องปฏิบัติการ";
resp.ListAcceptType.Add(accept_type_1);
ModelSelectOption accept_type_2 = new ModelSelectOption();
accept_type_2.value = "2";
accept_type_2.label = "แบบประเมินเบื้องต้นสำหรับโรงเรือนทดลองสำหรับพืชดัดแปลงพันธุกรรม";
resp.ListAcceptType.Add(accept_type_2);
ModelSelectOption accept_type_all = new ModelSelectOption();
accept_type_all.value = "ALL";
accept_type_all.label = "เลือก...";
resp.ListAcceptType.Add(accept_type_all);
//------------------------------------------------------------------------------------------
resp.ListReportData = new List <ModelMenuHome2ReportData>();
resp.ListReportData = await GetAllReportDataHome2Async(null);
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M002");
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllProjectLabAsync(string AssignerCode, string DocProcess)
{
string sql = "SELECT A.project_number, " +
"A.project_name_thai, A.project_name_eng, B.board_code_array " +
"FROM [dbo].[Doc_Process] A " +
"INNER JOIN [dbo].[Doc_MenuC1_2] B " +
"ON A.project_number = B.[project_number] " +
"WHERE A.project_type='LAB' AND doc_process_to='" + DocProcess + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
List <ModelSelectOption> item_list = JsonConvert.DeserializeObject <List <ModelSelectOption> >(reader["board_code_array"].ToString());
if (item_list != null && item_list.Count > 0)
{
if (string.IsNullOrEmpty(AssignerCode))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["project_number"].ToString();
item.label = reader["project_number"].ToString() + " : " + reader["project_name_thai"].ToString();
e.Add(item);
goto IsHasData;
}
else
{
var get_assign = item_list.Where(ee => ee.value == AssignerCode).ToList();
if (get_assign != null && get_assign.Count > 0)
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["project_number"].ToString();
item.label = reader["project_number"].ToString() + " : " + reader["project_name_thai"].ToString();
e.Add(item);
goto IsHasData;
}
}
}
}
IsHasData:
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelMenuC2_InterfaceData> MenuC2InterfaceDataAsync(string userid, string username)
{
ModelMenuC2_InterfaceData resp = new ModelMenuC2_InterfaceData();
resp.ListAssigner = new List <ModelSelectOption>();
ModelSelectOption assigner_login = new ModelSelectOption();
assigner_login.value = userid;
assigner_login.label = username + " (เช้าสู่ระบบ)";
resp.default_assigner_name = assigner_login.label;
resp.default_assigner_seq = "0"; //Default 0 ไม่มีผล
resp.ListAssigner.Add(assigner_login);
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYearOfProject = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.defaultyear = (thai_year);
resp.ListYearOfProject.Add(year_current);
ModelCountOfYear round_of_year = new ModelCountOfYear();
round_of_year = await _IDocMeetingRoundRepository.GetMeetingRoundOfProjectAsync(resp.defaultyear);
resp.defaultround = round_of_year.count;
resp.ListProjectNumber = new List <ModelSelectOption>();
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(userid, "M012");
if (resp.UserPermission != null && resp.UserPermission.alldata == true)
{
resp.ListProjectNumber = await GetAllProjectAsync("", "C2");
}
else
{
resp.ListProjectNumber = await GetAllProjectAsync(userid, "C2");
}
resp.ListSafetyType = new List <ModelSelectOption>();
resp.ListSafetyType = null;
resp.ListApprovalType = new List <ModelSelectOption>();
resp.ListApprovalType = null;
return(resp);
}
public async Task <ModelMenuC1_InterfaceData> MenuC1InterfaceDataAsync(string userid, string username)
{
//string user_id = Encoding.UTF8.GetString(Convert.FromBase64String(userid));
ModelMenuC1_InterfaceData resp = new ModelMenuC1_InterfaceData();
resp.ListAssigner = new List <ModelSelectOption>();
ModelSelectOption assigner_login = new ModelSelectOption();
assigner_login.value = userid;
assigner_login.label = username + " (เช้าสู่ระบบ)";
resp.default_assigner_name = assigner_login.label;
resp.ListAssigner.Add(assigner_login);
resp.ListBoard = new List <ModelSelectOption>();
resp.ListBoard = await GetAllRegisterUserByCharacterAsync("");
resp.ListSpecialList = new List <ModelSelectOption>();
resp.ListSpecialList = await GetAllRegisterUserByCharacterAsync("");
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYearOfProject = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.defaultyear = (thai_year);
resp.ListYearOfProject.Add(year_current);
ModelCountOfYear round_of_year = new ModelCountOfYear();
round_of_year = await _IDocMeetingRoundRepository.GetMeetingRoundOfProjectAsync(resp.defaultyear);
resp.defaultround = round_of_year.count;
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(userid, "M011");
resp.ListProjectNumber = new List <ModelSelectOption>();
if (resp.UserPermission != null && resp.UserPermission.alldata == true)
{
resp.ListProjectNumber = await GetAllProjectNumberC1Async(null);
}
else
{
resp.ListProjectNumber = await GetAllProjectNumberC1Async(userid);
}
return(resp);
}
// Edit Data Mode --------------------------------------------------------------------
public async Task <ModelMenuB1_InterfaceData> MenuB1InterfaceDataEditAsync(string project_number, string userid, string username)
{
ModelMenuB1_InterfaceData resp = new ModelMenuB1_InterfaceData();
// Edit Mode
resp.editdata = new ModelMenuB1Edit();
resp.editdata = await GetEditDataB1Async(project_number);
resp.ListProjectHead = new List <ModelSelectOption>();
ModelSelectOption user_login = new ModelSelectOption();
user_login.value = resp.editdata.projecthead;
user_login.label = resp.editdata.projectheadname;
resp.ListProjectHead.Add(user_login);
resp.defaultusername = resp.editdata.projectheadname;
resp.defaultuserid = resp.editdata.projecthead;
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYearOfProject = new List <ModelSelectOption>();
resp.defaultyear = thai_year;
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.ListYearOfProject.Add(year_current);
resp.ListProjectNameThai = new List <ModelSelectOption>();
ModelSelectOption project_name_default = new ModelSelectOption()
{
value = resp.editdata.projectid,
label = resp.editdata.projectnamethai,
};
resp.ListProjectNameThai.Add(project_name_default);
resp.ListDownloadFile = new List <ModelSelectOption>();
resp.ListDownloadFile = await GetAllDownloadFileByProjectIdAsync(resp.editdata.projectid);
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(userid, "M010");
return(resp);
}
public async Task <ModelMenuC12_InterfaceData> MenuC12InterfaceDataAsync(string RegisterId)
{
ModelMenuC12_InterfaceData resp = new ModelMenuC12_InterfaceData();
resp.ListAssigner = new List <ModelSelectOption>();
resp.ListAssigner = await GetAllRegisterUserByCharacterC12Async("2");
resp.ListBoard = new List <ModelSelectOption>();
resp.ListBoard = await GetAllRegisterUserByCharacterC12Async("2");
resp.ListProjectNumber = new List <ModelSelectOption>();
resp.ListProjectNumber = await GetAllProjectNumberC12Async();
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYearOfProject = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.defaultyear = (thai_year);
resp.ListYearOfProject.Add(year_current);
//for (int i = 1; i < 5; i++)
//{
// ModelSelectOption year_next = new ModelSelectOption();
// year_next.value = (thai_year + i).ToString();
// year_next.label = (thai_year + i).ToString();
// resp.ListYearOfProject.Add(year_next);
//}
ModelCountOfYear round_of_year = new ModelCountOfYear();
round_of_year = await _IDocMeetingRoundRepository.GetMeetingRoundOfProjectAsync(resp.defaultyear);
resp.defaultround = round_of_year.count;
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M011");
return(resp);
}
public async Task <ModelMenuC1_InterfaceData> MenuC1InterfaceDataEditAsync(string project_number, string RegisterId)
{
ModelMenuC1_InterfaceData resp = new ModelMenuC1_InterfaceData();
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M011");
resp.editdata = new ModelMenuC1();
resp.editdata = await GetMenuC1DataEditAsync(project_number, RegisterId, resp.UserPermission);
resp.ListAssigner = new List <ModelSelectOption>();
ModelSelectOption assigner_login = new ModelSelectOption();
assigner_login.value = resp.editdata.assignercode;
assigner_login.label = resp.editdata.assignername;
resp.default_assigner_name = assigner_login.label;
resp.ListAssigner.Add(assigner_login);
resp.ListBoard = new List <ModelSelectOption>();
resp.ListBoard = await GetAllRegisterUserByCharacterAsync("");
resp.ListSpecialList = new List <ModelSelectOption>();
resp.ListSpecialList = await GetAllRegisterUserByCharacterAsync("");
resp.ListProjectNumber = new List <ModelSelectOption>();
ModelSelectOption project_name_default = new ModelSelectOption()
{
value = resp.editdata.projectnumber,
label = resp.editdata.projectnumber + " : " + resp.editdata.projectnamethai,
};
resp.ListProjectNumber.Add(project_name_default);
resp.ListYearOfProject = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = resp.editdata.yearofmeeting;
year_current.label = resp.editdata.yearofmeeting;
resp.defaultyear = Convert.ToInt32(resp.editdata.yearofmeeting);
resp.ListYearOfProject.Add(year_current);
return(resp);
}
public async Task <ModelMenuD1_InterfaceData> MenuD1EditInterfaceDataAsync(string UserId, string ProjectNumber)
{
ModelMenuD1_InterfaceData resp = new ModelMenuD1_InterfaceData();
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(UserId, "M020");
resp.editdata = new ModelMenuD1();
resp.editdata = await GetMenuD1DataEditAsync(ProjectNumber, UserId, resp.UserPermission);
resp.ListProjectNumber = new List <ModelSelectOption>();
ModelSelectOption project_name_default = new ModelSelectOption()
{
value = resp.editdata.projectnumber,
label = resp.editdata.projectnumber + " : " + resp.editdata.projectnamethai,
};
resp.ListProjectNumber.Add(project_name_default);
return(resp);
}
public async Task <ModelMenuC2_InterfaceData> MenuC2InterfaceDataEditAsync(int docid, string userid, string username)
{
ModelMenuC2_InterfaceData resp = new ModelMenuC2_InterfaceData();
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(userid, "M012");
resp.editdata = new ModelMenuC2();
resp.editdata = await GetMenuC2DataEditAsync(docid, userid, resp.UserPermission);
resp.ListAssigner = new List <ModelSelectOption>();
ModelSelectOption assigner_login = new ModelSelectOption();
assigner_login.value = resp.editdata.assignercode;
assigner_login.label = resp.editdata.assignername;
resp.default_assigner_name = assigner_login.label;
resp.default_assigner_seq = "0"; //Default 0 ไม่มีผล
resp.ListAssigner.Add(assigner_login);
resp.ListProjectNumber = new List <ModelSelectOption>();
ModelSelectOption project_name_default = new ModelSelectOption()
{
value = resp.editdata.projectnumber,
label = resp.editdata.projectnumber + " : " + resp.editdata.projectnamethai,
};
resp.ListProjectNumber.Add(project_name_default);
resp.ListYearOfProject = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = resp.editdata.yearofmeeting;
year_current.label = resp.editdata.yearofmeeting;
resp.defaultyear = Convert.ToInt32(resp.editdata.yearofmeeting);
resp.defaultround = Convert.ToInt32(resp.editdata.roundofmeeting);
resp.ListYearOfProject.Add(year_current);
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllRegisterUserByCharacterAsync(string RegisterId)
{
string sql = "SELECT register_id, (first_name + full_name) as full_name FROM RegisterUser WHERE 1=1 AND IsActive='1' ";
if (string.IsNullOrEmpty(RegisterId))
{
sql += "AND Character IN ('2','5','6','7','8') ";
}
if (!string.IsNullOrEmpty(RegisterId))
{
sql += "AND Character IN ('" + RegisterId + "') ";
}
sql += " ORDER BY full_name ASC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = System.Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(reader["register_id"].ToString()));
item.label = reader["full_name"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IList <ModelSelectOption> > GetAllProjectNumberC1Async(string project_header)
{
string sql = "SELECT A.project_key_number, B.project_name_thai " +
"FROM Doc_MenuB1 A " +
"INNER JOIN Doc_Process B " +
"ON A.project_key_number = B.project_number " +
"WHERE 1=1 AND A.IsIssue=0 ";
if (!string.IsNullOrEmpty(project_header))
{
sql += " AND A.project_head='" + project_header + "' ";
}
sql += "GROUP BY A.doc_id, A.project_key_number, A.project_head, B.project_name_thai " +
"ORDER BY A.doc_id ASC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["project_key_number"].ToString();
item.label = reader["project_key_number"].ToString() + " : " + reader["project_name_thai"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IList <ModelSelectOption> > GetFileDownloadByProjectNumberAsync(string project_number)
{
string sql = "SELECT TOP(1) file1name,file2name " +
"FROM Doc_MenuA7 WHERE project_number='" + project_number + "' " +
"ORDER BY doc_id DESC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
if (!string.IsNullOrEmpty(reader["file1name"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["file1name"].ToString();
item.label = "รายงานผลสรุปและแจ้งปิดโครงการ";
e.Add(item);
}
if (!string.IsNullOrEmpty(reader["file2name"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["file2name"].ToString();
item.label = "ไฟล์ผลงานวิจัยฉบับสมบูรณ์";
e.Add(item);
}
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelMenuC22_InterfaceData> MenuC22InterfaceDataAsync(string userid, string username)
{
ModelMenuC22_InterfaceData resp = new ModelMenuC22_InterfaceData();
resp.ListAssigner = new List <ModelSelectOption>();
ModelSelectOption assigner_login = new ModelSelectOption();
int assigner_count = (resp.ListAssigner.Count + 1);
assigner_login.value = userid;
assigner_login.label = assigner_count.ToString() + ". " + username + " (เช้าสู่ระบบ)";
resp.default_assigner_name = assigner_login.label;
resp.default_assigner_seq = assigner_count.ToString();
resp.ListAssigner.Add(assigner_login);
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(userid, "M012");
resp.ListProjectNumber = new List <ModelSelectOption>();
if (resp.UserPermission != null && resp.UserPermission.alldata == true)
{
resp.ListProjectNumber = await GetAllProjectLabAsync("", "C22");
}
else
{
resp.ListProjectNumber = await GetAllProjectLabAsync(userid, "C22");
}
resp.ListSafetyType = new List <ModelSelectOption>();
resp.ListSafetyType = null;
resp.ListApprovalType = new List <ModelSelectOption>();
resp.ListApprovalType = null;
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllDownloadFileByLabNumberB2Async(string project_id)
{
string sql = "SELECT filename1,filename2 FROM Doc_MenuA2 WHERE doc_id='" + project_id + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
if (!string.IsNullOrEmpty(reader["filename1"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["filename1"].ToString();
item.label = "แนบไฟล์แบบคำขอ (NUIBC01)";
e.Add(item);
}
if (!string.IsNullOrEmpty(reader["filename2"].ToString()))
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["filename2"].ToString();
item.label = "แนบไฟล์แบบประเมินเบื้องต้น";
e.Add(item);
}
}
return(e);
}
}
conn.Close();
}
return(null);
}
// ระเบียบวาระที่ 4 ------------------------------------------------------------------------------
public async Task <ModelMenuC3Tab4_InterfaceData_History> MenuC3Tab4InterfaceHistoryDataAsync()
{
ModelMenuC3Tab4_InterfaceData_History resp = new ModelMenuC3Tab4_InterfaceData_History();
resp.ListMeetingId = new List <ModelSelectOption>();
resp.ListMeetingId = await GetAllMeetingIdAsync();
ModelSelectOption all_meeting = new ModelSelectOption()
{
value = "", label = "เลือก..."
};
resp.ListMeetingId.Add(all_meeting);
resp.ListApprovalType = await GetAllApprovalTypeAsync();
ModelSelectOption all_approval_type = new ModelSelectOption()
{
value = "", label = "เลือก..."
};
resp.ListApprovalType.Add(all_approval_type);
resp.ListConsiderType = await GetAllConsiderTypeAsync();
ModelSelectOption all_consider_type = new ModelSelectOption()
{
value = "", label = "เลือก..."
};
resp.ListConsiderType.Add(all_consider_type);
resp.ListReportData = await GetAllReportHistoryDataC3Tab4Async(null);
return(resp);
}
public async Task <IList <ModelSelectOption> > GetAllProjectNameThaiAsync(string project_head)
{
string sql = "SELECT project_head, doc_id, project_name_thai " +
"FROM Doc_MenuA1 WHERE 1=1 AND IsClosed=0 ";
if (!string.IsNullOrEmpty(project_head) && project_head != "all")
{
sql += "AND project_head='" + project_head + "'";
}
sql += " ORDER BY project_name_thai ASC";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
IList <ModelSelectOption> e = new List <ModelSelectOption>();
while (await reader.ReadAsync())
{
ModelSelectOption item = new ModelSelectOption();
item.value = reader["doc_id"].ToString();
item.label = reader["project_name_thai"].ToString();
e.Add(item);
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <ModelMenuHome1_InterfaceData> MenuHome1InterfaceDataAsync(string RegisterId)
{
ModelMenuHome1_InterfaceData resp = new ModelMenuHome1_InterfaceData();
var cultureInfo = new CultureInfo("th-TH");
CultureInfo.DefaultThreadCurrentCulture = cultureInfo;
CultureInfo.DefaultThreadCurrentUICulture = cultureInfo;
int thai_year = CommonData.GetYearOfPeriod();
resp.ListYear = new List <ModelSelectOption>();
ModelSelectOption year_current = new ModelSelectOption();
year_current.value = (thai_year).ToString();
year_current.label = (thai_year).ToString();
resp.ListYear.Add(year_current);
for (int i = 1; i < 5; i++)
{
ModelSelectOption year_next = new ModelSelectOption();
year_next.value = (thai_year + i).ToString();
year_next.label = (thai_year + i).ToString();
resp.ListYear.Add(year_next);
}
ModelSelectOption all_year = new ModelSelectOption();
all_year.value = "All";
all_year.label = "เลือก...";
resp.ListYear.Add(all_year);
//------------------------------------------------------------------------------------------
resp.ListProjectHead = await GetAllProjectHeadAsync();
if (resp.ListProjectHead == null)
{
resp.ListProjectHead = new List <ModelSelectOption>();
}
ModelSelectOption all_project_head = new ModelSelectOption();
all_project_head.value = "YWxs";
all_project_head.label = "เลือก...";
resp.ListProjectHead.Add(all_project_head);
//------------------------------------------------------------------------------------------
resp.ListAcceptType = new List <ModelSelectOption>();
ModelSelectOption accept_type_1 = new ModelSelectOption();
accept_type_1.value = "1";
accept_type_1.label = "ขอรับการพิจารณารับรองด้านความปลอดภัยทางชีวภาพระดับห้องทดลอง";
resp.ListAcceptType.Add(accept_type_1);
ModelSelectOption accept_type_2 = new ModelSelectOption();
accept_type_2.value = "2";
accept_type_2.label = "ขอรับการพิจารณารับรองด้านความปลอดภัยทางชีวภาพระดับภาคสนาม";
resp.ListAcceptType.Add(accept_type_2);
ModelSelectOption accept_type_all = new ModelSelectOption();
accept_type_all.value = "ALL";
accept_type_all.label = "เลือก...";
resp.ListAcceptType.Add(accept_type_all);
//------------------------------------------------------------------------------------------
resp.ListFaculty = await GetAllFacultyAsync();
if (resp.ListFaculty == null)
{
resp.ListFaculty = new List <ModelSelectOption>();
}
ModelSelectOption faculty_all = new ModelSelectOption();
faculty_all.value = "All";
faculty_all.label = "เลือก...";
resp.ListFaculty.Add(faculty_all);
//------------------------------------------------------------------------------------------
resp.ListAcronyms = await GetAllAcronymsAsync();
if (resp.ListAcronyms == null)
{
resp.ListAcronyms = new List <ModelSelectOption>();
}
ModelSelectOption acronyms_all = new ModelSelectOption();
acronyms_all.value = "ALL";
acronyms_all.label = "เลือก...";
resp.ListAcronyms.Add(acronyms_all);
//------------------------------------------------------------------------------------------
resp.ListRisk = new List <ModelSelectOption>();
ModelSelectOption risk_1 = new ModelSelectOption();
risk_1.value = "1";
risk_1.label = "งานวิจัยประเภทที่ 1";
resp.ListRisk.Add(risk_1);
ModelSelectOption risk_2 = new ModelSelectOption();
risk_2.value = "2";
risk_2.label = "งานวิจัยประเภทที่ 2";
resp.ListRisk.Add(risk_2);
ModelSelectOption risk_3 = new ModelSelectOption();
risk_3.value = "3";
risk_3.label = "งานวิจัยประเภทที่ 3";
resp.ListRisk.Add(risk_3);
ModelSelectOption risk_4 = new ModelSelectOption();
risk_4.value = "4";
risk_4.label = "งานวิจัยประเภทที่ 4";
resp.ListRisk.Add(risk_4);
ModelSelectOption risk_all = new ModelSelectOption();
risk_all.value = "ALL";
risk_all.label = "เลือก...";
resp.ListRisk.Add(risk_all);
//------------------------------------------------------------------------------------------
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M001");
resp.usergroup = (resp.UserPermission.groupcode == "G001" || resp.UserPermission.groupcode == "G005" ? 2 : 1);
ModelMenuHome1_InterfaceData search_data = new ModelMenuHome1_InterfaceData()
{
userid = RegisterId
};
resp.ListReportData = new List <ModelMenuHome1ReportData>();
resp.ListReportData = await GetAllReportDataHome1Async(search_data);
return(resp);
}
