public ActionResult Insert(MRoom viewModel, FormCollection formCollection) { MRoom mRoomToInsert = new MRoom(); TransferFormValuesTo(mRoomToInsert, viewModel); mRoomToInsert.SetAssignedIdTo(viewModel.Id); mRoomToInsert.CreatedDate = DateTime.Now; mRoomToInsert.CreatedBy = User.Identity.Name; mRoomToInsert.DataStatus = EnumDataStatus.New.ToString(); _mRoomRepository.Save(mRoomToInsert); try { _mRoomRepository.DbContext.CommitChanges(); } catch (Exception e) { _mRoomRepository.DbContext.RollbackTransaction(); //throw e.GetBaseException(); return(Content(e.GetBaseException().Message)); } return(Content("success")); }
public virtual ActionResult GetJsonTransRoom(string roomId) { MRoom room = _mRoomRepository.Get(roomId); TTransRoom troom = _tTransRoomRepository.GetByRoom(room); DateTime? TransDate = DateTime.Today; if (troom == null) { troom = new TTransRoom(); troom.SetAssignedIdTo(Guid.NewGuid().ToString()); troom.RoomStatus = EnumTransRoomStatus.New.ToString(); troom.RoomInDate = DateTime.Now; } else { TransDate = troom.TransId.TransDate; } var t = new { troom.Id, troom.RoomInDate, troom.RoomOutDate, troom.RoomStatus, troom.RoomBookDate, troom.RoomCommissionService, troom.RoomCommissionProduct, TransDate, IsVipRoom = room.RoomStatus.Equals(EnumRoomStatus.VIP.ToString()).ToString() }; return(Json(t, JsonRequestBehavior.AllowGet)); }
public virtual ActionResult Get(string id) { if (!string.IsNullOrEmpty(id)) { MRoom mRoom = _mRoomRepository.Get(id); } return(Content("0")); }
private void TransferFormValuesTo(MRoom mRoomToUpdate, MRoom mRoomFromForm) { mRoomToUpdate.RoomName = mRoomFromForm.RoomName; mRoomToUpdate.RoomOrderNo = mRoomFromForm.RoomOrderNo; mRoomToUpdate.RoomType = mRoomFromForm.RoomType; mRoomToUpdate.RoomStatus = mRoomFromForm.RoomStatus; mRoomToUpdate.RoomDesc = mRoomFromForm.RoomDesc; }
private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(roomIdTextBox.Text.Trim())) { if (MessageBox.Show("Anda yakin menghapus data?", "Konfirmasi Hapus Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { room = (MRoom)DataMaster.GetObjectByProperty(typeof(MRoom), MRoom.ColumnNames.RoomId, roomIdTextBox.Text); DataMaster.Delete(room); ModuleControlSettings.SaveLog(ListOfAction.Delete, roomIdTextBox.Text, ListOfTable.MRoom, lbl_UserName.Text); BindData(); } } }
private void bindingNavigatorSaveItem_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } if (roomIdTextBox.Enabled == true) { room = new MRoom(); } else { room = (MRoom)DataMaster.GetObjectByProperty(typeof(MRoom), MRoom.ColumnNames.RoomId, roomIdTextBox.Text); } room.RoomComission = roomComissionNumericUpDown.Value; room.RoomDesc = roomDescTextBox.Text; room.RoomId = roomIdTextBox.Text; room.RoomName = roomNameTextBox.Text; room.ModifiedBy = lbl_UserName.Text; room.ModifiedDate = DateTime.Now; if (roomIdTextBox.Enabled == true) { try { DataMaster.SavePersistence(room); } catch (NHibernate.NonUniqueObjectException) { RecreateBalloon(); balloonHelp.Caption = "Validasi data kurang"; balloonHelp.Content = "Ruangan dengan kode " + roomIdTextBox.Text + " sudah pernah diinput, silahkan input dengan kode yang lain"; balloonHelp.ShowBalloon(roomIdTextBox); roomIdTextBox.Focus(); return; } ModuleControlSettings.SaveLog(ListOfAction.Insert, roomIdTextBox.Text, ListOfTable.MRoom, lbl_UserName.Text); } else { DataMaster.UpdatePersistence(room); ModuleControlSettings.SaveLog(ListOfAction.Update, roomIdTextBox.Text, ListOfTable.MRoom, lbl_UserName.Text); } BindData(); }
public virtual ActionResult GetList() { var rooms = _mRoomRepository.GetAll(); StringBuilder sb = new StringBuilder(); MRoom mRoom = new MRoom(); sb.AppendFormat("{0}:{1};", string.Empty, "-Pilih Ruangan-"); for (int i = 0; i < rooms.Count; i++) { mRoom = rooms[i]; sb.AppendFormat("{0}:{1}", mRoom.Id, mRoom.RoomName); if (i < rooms.Count - 1) { sb.Append(";"); } } return(Content(sb.ToString())); }
private static IList <RoomViewModel> GetRoomViewModel(ITTransRoomRepository transRoomRepository, IList <MRoom> listRoom) { IList <RoomViewModel> result = new List <RoomViewModel>(); RoomViewModel rvm = null; MRoom r = null; TTransRoom troom = null; for (int i = 0; i < listRoom.Count; i++) { rvm = new RoomViewModel(); r = listRoom[i]; rvm.SetAssignedIdTo(r.Id); rvm.RoomName = r.RoomName; rvm.RoomInUsed = transRoomRepository.GetByRoom(r) != null; result.Add(rvm); } return(result); }
public TTransRoom GetByRoom(MRoom room) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@" select troom from TTransRoom as troom where troom.RoomStatus = :RoomStatus "); if (room != null) { sql.AppendLine(@" and troom.RoomId = :room"); } IQuery q = Session.CreateQuery(sql.ToString()); q.SetString("RoomStatus", Enums.EnumTransRoomStatus.In.ToString()); if (room != null) { q.SetEntity("room", room); } return(q.UniqueResult <TTransRoom>()); }
public IList <TTransDet> GetListByRoom(MRoom room) { StringBuilder sql = new StringBuilder(); sql.AppendLine(@" select det from TTransDet as det left outer join det.TransId trans, TTransRoom transRoom where trans.Id = transRoom.Id and trans.TransStatus = :TransStatus "); if (room != null) { sql.AppendLine(@" and transRoom.RoomId = :room"); } IQuery q = Session.CreateQuery(sql.ToString()); q.SetString("TransStatus", Enums.EnumTransactionStatus.Service.ToString()); if (room != null) { q.SetEntity("room", room); } return(q.List <TTransDet>()); }
public ActionResult Delete(MRoom viewModel, FormCollection formCollection) { MRoom mPacketToDelete = _mRoomRepository.Get(viewModel.Id); if (mPacketToDelete != null) { _mRoomRepository.Delete(mPacketToDelete); } try { _mRoomRepository.DbContext.CommitChanges(); } catch (Exception e) { _mRoomRepository.DbContext.RollbackTransaction(); return(Content(e.GetBaseException().Message)); } return(Content("success")); }
public ActionResult Update(MRoom viewModel, FormCollection formCollection) { MRoom mRoomToUpdate = _mRoomRepository.Get(viewModel.Id); TransferFormValuesTo(mRoomToUpdate, viewModel); mRoomToUpdate.ModifiedDate = DateTime.Now; mRoomToUpdate.ModifiedBy = User.Identity.Name; mRoomToUpdate.DataStatus = EnumDataStatus.Updated.ToString(); try { _mRoomRepository.DbContext.CommitChanges(); } catch (Exception e) { _mRoomRepository.DbContext.RollbackTransaction(); return(Content(e.GetBaseException().Message)); } return(Content("success")); }
private static IList <RoomViewModel> GetRoomViewModel(ITTransRoomRepository transRoomRepository, IMCustomerRepository mCustomerRepository, IList <MRoom> listRoom) { IList <RoomViewModel> result = new List <RoomViewModel>(); RoomViewModel rvm = null; MRoom r = null; TTransRoom troom = null; for (int i = 0; i < listRoom.Count; i++) { rvm = new RoomViewModel(); r = listRoom[i]; troom = transRoomRepository.GetByRoom(r); rvm.SetAssignedIdTo(r.Id); rvm.RoomName = r.RoomName; if (troom != null) { rvm.RoomInUsed = true; rvm.CustomerName = Helper.CommonHelper.GetCustomerName(mCustomerRepository, troom.TransId.TransBy); } result.Add(rvm); } return(result); }