public ActionResult Insert(MPacket viewModel, FormCollection formCollection)
        {
            UpdateNumericData(viewModel, formCollection);

            MPacket mPacketToInsert = new MPacket();

            TransferFormValuesTo(mPacketToInsert, viewModel);

            mPacketToInsert.SetAssignedIdTo(viewModel.Id);
            mPacketToInsert.CreatedDate = DateTime.Now;
            mPacketToInsert.CreatedBy   = User.Identity.Name;
            mPacketToInsert.DataStatus  = EnumDataStatus.New.ToString();

            _mPacketRepository.Save(mPacketToInsert);

            try
            {
                _mPacketRepository.DbContext.CommitChanges();
            }
            catch (Exception e)
            {
                _mPacketRepository.DbContext.RollbackTransaction();

                //throw e.GetBaseException();
                return(Content(e.GetBaseException().Message));
            }

            return(Content("success"));
        }
        public IEnumerable <MPacketItemCat> GetPagedItemList(string orderCol, string orderBy, int pageIndex, int maxRows, ref int totalRows, string packetId)
        {
            MPacket mPacket = null;

            if (!string.IsNullOrEmpty(packetId))
            {
                mPacket = new MPacketRepository().Get(packetId);
            }

            ICriteria criteria = Session.CreateCriteria(typeof(MPacketItemCat));

            //calculate total rows
            if (mPacket != null)
            {
                criteria.Add(Expression.Eq("PacketId", mPacket));
            }
            totalRows = criteria
                        .SetProjection(Projections.RowCount())
                        .FutureValue <int>().Value;

            //get list results
            criteria = Session.CreateCriteria(typeof(MPacketItemCat));
            if (mPacket != null)
            {
                criteria.Add(Expression.Eq("PacketId", mPacket));
            }
            criteria.SetMaxResults(maxRows)
            .SetFirstResult((pageIndex - 1) * maxRows)
            .AddOrder(new Order(orderCol, orderBy.Equals("asc") ? true : false))
            ;

            IEnumerable <MPacketItemCat> list = criteria.List <MPacketItemCat>();

            return(list);
        }
 public virtual ActionResult Get(string id)
 {
     if (!string.IsNullOrEmpty(id))
     {
         MPacket mPacket = _mPacketRepository.Get(id);
     }
     return(Content("0"));
 }
 private void TransferFormValuesTo(MPacket mPacketToUpdate, MPacket mPacketFromForm)
 {
     mPacketToUpdate.PacketName     = mPacketFromForm.PacketName;
     mPacketToUpdate.PacketPrice    = mPacketFromForm.PacketPrice;
     mPacketToUpdate.PacketPriceVip = mPacketFromForm.PacketPriceVip;
     mPacketToUpdate.PacketStatus   = mPacketFromForm.PacketStatus;
     mPacketToUpdate.PacketDesc     = mPacketFromForm.PacketDesc;
 }
Exemple #5
0
        private void bindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            if (!ValidateForm())
            {
                return;
            }

            if (packetIdTextBox.Enabled == true)
            {
                paket = new MPacket();
            }
            else
            {
                paket = (MPacket)DataMaster.GetObjectByProperty(typeof(MPacket), MPacket.ColumnNames.PacketId, packetIdTextBox.Text);
            }

            paket.PacketId       = packetIdTextBox.Text;
            paket.PacketName     = packetNameTextBox.Text;
            paket.PacketDiscount = packetDiscountNumericUpDown.Value;
            paket.PacketPrice    = packetPriceNumericUpDown.Value;
            paket.PacketPriceAvg = packetPriceAvgNumericUpDown.Value;
            paket.PacketDesc     = packetDescTextBox.Text;
            paket.ModifiedBy     = lbl_UserName.Text;
            paket.ModifiedDate   = DateTime.Now;

            if (packetIdTextBox.Enabled == true)
            {
                try
                {
                    DataMaster.SavePersistence(paket);
                }
                catch (NHibernate.NonUniqueObjectException)
                {
                    RecreateBalloon();
                    balloonHelp.Caption = "Validasi data kurang";
                    balloonHelp.Content = "Obat puyer dengan kode " + packetIdTextBox.Text + " sudah pernah diinput, silahkan input dengan kode yang lain";
                    balloonHelp.ShowBalloon(packetIdTextBox);
                    packetIdTextBox.Focus();
                    return;
                }
                ModuleControlSettings.SaveLog(ListOfAction.Insert, packetIdTextBox.Text, ListOfTable.MPacket, lbl_UserName.Text);
            }
            else
            {
                DataMaster.UpdatePersistence(paket);
                ModuleControlSettings.SaveLog(ListOfAction.Update, packetIdTextBox.Text, ListOfTable.MPacket, lbl_UserName.Text);
            }
            DeleteItemPacket();
            SaveItemPacket();
            BindData();
        }
        public ActionResult InsertBill(TTransDet viewModel, FormCollection formCollection, string transId)
        {
            //_tTransDetRepository.DbContext.BeginTransaction();
            TTrans trans = _tTransRepository.Get(transId);

            UpdateNumericData(viewModel, formCollection);
            TTransDet transDetToInsert = new TTransDet(trans);
            MEmployee emp    = _mEmployeeRepository.Get(formCollection["EmployeeId"]);
            MPacket   packet = _mPacketRepository.Get(formCollection["PacketId"]);

            TransferFormValuesTo(transDetToInsert, viewModel);
            transDetToInsert.SetAssignedIdTo(Guid.NewGuid().ToString());
            transDetToInsert.PacketId   = packet;
            transDetToInsert.EmployeeId = emp;

            decimal?TotalToCalculate = transDetToInsert.TransDetTotal -
                                       (transDetToInsert.TransDetTotal * trans.TransDiscount / 100);

            transDetToInsert.TransDetCommissionService = CalculateCommission(emp, packet, TotalToCalculate);

            transDetToInsert.CreatedDate = DateTime.Now;
            transDetToInsert.CreatedBy   = User.Identity.Name;
            transDetToInsert.DataStatus  = EnumDataStatus.New.ToString();
            //_tTransDetRepository.Save(transDetToInsert);
            //try
            //{
            //    _tTransDetRepository.DbContext.CommitTransaction();
            //    TempData[EnumCommonViewData.SaveState.ToString()] = EnumSaveState.Success;
            //    return Content("success");
            //}
            //catch (Exception ex)
            //{
            //    _tTransDetRepository.DbContext.RollbackTransaction();
            //    TempData[EnumCommonViewData.SaveState.ToString()] = EnumSaveState.Failed;
            //    return Content(ex.Message);
            //}

            //save temporary to session, then display transdetitem form
            Session[CONST_TRANSDET] = transDetToInsert;
            var e = new
            {
                transDetToInsert.Id,
                PacketId = transDetToInsert.PacketId.Id,
                transDetToInsert.TransDetQty
            };

            return(Json(e, JsonRequestBehavior.AllowGet));
        }
        public MPacketComm GetByEmployeeAndPacket(MEmployee emp, MPacket packet)
        {
            StringBuilder sql = new StringBuilder();

            sql.AppendLine(@"   select p
                                from MPacketComm as p");
            sql.AppendLine(@" where p.EmployeeId = :emp");
            sql.AppendLine(@"   and p.PacketId = :packet");

            IQuery q = Session.CreateQuery(sql.ToString());

            q.SetEntity("emp", emp);
            q.SetEntity("packet", packet);

            return(q.UniqueResult <MPacketComm>());
        }
        public virtual ActionResult GetList()
        {
            var           packets = _mPacketRepository.GetAll();
            StringBuilder sb      = new StringBuilder();
            MPacket       mPacket = new MPacket();

            sb.AppendFormat("{0}:{1};", string.Empty, "-Pilih Paket-");
            for (int i = 0; i < packets.Count; i++)
            {
                mPacket = packets[i];
                sb.AppendFormat("{0}:{1}", mPacket.Id, mPacket.PacketName);
                if (i < packets.Count - 1)
                {
                    sb.Append(";");
                }
            }
            return(Content(sb.ToString()));
        }
Exemple #9
0
        private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(packetIdTextBox.Text.Trim()))
            {
                if (MessageBox.Show("Anda yakin menghapus data?", "Konfirmasi Hapus Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    //delete paket
                    paket = (MPacket)DataMaster.GetObjectByProperty(typeof(MPacket), MPacket.ColumnNames.PacketId, packetIdTextBox.Text);
                    DataMaster.Delete(paket);

                    //delete item paket
                    DeleteItemPacket();

                    ModuleControlSettings.SaveLog(ListOfAction.Delete, packetIdTextBox.Text, ListOfTable.MPacket, lbl_UserName.Text);
                    BindData();
                }
            }
        }
 private static void UpdateNumericData(MPacket viewModel, FormCollection formCollection)
 {
     if (!string.IsNullOrEmpty(formCollection["PacketPrice"]))
     {
         string PacketPrice = formCollection["PacketPrice"].Replace(",", "");
         viewModel.PacketPrice = Convert.ToDecimal(PacketPrice);
     }
     else
     {
         viewModel.PacketPrice = null;
     }
     if (!string.IsNullOrEmpty(formCollection["PacketPriceVip"]))
     {
         string PacketPriceVip = formCollection["PacketPriceVip"].Replace(",", "");
         viewModel.PacketPriceVip = Convert.ToDecimal(PacketPriceVip);
     }
     else
     {
         viewModel.PacketPriceVip = null;
     }
 }
        /// <summary>
        /// calculate commission,
        /// if packet commission available, use it,
        /// else use global commission
        /// </summary>
        /// <param name="emp"></param>
        /// <param name="packet"></param>
        /// <param name="totalTrans"></param>
        /// <returns></returns>
        private decimal?CalculateCommission(MEmployee emp, MPacket packet, decimal?totalTrans)
        {
            decimal?    commission     = 0;
            string      typeCommission = emp.EmployeeCommissionServiceType;
            decimal?    commissionVal  = emp.EmployeeCommissionServiceVal;
            MPacketComm packetComm     = _mPacketCommRepository.GetByEmployeeAndPacket(emp, packet);

            if (packetComm != null)
            {
                typeCommission = packetComm.PacketCommType;
                commissionVal  = packetComm.PacketCommVal;
            }
            if (typeCommission == EnumCommissionType.Percent.ToString())
            {
                commission = totalTrans * (commissionVal / 100);
            }
            else
            {
                commission = commissionVal;
            }
            return(commission);
        }
        public ActionResult Delete(MItem viewModel, FormCollection formCollection)
        {
            MPacket mPacketToDelete = _mPacketRepository.Get(viewModel.Id);

            if (mPacketToDelete != null)
            {
                _mPacketRepository.Delete(mPacketToDelete);
            }

            try
            {
                _mPacketRepository.DbContext.CommitChanges();
            }
            catch (Exception e)
            {
                _mPacketRepository.DbContext.RollbackTransaction();

                return(Content(e.GetBaseException().Message));
            }

            return(Content("success"));
        }
        public ActionResult Update(MPacket viewModel, FormCollection formCollection)
        {
            UpdateNumericData(viewModel, formCollection);
            MPacket mPacketToUpdate = _mPacketRepository.Get(viewModel.Id);

            TransferFormValuesTo(mPacketToUpdate, viewModel);
            mPacketToUpdate.ModifiedDate = DateTime.Now;
            mPacketToUpdate.ModifiedBy   = User.Identity.Name;
            mPacketToUpdate.DataStatus   = EnumDataStatus.Updated.ToString();

            try
            {
                _mPacketRepository.DbContext.CommitChanges();
            }
            catch (Exception e)
            {
                _mPacketRepository.DbContext.RollbackTransaction();

                return(Content(e.GetBaseException().Message));
            }

            return(Content("success"));
        }