// GET: /<controller>/
public IActionResult Index()
{
Connectdb con = HttpContext.RequestServices.GetService(typeof(netcore.Models.Connectdb)) as Connectdb;
string strSQL;
MySqlDataReader dtReader;
strSQL = "SELECT * FROM savecs1 WHERE id = 4 ";
dtReader = con.QueryDataReader(strSQL);
dtReader.Read();
dtReader["name"].ToString();
FormCs1Model add = new FormCs1Model();
add.name = dtReader["name"].ToString();
add.lastname = dtReader["lastname"].ToString();
add.idstudent = dtReader["idstudent"].ToString();
add.sector = dtReader["sector"].ToString();
add.title = dtReader["title"].ToString();
add.titleEng = dtReader["titleEng"].ToString();
add.importance = dtReader["importance"].ToString();
add.objective = dtReader["objective"].ToString();
add.reasoning = dtReader["reasoning"].ToString();
add.timeimage = dtReader["timeimage"].ToString();
add.scope = dtReader["scope"].ToString();
return(View(add));
}
[HttpPost]//----------------------------ฟั่งชั้นบันทึกแบบฟอร์ม CS1 ---------------------//
public IActionResult SaveCs1(FormCs1Model result)
{
//-----------------------อัพโหลดไฟล์รูปเข้าระบบ--------------------------------------
string namenew = null;
if (result.timeimage != null)
{
string uploads = Path.Combine(_hostingEnvironment.WebRootPath, "img");
namenew = Guid.NewGuid().ToString() + "_" + result.timeimage.FileName;
string filePath = Path.Combine(uploads, namenew);
result.timeimage.CopyTo(new FileStream(filePath, FileMode.Create));
}
//---------------------------------------------------------------------------------------------
Connectdb con = HttpContext.RequestServices.GetService(typeof(netcore.Models.Connectdb)) as Connectdb;
string strSQL;
MySqlDataReader dtReader;
strSQL = "INSERT INTO `savecs1`(`name`,`lastname`,`idstudent`,`sector`,`title`,`titleEng`,`importance`,`objective`,`reasoning`,`timeimage`,`scope`,`studentid`) VALUES" +
" ('" + result.name + "','" + result.lastname + "','" + result.idstudent + "','" + result.sector + "','" + result.title + "','" + result.titleEng + "','" + result.importance + "','" + result.objective + "','" + result.reasoning + "','" + namenew + "','" + result.scope + "','" + User.FindFirst("id").Value + "'); ";
con.QueryDataSet(strSQL);
return(RedirectToAction("Detail", new { savecs1 = "success" }));
}
[HttpPost]//----------------------------ฟั่งชั้นบันทึกแบบฟอร์ม CS1 ---------------------//
public IActionResult updatecs1(FormCs1Model result)
{
//-------------------------------------------------ฟังชั่นในการอัพโหลดไฟล์ลงระบบ**********************-----------
string namenew = null;
if (result.timeimage != null)
{
string uploads = Path.Combine(_hostingEnvironment.WebRootPath, "img");
namenew = Guid.NewGuid().ToString() + "_" + result.timeimage.FileName;
string filePath = Path.Combine(uploads, namenew);
result.timeimage.CopyTo(new FileStream(filePath, FileMode.Create));
//------------------------------------------------------------อัพเดทข้อมูลในระบบ--------------------------
Connectdb con = HttpContext.RequestServices.GetService(typeof(netcore.Models.Connectdb)) as Connectdb;
string strSQL;
MySqlDataReader dtReader;
strSQL = "UPDATE `savecs1` SET `name` ='" + result.name + "' ,`lastname`= '" + result.lastname + "',`idstudent`= '" + result.idstudent + "',`sector`='" +
result.sector + "' ,`title`= '" + result.title + "',`titleEng`= '" + result.titleEng + "',`importance`='" + result.importance + "' ,`objective`= '" + result.objective + "',`reasoning`='" + result.reasoning + "' ,`timeimage`='" + namenew + "' ,`scope`='" + result.scope + "' ,`studentid`= '" + User.FindFirst("id").Value + "' WHERE studentid = '" + User.FindFirst("id").Value + "' ";
con.QueryDataSet(strSQL);
return(RedirectToAction("Detail", new { update = "success" }));
}
else
{
//------------------------------------------------------------อัพเดทข้อมูลในระบบถ้าไม่มีรูป--------------------------
Connectdb con = HttpContext.RequestServices.GetService(typeof(netcore.Models.Connectdb)) as Connectdb;
string strSQL;
MySqlDataReader dtReader;
strSQL = "UPDATE `savecs1` SET `name` ='" + result.name + "' ,`lastname`= '" + result.lastname + "',`idstudent`= '" + result.idstudent + "',`sector`='" +
result.sector + "' ,`title`= '" + result.title + "',`titleEng`= '" + result.titleEng + "',`importance`='" + result.importance + "' ,`objective`= '" + result.objective + "',`reasoning`='" + result.reasoning + "' ,`scope`='" + result.scope + "' ,`studentid`= '" + User.FindFirst("id").Value + "' WHERE studentid = '" + User.FindFirst("id").Value + "' ";
con.QueryDataSet(strSQL);
return(RedirectToAction("Detail", new { update = "success" }));
}
}
[HttpPost]//----------------------------ฟั่งชั้นบันทึกแบบฟอร์ม CS1 ---------------------//
public IActionResult SaveCs1(FormCs1Model saveform)
{
Connectdb saveformdata = HttpContext.RequestServices.GetService(typeof(netcore.Models.Connectdb)) as Connectdb;
saveformdata.Savecs1(saveform);
return(RedirectToAction("Index"));
}
