public int UpdateOrInsertRoomType(tbl_Room_Type obj)
{
try
{
using (var db = _connectionData.OpenDbConnection())
{
if (obj.Id > 0)
{
var query = db.From <tbl_Room_Type>().Where(e => e.Id == obj.Id);
var objUpdate = db.Select(query).SingleOrDefault();
if (objUpdate != null)
{
//objUpdate.Code = obj.Code;
objUpdate.Name = obj.Name;
objUpdate.Note = obj.Note;
//objUpdate.HotelID =comm.GetHotelId();
return(db.Update(objUpdate));
}
return(-1);
}
var rd = new Random();
var id = rd.Next(1, 10);
var code = comm.GetHotelCode().Trim() + id;
obj.Code = code;
obj.HotelID = comm.GetHotelId();
return((int)db.Insert(obj, true));
}
}
catch (Exception)
{
return(-1);
}
}
public tbl_Room_Type GetRoomTypeByRoomID(int roomid)
{
//search again
using (var db = _connectionData.OpenDbConnection())
{
var query = db.From <tbl_Room_Type>().Join <tbl_Room>((e1, e2) => e1.Id == e2.RoomType_ID && e2.Id == roomid);
tbl_Room_Type rows = db.Select <tbl_Room_Type>(query).SingleOrDefault();
return(rows);
}
}
public ActionResult Update(tbl_Room_Type obj)
{
var result = _service.UpdateOrInsertRoomType(obj);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
