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 <ModelCountOfYear> GetMeetingRoundOfProjectAsync(int year)
{
ModelCountOfYear round = new ModelCountOfYear()
{
count = 1
};
string sql = "SELECT MAX(meeting_round) AS round_number " +
"FROM [EFILLING].[dbo].[Doc_MeetingRound_Project] " +
"WHERE meeting_year = '" + year + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
while (await reader.ReadAsync())
{
round.count = Convert.ToInt32(reader["round_number"]);
}
}
}
conn.Close();
}
return(round);
}
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);
}
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 <IActionResult> GetMeetingRoundOfProject(int Year)
{
ModelCountOfYear e = await _IDocMenuCService.GetMeetingRoundOfProjectAsync(Year);
if (e != null)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
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);
}
