public void SaveArea(string Id, string Address, string Comment) { string comm = Globals.StringIsEmpty(Comment) ? "NULL" : "'" + Comment + "'"; string query = "UPDATE Areas SET Address='" + Address + "', Comment=" + comm + " WHERE IdArea=" + Id; DbMess.DoAction(query); }
public void AddArea(string Id, string Address, string Comment) { if (!Globals.StringIsEmpty(Address)) { string comm = Globals.StringIsEmpty(Comment) ? "NULL" : "'" + Comment + "'"; string query = "INSERT INTO Areas VALUES('" + Address + "'," + comm + ", 0)"; DbMess.DoAction(query); } }
public void AddOrganization(string Id, string Name, string Mail, string Phone, string Fio) { string mail = Globals.StringIsEmpty(Mail) ? "NULL" : "'" + Mail + "'"; string phone = Globals.StringIsEmpty(Phone) ? "NULL" : "'" + Phone + "'"; string fio = Globals.StringIsEmpty(Fio) ? "NULL" : "'" + Fio + "'"; string query = "INSERT INTO Organizations VALUES('" + Name + "'," + mail + "," + phone + "," + fio + ", 0)"; DbMess.DoAction(query); }
public void SaveOrganization(string Id, string Name, string Mail, string Phone, string Fio) { string mail = Globals.StringIsEmpty(Mail) ? "NULL" : "'" + Mail + "'"; string phone = Globals.StringIsEmpty(Phone) ? "NULL" : "'" + Phone + "'"; string fio = Globals.StringIsEmpty(Fio) ? "NULL" : "'" + Fio + "'"; string query = "UPDATE Organizations SET Name='" + Name + "', Email=" + mail + ",Phone=" + phone + ", ContactFio=" + fio + " WHERE IdOrganization=" + Id; DbMess.DoAction(query); }
public ActionResult SaveLecturer(string Id, string FIO, string OrganizationId, string Email, string Phone, HttpPostedFileBase newAvatar) { Console.WriteLine("bp"); //1) сохранить фотографию string query = ""; if (newAvatar != null) { string fileName = Globals.GetRandomName(10); string avatarExtension = "." + newAvatar.FileName.Split('.').Last(); string picturePath = null; string normalPath = "/Files/Avatars/" + fileName + avatarExtension; picturePath = Server.MapPath("~/Files/Avatars/" + fileName + avatarExtension); newAvatar.SaveAs(picturePath); //2) проверить, есть ли уже у этого препода фотография query = "SELECT AvatarFileId FROM Lecturers WHERE IdLecturer=" + Id; string fileId = DbMess.GetValue(query); if (!Globals.StringIsEmpty(fileId)) { //3.a) если есть, заменить путь query = "UPDATE Files SET Path='" + picturePath + "' WHERE IdFile=" + fileId; DbMess.DoAction(query); } else { //3.b) если нет, инсёртнуть, забрать айдишник, и обновить поле у проеподавателя query = "INSERT INTO FILES VALUES('" + picturePath + "', '" + normalPath + "', GETDATE())"; DbMess.DoAction(query); query = "SELECT MAX(IdFile) FROM Files"; query = "UPDATE Lecturers SET AvatarFileId=" + DbMess.GetValue(query); DbMess.DoAction(query); } } string org = Globals.StringIsEmpty(OrganizationId) ? "NULL" : OrganizationId; string mail = Globals.StringIsEmpty(Email) ? "NULL" : "'" + Email + "'"; string phone = Globals.StringIsEmpty(Phone) ? "NULL" : "'" + Phone + "'"; //теперь обновить остальные поля )) query = "UPDATE Lecturers SET FIO='" + FIO + "', OrganizationId=" + org + ", Email=" + mail + ", ContactPhone=" + phone + " WHERE IdLecturer=" + Id; DbMess.DoAction(query); return(Redirect("/catalog/lecturers")); }
public void addCouse(string Id, string Name, bool IsRemote, string Length, string Type) { double finalLength = 0; string length = ""; if (double.TryParse(Length, out finalLength)) { length = finalLength.ToString(); } else { length = "NULL"; } string query = "INSERT INTO Courses VALUES('" + Name + "', " + Convert.ToInt32(IsRemote) + ", " + length + ", " + Type + ", 0)"; DbMess.DoAction(query); }
public void SaveCouse(string Id, string Name, bool IsRemote, string Length, string Type) { double finalLength = 0; string length = ""; if (double.TryParse(Length, out finalLength)) { length = finalLength.ToString(); } else { length = "NULL"; } string query = "UPDATE Courses SET Name='" + Name + "', IsRemote=" + Convert.ToInt32(IsRemote) + ", LengthInHours=" + length + ", ResultType=" + Type + " WHERE IdCourse=" + Id; DbMess.DoAction(query); }
public void DeleteArea(string Id) { string query = "UPDATE Areas SET IsDeleted=1 WHERE IdArea=" + Id; DbMess.DoAction(query); }
public void DeleteOrganization(string id) { string query = "UPDATE Organizations SET IsDeleted=1 WHERE IdOrganization=" + id; DbMess.DoAction(query); }
public void DeleteCourse(string Id) { string query = "UPDATE Courses SET IsDeleted=1 WHERE IdCourse=" + Id; DbMess.DoAction(query); }