public IActionResult Register(RegisterViewModel auser)
{
string result = "Success";
var context = new masdatabaseContext();
var DataItem = context.Owner.Where(x => x.Email == auser.email).SingleOrDefault();
if (DataItem != null)
{
result = "Fail";
}
else
{
string enpass = Encryption.EncryptedPass(auser.password);
var adduser = new Owner {
Email = auser.email, Password = enpass, Name = auser.name, Surname = auser.surname, Tel = auser.tel
};
context.Add(adduser);
context.SaveChanges();
SqlConnection sqlcon = new SqlConnection("Data Source=(LocalDb)\\MSSQLLocalDb;Initial Catalog=MasSql;Integrated Security=True");
sqlcon.Open();
string query1 = "INSERT INTO owner (Email, Password, Name, Surname , Tel) VALUES('" + auser.email + "', '" + enpass + "', '" + auser.name + "','" + auser.surname + "','" + auser.tel + "')";
SqlCommand sqlcom1 = new SqlCommand(query1);
sqlcom1.Connection = sqlcon;
SqlDataReader sqlReader1 = sqlcom1.ExecuteReader();
result = "OK";
sqlcon.Close();
}
return(Json(result));
}
public IActionResult Login(LoginViewModel user)
{
var context = new masdatabaseContext();
string result = "Fail";
string enpass = Encryption.EncryptedPass(user.password);
var DataItem = context.Owner.Where(x => x.Email == user.email && x.Password == enpass).SingleOrDefault();
if (DataItem != null)
{
HttpContext.Session.SetInt32("Oid", DataItem.Oid);
HttpContext.Session.SetString("Name", DataItem.Name);
HttpContext.Session.SetString("Email", DataItem.Email);
HttpContext.Session.SetString("Surname", DataItem.Surname);
HttpContext.Session.SetString("Tel", DataItem.Tel);
if (DataItem.Picture == null)
{
HttpContext.Session.SetString("Picture", "1");
}
else
{
HttpContext.Session.SetString("Picture", DataItem.Picture);
}
HttpContext.Session.SetString("Log", "1");
result = "Success";
}
return(Json(result));
}
public IActionResult set0Status(int status, int did)
{
string result = "Fail";
CultureInfo ci = CultureInfo.InstalledUICulture;
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
var context = new masdatabaseContext();
if (status != 0)
{
var editstatus = context.Room.First(a => a.Rid == status);
editstatus.Tid = 0;
editstatus.Status = "0";
context.SaveChanges();
var editrenter = context.Renter.First(a => a.Rid == status);
editrenter.RenName = null;
editrenter.RenSurename = null;
editrenter.RenTel = null;
editrenter.RenAge = null;
editrenter.RenSsnPicture = null;
editrenter.StartElecMeter = null;
editrenter.StartWaterMeter = null;
editrenter.RenAgreement = null;
if (ci.ThreeLetterWindowsLanguageName == "THA")
{
editrenter.DateTime = Convert.ToDateTime("0544-01-01");
}
else
{
editrenter.DateTime = Convert.ToDateTime("0001-01-01");
}
context.SaveChanges();
result = "Update OK";
}
}
return(Json(result));
}
public IActionResult set1Status(int status)
{
string result = "Fail";
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
var context = new masdatabaseContext();
if (status != 0)
{
var editstatus = context.Room.First(a => a.Rid == status);
editstatus.Status = "1";
context.SaveChanges();
result = "Update OK";
}
}
return(Json(result));
}
public IActionResult checkStatus(int status)
{
string result = "Fail";
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
var context = new masdatabaseContext();
if (status != 0)
{
var checkroom = context.Room.Where(x => x.Rid == status).SingleOrDefault();
if (checkroom != null)
{
result = checkroom.Status;
}
}
}
return(Json(result));
}
public IActionResult GetExt(int oid)
{
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
int count = 0;
int amountall = 0;
var context = new masdatabaseContext();
List <isDid> isDids = new List <isDid>();
List <Extrapolate> Extrapolate1 = new List <Extrapolate>();
IQueryable <Dorm> sdorm = from q in context.Dorm where q.Oid == HttpContext.Session.GetInt32("Oid") select q;
foreach (var t in sdorm)
{
count = 1;
}
if (count == 0)
{
return(RedirectToAction("AddDorm", "Manage"));
}
else if (count == 1)
{
ViewBag.myName = HttpContext.Session.GetString("Name");
ViewBag.Profile = HttpContext.Session.GetString("Picture");
var datacount = 0;
string ConnectionStringMysql = "server=localhost;database=masdatabase;user=root;pwd=;sslmode=none";
MySqlConnection mysqlcon = new MySqlConnection(ConnectionStringMysql);
mysqlcon.Open();
string query = "SELECT DID FROM dorm WHERE OID = " + oid + " ";
MySqlCommand com = new MySqlCommand(query);
com.Connection = mysqlcon;
MySqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
isDids.Add(new isDid()
{
Did = reader.GetInt32(reader.GetOrdinal("DID"))
});
}
mysqlcon.Close();
foreach (var d in isDids)
{
mysqlcon.Open();
string query2 = "SELECT COUNT(Amount) as Count FROM (" +
"SELECT SUM(c.Tatal_amount) as Amount FROM owner o " +
"INNER JOIN dorm d ON d.OID = o.Oid " +
"INNER JOIN room r ON r.DID = d.DID " +
"INNER JOIN cal_info_room c ON c.RID = r.RID " +
"WHERE o.Oid = " + oid + " AND d.DID = " + d.Did + " " +
"GROUP BY c.Date " +
"ORDER BY c.Date DESC " +
"LIMIT 3 " +
") Extrapolate";
MySqlCommand com2 = new MySqlCommand(query2);
com2.Connection = mysqlcon;
List <Income> incomes = new List <Income>();
MySqlDataReader reader2 = com2.ExecuteReader();
if (reader2.HasRows)
{
while (reader2.Read())
{
datacount = reader2.GetInt32(reader2.GetOrdinal("Count"));
}
}
mysqlcon.Close();
if (datacount >= 3)
{
mysqlcon.Open();
string query3 = "SELECT CAST(AVG(Amount) AS DECIMAL(10)) as Extrapolate , d.DName as Name , d.DID as DID FROM (SELECT SUM(c.Tatal_amount) as Amount FROM owner o INNER JOIN dorm d ON d.OID = o.Oid INNER JOIN room r ON r.DID = d.DID INNER JOIN cal_info_room c ON c.RID = r.RID WHERE o.Oid = " + oid + " AND d.DID = " + d.Did + " GROUP BY c.Date ORDER BY c.Date DESC LIMIT 3) Extrapolate INNER JOIN dorm d WHERE d.DID = " + d.Did + " ";
MySqlCommand com3 = new MySqlCommand(query3);
com3.Connection = mysqlcon;
MySqlDataReader reader3 = com3.ExecuteReader();
if (reader3.HasRows)
{
while (reader3.Read())
{
amountall += reader3.GetInt32(reader3.GetOrdinal("Extrapolate"));
}
}
mysqlcon.Close();
}
}
}
return(Json(amountall));
}
}
public IActionResult ExtrapolateDorm(int did)
{
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
ViewBag.myName = HttpContext.Session.GetString("Name");
ViewBag.Profile = HttpContext.Session.GetString("Picture");
int count = 0;
var context = new masdatabaseContext();
IQueryable <Dorm> sdorm = from q in context.Dorm where q.Oid == HttpContext.Session.GetInt32("Oid") select q;
foreach (var t in sdorm)
{
count = 1;
}
if (count == 0)
{
return(RedirectToAction("AddDorm", "Manage"));
}
else if (count == 1)
{
var myOid = HttpContext.Session.GetInt32("Oid");
var datacount = 0;
string ConnectionStringMysql = "server=localhost;database=masdatabase;user=root;pwd=;sslmode=none";
MySqlConnection mysqlcon = new MySqlConnection(ConnectionStringMysql);
mysqlcon.Open();
string query = "SELECT COUNT(Amount) as Count FROM (" +
"SELECT SUM(c.Tatal_amount) as Amount FROM owner o " +
"INNER JOIN dorm d ON d.OID = o.Oid " +
"INNER JOIN room r ON r.DID = d.DID " +
"INNER JOIN cal_info_room c ON c.RID = r.RID " +
"WHERE o.Oid = " + myOid + " AND d.DID = " + did + " " +
"GROUP BY c.Date " +
"ORDER BY c.Date DESC " +
") Extrapolate";
MySqlCommand com = new MySqlCommand(query);
com.Connection = mysqlcon;
List <Income> incomes = new List <Income>();
List <Unit> units = new List <Unit>();
List <RoomUpdate> roomUpdates = new List <RoomUpdate>();
MySqlDataReader reader = com.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
datacount = reader.GetInt32(reader.GetOrdinal("Count"));
}
}
mysqlcon.Close();
if (datacount >= 3)
{
mysqlcon.Open();
string query2 = "SELECT CAST(AVG(Amount) AS DECIMAL(10)) as Extrapolate , d.DName as Name FROM (SELECT SUM(c.Tatal_amount) as Amount FROM owner o INNER JOIN dorm d ON d.OID = o.Oid INNER JOIN room r ON r.DID = d.DID INNER JOIN cal_info_room c ON c.RID = r.RID WHERE o.Oid = " + myOid + " AND d.DID = " + did + " GROUP BY c.Date ORDER BY c.Date DESC LIMIT 3) Extrapolate INNER JOIN dorm d WHERE d.DID = " + did + " ";
MySqlCommand com2 = new MySqlCommand(query2);
com2.Connection = mysqlcon;
MySqlDataReader reader2 = com2.ExecuteReader();
if (reader2.HasRows)
{
while (reader2.Read())
{
ViewBag.ExtrapolateDorm = reader2.GetInt32(reader2.GetOrdinal("Extrapolate"));
ViewBag.Dorm_Name = reader2["Name"];
}
}
mysqlcon.Close();
mysqlcon.Open();
string query0 = "SELECT rt.Type , COUNT(*) as Count FROM dorm d " +
"INNER JOIN room r on d.DID = r.DID " +
"INNER JOIN roomtype rt on r.TID = rt.TID " +
"WHERE d.DID = " + did + " AND r.Status = 1 " +
"GROUP BY Type";
MySqlCommand com0 = new MySqlCommand(query0);
com0.Connection = mysqlcon;
int rentercount = 0;
MySqlDataReader reader0 = com0.ExecuteReader();
if (reader0.HasRows)
{
while (reader0.Read())
{
roomUpdates.Add(new RoomUpdate()
{
Type = reader0["Type"].ToString(),
Count = reader0.GetInt32(reader0.GetOrdinal("Count"))
});
rentercount += reader0.GetInt32(reader0.GetOrdinal("Count"));
}
}
mysqlcon.Close();
mysqlcon.Open();
string query3 = "SELECT DATE_FORMAT(c.Date, \"%M\") as Month,DATE_FORMAT(c.Date, \"%Y\") as Year,SUM(c.Total_water_unit) as Water,SUM(c.Total_elec_unit) as Elec FROM owner o " +
"INNER JOIN dorm d ON d.OID = o.Oid " +
"INNER JOIN room r ON r.DID = d.DID " +
"INNER JOIN cal_info_room c ON c.RID = r.RID " +
"WHERE o.Oid = " + HttpContext.Session.GetInt32("Oid") + " AND d.DID = " + did + " " +
"GROUP BY c.Date ORDER BY c.Date ASC ";
MySqlCommand com3 = new MySqlCommand(query3);
com3.Connection = mysqlcon;
MySqlDataReader reader3 = com3.ExecuteReader();
var monthfm = "";
if (reader3.HasRows)
{
while (reader3.Read())
{
if (reader3["Month"].ToString() == "January")
{
monthfm = "1";
}
else if (reader3["Month"].ToString() == "February")
{
monthfm = "2";
}
else if (reader3["Month"].ToString() == "March")
{
monthfm = "3";
}
else if (reader3["Month"].ToString() == "April")
{
monthfm = "4";
}
else if (reader3["Month"].ToString() == "May")
{
monthfm = "5";
}
else if (reader3["Month"].ToString() == "June")
{
monthfm = "6";
}
else if (reader3["Month"].ToString() == "July")
{
monthfm = "7";
}
else if (reader3["Month"].ToString() == "August")
{
monthfm = "8";
}
else if (reader3["Month"].ToString() == "September")
{
monthfm = "9";
}
else if (reader3["Month"].ToString() == "October")
{
monthfm = "10";
}
else if (reader3["Month"].ToString() == "November")
{
monthfm = "11";
}
else if (reader3["Month"].ToString() == "December")
{
monthfm = "12";
}
units.Add(new Unit()
{
Water = reader3.GetInt32(reader3.GetOrdinal("Water")),
Elec = reader3.GetInt32(reader3.GetOrdinal("Elec")),
Month = monthfm,
Year = reader3["Year"].ToString()
});
}
}
mysqlcon.Close();
ViewBag.Unit = units;
ViewBag.RenterCount = rentercount;
ViewBag.RoomUpdate = roomUpdates;
}
else
{
return(RedirectToAction("Main", "Manage"));
}
}
return(View());
}
}
public IActionResult RevenueDorm(int did)
{
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
int count = 0;
var context = new masdatabaseContext();
IQueryable <Dorm> sdorm = from q in context.Dorm where q.Oid == HttpContext.Session.GetInt32("Oid") select q;
foreach (var t in sdorm)
{
count = 1;
}
if (count == 0)
{
return(RedirectToAction("AddDorm", "Manage"));
}
else if (count == 1)
{
var myOid = HttpContext.Session.GetInt32("Oid");
ViewBag.myName = HttpContext.Session.GetString("Name");
ViewBag.Profile = HttpContext.Session.GetString("Picture");
ViewBag.did = did;
var monthfm = "";
string ConnectionStringMysql = "server=localhost;database=masdatabase;user=root;pwd=;sslmode=none";
MySqlConnection mysqlcon = new MySqlConnection(ConnectionStringMysql);
mysqlcon.Open();
string query = "SELECT SUM(c.Tatal_amount) as Amount, DATE_FORMAT(c.Date,'%M') as Month, DATE_FORMAT(c.Date,'%Y') as Year, d.DName as Name FROM owner o INNER JOIN dorm d ON d.OID = o.Oid INNER JOIN room r ON r.DID = d.DID INNER JOIN cal_info_room c ON c.RID = r.RID " +
"WHERE o.Oid = " + myOid + " AND d.DID = " + did + " GROUP BY c.Date";
MySqlCommand com = new MySqlCommand(query);
com.Connection = mysqlcon;
List <Income> incomes = new List <Income>();
MySqlDataReader reader = com.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
if (reader["Month"].ToString() == "January")
{
monthfm = "1";
}
else if (reader["Month"].ToString() == "February")
{
monthfm = "2";
}
else if (reader["Month"].ToString() == "March")
{
monthfm = "3";
}
else if (reader["Month"].ToString() == "April")
{
monthfm = "4";
}
else if (reader["Month"].ToString() == "May")
{
monthfm = "5";
}
else if (reader["Month"].ToString() == "June")
{
monthfm = "6";
}
else if (reader["Month"].ToString() == "July")
{
monthfm = "7";
}
else if (reader["Month"].ToString() == "August")
{
monthfm = "8";
}
else if (reader["Month"].ToString() == "September")
{
monthfm = "9";
}
else if (reader["Month"].ToString() == "October")
{
monthfm = "10";
}
else if (reader["Month"].ToString() == "November")
{
monthfm = "11";
}
else if (reader["Month"].ToString() == "December")
{
monthfm = "12";
}
incomes.Add(new Income()
{
Month = monthfm,
Year = reader["Year"].ToString(),
Amount = reader["Amount"].ToString() + ","
});
ViewBag.DormName = reader["Name"];
ViewBag.GetIncome = incomes;
}
}
else
{
return(RedirectToAction("Main", "Manage"));
}
mysqlcon.Close();
mysqlcon.Open();
string queryall = "SELECT DATE_FORMAT(c.Date, \"%M\") as Month,DATE_FORMAT(c.Date, \"%Y\") as Year,SUM(c.Tatal_amount) as Amount FROM owner o " +
"INNER JOIN dorm d ON d.OID = o.Oid " +
"INNER JOIN room r ON r.DID = d.DID " +
"INNER JOIN cal_info_room c ON c.RID = r.RID " +
"WHERE o.Oid = " + HttpContext.Session.GetInt32("Oid") + " AND d.DID = " + did + " " +
"GROUP BY c.Date ORDER BY c.Date DESC LIMIT 3";
MySqlCommand comall = new MySqlCommand(queryall);
comall.Connection = mysqlcon;
MySqlDataReader readerall = comall.ExecuteReader();
List <Last3Month> last3Months = new List <Last3Month>();
if (readerall.HasRows)
{
while (readerall.Read())
{
if (readerall["Month"].ToString() == "January")
{
monthfm = "มกราคม";
}
else if (readerall["Month"].ToString() == "February")
{
monthfm = "กุมภาพันธ์";
}
else if (readerall["Month"].ToString() == "March")
{
monthfm = "มีนาคม";
}
else if (readerall["Month"].ToString() == "April")
{
monthfm = "เมษายน";
}
else if (readerall["Month"].ToString() == "May")
{
monthfm = "พฤษภาคม";
}
else if (readerall["Month"].ToString() == "June")
{
monthfm = "มิถุนายน";
}
else if (readerall["Month"].ToString() == "July")
{
monthfm = "กรกฎาคม";
}
else if (readerall["Month"].ToString() == "August")
{
monthfm = "สิงหาคม";
}
else if (readerall["Month"].ToString() == "September")
{
monthfm = "กันยายน";
}
else if (readerall["Month"].ToString() == "October")
{
monthfm = "ตุลาคม";
}
else if (readerall["Month"].ToString() == "November")
{
monthfm = "พฤศจิกายน";
}
else if (readerall["Month"].ToString() == "December")
{
monthfm = "ธันวาคม";
}
last3Months.Add(new Last3Month()
{
Month = monthfm,
Year = readerall["Year"].ToString(),
Income = readerall.GetInt32(readerall.GetOrdinal("Amount"))
});
}
}
mysqlcon.Close();
ViewBag.Last3month = last3Months;
}
return(View());
}
}
public IActionResult ShowRoom(int did)
{
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
ViewBag.myName = HttpContext.Session.GetString("Name");
ViewBag.Profile = HttpContext.Session.GetString("Picture");
ViewBag.did = did;
int mydid = did;
var context = new masdatabaseContext();
if (mydid > 0)
{
var dorm = context.Dorm.Where(x => x.Did == mydid).SingleOrDefault();
if (dorm != null)
{
ViewBag.dorm_name = dorm.Dname;
}
var countfloor = context.SetFloorRoom.Where(x => x.Did == mydid).Count();
ViewBag.allFloor = countfloor;
var floors = from a in context.SetFloorRoom where a.Did == mydid select a;
List <SetFloorRoom> sfr = new List <SetFloorRoom>();
foreach (var n in floors)
{
if (n != null)
{
sfr.Add(new SetFloorRoom()
{
Floor = n.Floor,
Room = n.Room
});
ViewBag.sfr = sfr;
}
}
var roomq = from q in context.Room where q.Did == mydid select q;
List <Room> rooms = new List <Room>();
foreach (var q in roomq)
{
if (q != null)
{
rooms.Add(new Room()
{
RoomNumber = q.RoomNumber,
Tid = q.Tid,
Status = q.Status,
Rid = q.Rid
});
ViewBag.rooms = rooms;
}
}
var renter = from x in context.Renter where x.Rid.ToString().Contains(mydid.ToString()) select x;
List <myRenter> renters = new List <myRenter>();
foreach (var x in renter)
{
renters.Add(new myRenter()
{
Rid = x.Rid,
RenId = x.RenId,
RenName = x.RenName,
RenSurename = x.RenSurename,
RenAge = x.RenAge,
RenTel = x.RenTel,
StartWaterMeter = x.StartWaterMeter,
StartElecMeter = x.StartElecMeter,
RenSsnPicture = x.RenSsnPicture,
RenAgreement = x.RenAgreement,
DateTime = x.DateTime.ToString("dd MMMM yyyy"),
DateMonth = x.DateTime.ToString("MM-yyyy")
});
ViewBag.renters = renters;
}
var countrt = context.Roomtype.Count(me => me.Did == mydid || me.Tid == 0);
ViewBag.rt_count = countrt;
var rts = context.Roomtype.Where(my => my.Did == mydid || my.Tid == 0);
List <Roomtype> roomtypes = new List <Roomtype>();
foreach (var rta in rts)
{
roomtypes.Add(new Roomtype()
{
Tid = rta.Tid,
Type = rta.Type,
Price = rta.Price
});
ViewBag.roomtypes = roomtypes;
}
}
}
return(View());
}
public IActionResult EditRenter(myRenter renter, int did, int tid, IFormFile ssn, IFormFile agreement)
{
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
{
var ssnName = "";
var agreementName = "";
if (ssn != null)
{
var uploads = Path.Combine(he.WebRootPath, "uploads\\img_ssn");
ssnName = Guid.NewGuid().ToString().Substring(0, 10) + Path.GetExtension(ssn.FileName);
ssn.CopyTo(new FileStream(Path.Combine(uploads, ssnName), FileMode.Create));
}
if (agreement != null)
{
var uploads = Path.Combine(he.WebRootPath, "uploads\\agreement");
agreementName = Guid.NewGuid().ToString().Substring(0, 10) + Path.GetExtension(agreement.FileName);
agreement.CopyTo(new FileStream(Path.Combine(uploads, agreementName), FileMode.Create));
}
int mydid = did;
var context = new masdatabaseContext();
if (ssn == null & agreement == null)
{
var editroomtype = context.Room.First(b => b.Rid == renter.Rid);
editroomtype.Tid = tid;
context.SaveChanges();
var editrenter = context.Renter.First(a => a.RenId == renter.RenId);
editrenter.RenName = renter.RenName;
editrenter.RenSurename = renter.RenSurename;
editrenter.RenAge = renter.RenAge;
editrenter.RenTel = renter.RenTel;
editrenter.StartWaterMeter = renter.StartWaterMeter;
editrenter.StartElecMeter = renter.StartElecMeter;
context.SaveChanges();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลผู้เช่าสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
}
else if (ssn == null & agreement != null)
{
var editroomtype = context.Room.First(b => b.Rid == renter.Rid);
editroomtype.Tid = tid;
context.SaveChanges();
var editrenter = context.Renter.First(a => a.RenId == renter.RenId);
editrenter.RenName = renter.RenName;
editrenter.RenSurename = renter.RenSurename;
editrenter.RenAge = renter.RenAge;
editrenter.RenTel = renter.RenTel;
editrenter.StartWaterMeter = renter.StartWaterMeter;
editrenter.StartElecMeter = renter.StartElecMeter;
editrenter.RenAgreement = agreementName;
context.SaveChanges();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลผู้เช่าสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
}
else if (ssn != null & agreement == null)
{
var editroomtype = context.Room.First(b => b.Rid == renter.Rid);
editroomtype.Tid = tid;
context.SaveChanges();
var editrenter = context.Renter.First(a => a.RenId == renter.RenId);
editrenter.RenName = renter.RenName;
editrenter.RenSurename = renter.RenSurename;
editrenter.RenAge = renter.RenAge;
editrenter.RenTel = renter.RenTel;
editrenter.StartWaterMeter = renter.StartWaterMeter;
editrenter.StartElecMeter = renter.StartElecMeter;
editrenter.RenSsnPicture = ssnName;
context.SaveChanges();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลผู้เช่าสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
}
else if (ssn != null & agreement != null)
{
var editroomtype = context.Room.First(b => b.Rid == renter.Rid);
editroomtype.Tid = tid;
context.SaveChanges();
var editrenter = context.Renter.First(a => a.RenId == renter.RenId);
editrenter.RenName = renter.RenName;
editrenter.RenSurename = renter.RenSurename;
editrenter.RenAge = renter.RenAge;
editrenter.RenTel = renter.RenTel;
editrenter.StartWaterMeter = renter.StartWaterMeter;
editrenter.StartElecMeter = renter.StartElecMeter;
editrenter.RenSsnPicture = ssnName;
editrenter.RenAgreement = agreementName;
context.SaveChanges();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลผู้เช่าสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
}
return(RedirectToAction("ShowRoom", "Renter", new { did = mydid }));
}
}
public IActionResult EditProfiles(ProfileEdit pf, IFormFile picture)
{
var context = new masdatabaseContext();
if (HttpContext.Session.GetInt32("Oid") == null)
{
return(RedirectToAction("Login", "User"));
}
else
{
SqlConnection sqlcon = new SqlConnection("Data Source=(LocalDb)\\MSSQLLocalDb;Initial Catalog=MasSql;Integrated Security=True");
if (picture != null)
{
var fileName = "";
var uploads = Path.Combine(he.WebRootPath, "uploads\\img_profile");
fileName = Guid.NewGuid().ToString().Substring(0, 10) + Path.GetExtension(picture.FileName);
picture.CopyTo(new FileStream(Path.Combine(uploads, fileName), FileMode.Create));
if (pf.Picture != null)
{
var editOwner = context.Owner.First(a => a.Oid == HttpContext.Session.GetInt32("Oid"));
editOwner.Name = pf.Name;
editOwner.Surname = pf.Surname;
editOwner.Tel = pf.Tel;
context.SaveChanges();
sqlcon.Open();
string query1 = "UPDATE owner SET Name='" + pf.Name + "',Surname='" + pf.Surname + "',Tel='" + pf.Tel + "' WHERE Oid = " + HttpContext.Session.GetInt32("Oid") + " ";
SqlCommand sqlcom1 = new SqlCommand(query1);
sqlcom1.Connection = sqlcon;
SqlDataReader sqlReader1 = sqlcom1.ExecuteReader();
sqlcon.Close();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
HttpContext.Session.SetString("Name", pf.Name);
HttpContext.Session.SetString("Surname", pf.Surname);
HttpContext.Session.SetString("Tel", pf.Tel);
return(RedirectToAction("ManageDorm", "Manage"));
}
else
{
var editOwner = context.Owner.First(a => a.Oid == HttpContext.Session.GetInt32("Oid"));
editOwner.Name = pf.Name;
editOwner.Surname = pf.Surname;
editOwner.Tel = pf.Tel;
editOwner.Picture = fileName;
context.SaveChanges();
sqlcon.Open();
string query1 = "UPDATE owner SET Name='" + pf.Name + "',Surname='" + pf.Surname + "',Tel='" + pf.Tel + "',Picture='" + fileName + "' WHERE Oid = " + HttpContext.Session.GetInt32("Oid") + " ";
SqlCommand sqlcom1 = new SqlCommand(query1);
sqlcom1.Connection = sqlcon;
SqlDataReader sqlReader1 = sqlcom1.ExecuteReader();
sqlcon.Close();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
HttpContext.Session.SetString("Name", pf.Name);
HttpContext.Session.SetString("Surname", pf.Surname);
HttpContext.Session.SetString("Tel", pf.Tel);
HttpContext.Session.SetString("Picture", fileName);
return(RedirectToAction("ManageDorm", "Manage"));
}
}
else
{
if (pf.Picture != null)
{
var editOwner = context.Owner.First(a => a.Oid == HttpContext.Session.GetInt32("Oid"));
editOwner.Name = pf.Name;
editOwner.Surname = pf.Surname;
editOwner.Tel = pf.Tel;
context.SaveChanges();
sqlcon.Open();
string query1 = "UPDATE owner SET Name='" + pf.Name + "',Surname='" + pf.Surname + "',Tel='" + pf.Tel + "' WHERE Oid = " + HttpContext.Session.GetInt32("Oid") + " ";
SqlCommand sqlcom1 = new SqlCommand(query1);
sqlcom1.Connection = sqlcon;
SqlDataReader sqlReader1 = sqlcom1.ExecuteReader();
sqlcon.Close();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
HttpContext.Session.SetString("Name", pf.Name);
HttpContext.Session.SetString("Surname", pf.Surname);
HttpContext.Session.SetString("Tel", pf.Tel);
return(RedirectToAction("ManageDorm", "Manage"));
}
else
{
var editOwner = context.Owner.First(a => a.Oid == HttpContext.Session.GetInt32("Oid"));
editOwner.Name = pf.Name;
editOwner.Surname = pf.Surname;
editOwner.Tel = pf.Tel;
context.SaveChanges();
sqlcon.Open();
string query1 = "UPDATE owner SET Name='" + pf.Name + "',Surname='" + pf.Surname + "',Tel='" + pf.Tel + "' WHERE Oid = " + HttpContext.Session.GetInt32("Oid") + " ";
SqlCommand sqlcom1 = new SqlCommand(query1);
sqlcom1.Connection = sqlcon;
SqlDataReader sqlReader1 = sqlcom1.ExecuteReader();
sqlcon.Close();
TempData["EditSuccessful"] = "<script>swal({type: 'success', title: 'แก้ไขข้อมูลสำเร็จ', showConfirmButton: false, timer: 1500,backdrop: 'rgba(0,0, 26,0.8)' })</script>";
HttpContext.Session.SetString("Name", pf.Name);
HttpContext.Session.SetString("Surname", pf.Surname);
HttpContext.Session.SetString("Tel", pf.Tel);
return(RedirectToAction("ManageDorm", "Manage"));
}
}
}
}
