public int Save(AllocateClassRomm allocateClassRomm) { SqlConnection connection = new SqlConnection(connectionString); string query = "INSERT INTO AllocateClassRoom(CourseId, RoomId, Day, FromHour, FromMin, FromDay, ToHour, ToMin, ToDay, Status) VALUES('" + allocateClassRomm.CourseId + "','" + allocateClassRomm.RoomId + "', '" + allocateClassRomm.Day + "', '" + allocateClassRomm.FromHour + "', '" + allocateClassRomm.FromMin + "', '" + allocateClassRomm.FromDay + "', '" + allocateClassRomm.ToHour + "', '" + allocateClassRomm.ToMin + "', '" + allocateClassRomm.ToDay + "', '" + 1 + "')"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return(rowAffected); }
public bool UnallocateAllRoom() { SqlConnection connection = new SqlConnection(connectionString); string query = "Select * from AllocateClassRoom where Status='" + 1 + "'"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <AllocateClassRomm> roomList = new List <AllocateClassRomm>(); while (reader.Read()) { AllocateClassRomm rooms = new AllocateClassRomm(); rooms.Id = Convert.ToInt32(reader["Id"].ToString()); //rooms.StudentId = Convert.ToInt32(reader["StudentId"].ToString()); rooms.CourseId = Convert.ToInt32(reader["CourseId"].ToString()); //rooms.Date = Convert.ToDateTime(reader["EnrollmentDate"].ToString()); rooms.Status = Convert.ToInt32(reader["Status"].ToString()); roomList.Add(rooms); } reader.Close(); connection.Close(); if (roomList.Count == 0) { return(false); } else { foreach (var room in roomList) { string query1 = "UPDATE AllocateClassRoom SET Status='" + 0 + " '"; SqlCommand command1 = new SqlCommand(query1, connection); connection.Open(); int rowAffected = command1.ExecuteNonQuery(); connection.Close(); } return(true); } }
public ActionResult Save(AllocateClassRomm allocateClassRomm) { if (ModelState.IsValid) { int isSaved = allocateRoomManager.Save(allocateClassRomm); if (isSaved > 0) { TempData["Message"] = "Saved Successfully."; } else { TempData["Message"] = "Failed."; } return(Redirect("Index")); } else { return(Redirect("Index")); } }
public int Save(AllocateClassRomm allocateClassRomm) { return(allocateRoomGateWay.Save(allocateClassRomm)); }