public static bool CreateForm(OdbcDataReader reader, Room room) { int fCount = reader.FieldCount; for (int i = 0; i < fCount; i++) { string name = reader.GetName(i); // Map to DB field. Need to change if db changed switch (name) { case "room_id": room._roomID = reader.GetInt32(i); break; case "branch_id": room._branchID = reader.GetInt32(i); break; case "name": room._name = reader.GetString(i); break; case "seat_no": room._seatNo = reader.GetInt32(i); break; case "img": room._img = reader.GetString(i); break; case "description": room._description = reader.GetString(i); break; // helper info case "branch_name": room._branchName = reader.GetString(i); break; } } return reader.HasRows; }
public void DoEditRoom(string roomID) { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); theRoom = new Room(); if (!theRoom.LoadFromDB(db, "room_id=" + roomID)) theRoom = null; branchList = Branch.LoadListFromDB(db, ""); db.Close(); }
protected void DoAddSubmitRoom() { try { Room r = new Room(); // validate data r._name = Request["roomname"]; r._branchID = Int32.Parse(Request["branch_id"]); r._seatNo = Int32.Parse(Request["seat_no"]); r._description = Request["description"]; r._img = "noimg.jpg"; if (portrait.PostedFile.FileName != "") { string serverFileExt = Path.GetExtension(portrait.PostedFile.FileName); Random rand = new Random((int)DateTime.Now.Ticks); string fullpath = ""; string imgname = ""; do { string randomFName = rand.Next(Int32.MaxValue).ToString(); imgname = randomFName + serverFileExt; fullpath = Config.PATH_APP_ROOT + "\\" + Config.URL_PIC_ROOM + "\\" + imgname; } while (File.Exists(fullpath)); portrait.PostedFile.SaveAs(fullpath); r._img = imgname; } // Save to DB DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); db.Connect(); r.AddToDB(db); db.Close(); } catch (Exception err) { errorText = err.Message + err.StackTrace; Response.Redirect("RoomManage.aspx?actPage=add&errorText=ข้อมูลไม่ถูกต้อง โปรดตรวจสอบอีกครั้ง"); } }
protected void DoDeleteRoom(string roomID) { Room t = new Room(); t._roomID = Int32.Parse(roomID); DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); db.Connect(); t.DeleteToDB(db); db.Close(); }
public static Room CreateForm(OdbcDataReader reader) { Room room = new Room(); Room.CreateForm(reader, room); return room; }
public static Room[] LoadListFromDBCustom(DBManager db, string sqlAll) { OdbcDataReader reader = db.Query(sqlAll); LinkedList<Room> list = new LinkedList<Room>(); while (reader.Read()) { list.AddLast(Room.CreateForm(reader)); } Room[] entities = new Room[list.Count]; int i = 0; foreach (Room r in list) { entities[i++] = r; } return entities; }