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);
}
