public async Task <ModelMenuA1> GetFileDownloadHome1Async(string project_number)
{
string sql = "SELECT B.project_key_number, A.file1name, A.file2name, " +
"A.file3name, A.file4name, A.file5name " +
"FROM Doc_MenuA1 A INNER JOIN Doc_MenuB1 B " +
"ON A.doc_id = B.project_id " +
"WHERE B.project_key_number='" + project_number + "'";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
ModelMenuA1 e = new ModelMenuA1();
while (await reader.ReadAsync())
{
e.file1name = reader["file1name"].ToString();
e.file2name = reader["file2name"].ToString();
e.file3name = reader["file3name"].ToString();
e.file4name = reader["file4name"].ToString();
e.file5name = reader["file5name"].ToString();
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task <IActionResult> AddDocMenuA1([FromBody] ModelMenuA1 model)
{
var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuA"}/{"AddDocMenuA1"}";
string authHeader = HttpContext.Request?.Headers["Authorization"];
if (authHeader != null && authHeader.StartsWith("Bearer"))
{
BearerToken = authHeader.Substring("Bearer ".Length).Trim();
}
var response = await HttpRequestFactory.Post(requestUri, BearerToken, model);
switch (response.StatusCode)
{
case HttpStatusCode.Unauthorized:
return(Unauthorized(response.ContentAsString()));
case HttpStatusCode.BadRequest:
return(BadRequest(response.ContentAsString()));
case HttpStatusCode.OK:
return(Ok(response.ContentAsString()));
default:
return(StatusCode(500));
}
}
public async Task <IActionResult> AddDocMenuA1([FromBody] ModelMenuA1 model)
{
ModelResponseA1Message e = await _IDocMenuAService.AddDocMenuA1Async(model);
if (e.Status)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
public async Task <ModelResponseA1Message> AddDocMenuA1Async(ModelMenuA1 model)
{
model.docdate = DateTime.Now;
model.projecthead = Encoding.UTF8.GetString(Convert.FromBase64String(model.projecthead));
model.file1name = string.IsNullOrEmpty(model.file1name) ? "" : GenerateToken.GetGuid() + Path.GetExtension(model.file1name);
model.file2name = string.IsNullOrEmpty(model.file2name) ? "" : GenerateToken.GetGuid() + Path.GetExtension(model.file2name);
model.file3name = string.IsNullOrEmpty(model.file3name) ? "" : GenerateToken.GetGuid() + Path.GetExtension(model.file3name);
model.file4name = string.IsNullOrEmpty(model.file4name) ? "" : GenerateToken.GetGuid() + Path.GetExtension(model.file4name);
model.file5name = string.IsNullOrEmpty(model.file5name) ? "" : GenerateToken.GetGuid() + Path.GetExtension(model.file5name);
//Risk Group 1
if (!model.riskgroup1)
{
model.riskgroup11 = false;
model.riskgroup12 = false;
model.riskgroup13 = false;
model.riskgroup14 = false;
model.riskgroup15 = false;
model.riskgroup15other = string.Empty;
}
//Risk Group 2
if (!model.riskgroup1)
{
model.riskgroup11 = false;
model.riskgroup22 = false;
model.riskgroup23 = false;
model.riskgroup24 = false;
model.riskgroup25 = false;
}
//Risk Group 3
if (!model.riskgroup1)
{
model.riskgroup31 = false;
model.riskgroup32 = false;
model.riskgroup33 = false;
model.riskgroup34 = false;
model.riskgroup35 = false;
}
//Risk Group 4
if (!model.riskgroup1)
{
model.riskgroup41 = false;
model.riskgroup42 = false;
model.riskgroup43 = false;
model.riskgroup44 = false;
model.riskgroup45 = false;
}
//Member Project 1
MemberProject member1 = new MemberProject();
if (!string.IsNullOrEmpty(model.member1projecthead))
{
member1.projecthead = model.member1projecthead;
member1.facultyname = model.member1facultyname;
member1.workphone = model.member1workphone;
member1.mobile = model.member1mobile;
member1.fax = model.member1fax;
member1.email = model.member1email;
model.member1json = member1;
}
//Member Project 2
MemberProject member2 = new MemberProject();
if (!string.IsNullOrEmpty(model.member2projecthead))
{
member2.projecthead = model.member2projecthead;
member2.facultyname = model.member2facultyname;
member2.workphone = model.member2workphone;
member2.mobile = model.member2mobile;
member2.fax = model.member2fax;
member2.email = model.member2email;
model.member2json = member2;
}
//Member Project 3
MemberProject member3 = new MemberProject();
if (!string.IsNullOrEmpty(model.member3projecthead))
{
member3.projecthead = model.member3projecthead;
member3.facultyname = model.member3facultyname;
member3.workphone = model.member3workphone;
member3.mobile = model.member3mobile;
member3.fax = model.member3fax;
member3.email = model.member3email;
model.member3json = member3;
}
//Member Project 4
MemberProject member4 = new MemberProject();
if (!string.IsNullOrEmpty(model.member4projecthead))
{
member4.projecthead = model.member4projecthead;
member4.facultyname = model.member4facultyname;
member4.workphone = model.member4workphone;
member4.mobile = model.member4mobile;
member4.fax = model.member4fax;
member4.email = model.member4email;
model.member4json = member4;
}
//Member Project 5
MemberProject member5 = new MemberProject();
if (!string.IsNullOrEmpty(model.member5projecthead))
{
member5.projecthead = model.member5projecthead;
member5.facultyname = model.member5facultyname;
member5.workphone = model.member5workphone;
member5.mobile = model.member5mobile;
member5.fax = model.member5fax;
member5.email = model.member5email;
model.member5json = member5;
}
//Member Project 6
MemberProject member6 = new MemberProject();
if (!string.IsNullOrEmpty(model.member6projecthead))
{
member6.projecthead = model.member6projecthead;
member6.facultyname = model.member6facultyname;
member6.workphone = model.member6workphone;
member6.mobile = model.member6mobile;
member6.fax = model.member6fax;
member6.email = model.member6email;
model.member6json = member6;
}
//Member Project 7
MemberProject member7 = new MemberProject();
if (!string.IsNullOrEmpty(model.member7projecthead))
{
member7.projecthead = model.member7projecthead;
member7.facultyname = model.member7facultyname;
member7.workphone = model.member7workphone;
member7.mobile = model.member7mobile;
member7.fax = model.member7fax;
member7.email = model.member7email;
model.member7json = member7;
}
//Member Project 8
MemberProject member8 = new MemberProject();
if (!string.IsNullOrEmpty(model.member8projecthead))
{
member8.projecthead = model.member8projecthead;
member8.facultyname = model.member8facultyname;
member8.workphone = model.member8workphone;
member8.mobile = model.member8mobile;
member8.fax = model.member8fax;
member8.email = model.member8email;
model.member8json = member8;
}
//Member Project 9
MemberProject member9 = new MemberProject();
if (!string.IsNullOrEmpty(model.member9projecthead))
{
member9.projecthead = model.member9projecthead;
member9.facultyname = model.member9facultyname;
member9.workphone = model.member9workphone;
member9.mobile = model.member9mobile;
member9.fax = model.member9fax;
member9.email = model.member9email;
model.member9json = member9;
}
//Member Project 10
MemberProject member10 = new MemberProject();
if (!string.IsNullOrEmpty(model.member10projecthead))
{
member10.projecthead = model.member10projecthead;
member10.facultyname = model.member10facultyname;
member10.workphone = model.member10workphone;
member10.mobile = model.member10mobile;
member10.fax = model.member10fax;
member10.email = model.member10email;
model.member10json = member10;
}
//Member Project 11
MemberProject member11 = new MemberProject();
if (!string.IsNullOrEmpty(model.member11projecthead))
{
member11.projecthead = model.member11projecthead;
member11.facultyname = model.member11facultyname;
member11.workphone = model.member11workphone;
member11.mobile = model.member11mobile;
member11.fax = model.member11fax;
member11.email = model.member11email;
model.member11json = member11;
}
//Member Project 12
MemberProject member12 = new MemberProject();
if (!string.IsNullOrEmpty(model.member12projecthead))
{
member12.projecthead = model.member12projecthead;
member12.facultyname = model.member12facultyname;
member12.workphone = model.member12workphone;
member12.mobile = model.member12mobile;
member12.fax = model.member12fax;
member12.email = model.member12email;
model.member12json = member12;
}
var resp = await _IDocMenuA1Repository.AddDocMenuA1Async(model);
if (resp.Status)
{
if (!string.IsNullOrEmpty(model.file1base64))
{
ServerDirectorys.SaveFileFromBase64(_IEnvironmentConfig.PathDocument, FolderDocument.menuA1, model.file1name, model.file1base64);
}
if (!string.IsNullOrEmpty(model.file2base64))
{
ServerDirectorys.SaveFileFromBase64(_IEnvironmentConfig.PathDocument, FolderDocument.menuA1, model.file2name, model.file2base64);
}
if (!string.IsNullOrEmpty(model.file3base64))
{
ServerDirectorys.SaveFileFromBase64(_IEnvironmentConfig.PathDocument, FolderDocument.menuA1, model.file3name, model.file3base64);
}
if (!string.IsNullOrEmpty(model.file4base64))
{
ServerDirectorys.SaveFileFromBase64(_IEnvironmentConfig.PathDocument, FolderDocument.menuA1, model.file4name, model.file4base64);
}
if (!string.IsNullOrEmpty(model.file5base64))
{
ServerDirectorys.SaveFileFromBase64(_IEnvironmentConfig.PathDocument, FolderDocument.menuA1, model.file5name, model.file5base64);
}
}
return(resp);
}
