示例#1
0
        public ActionResult DeleteConfirmed(int id)
        {
            Paysheet paysheet = db.Paysheets.Find(id);

            db.Paysheets.Remove(paysheet);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
示例#2
0
 public void PaymentPayroll(Paysheet paysheet)
 {
     using (var en = new DB_SystemFoodTrucksEntities())
     {
         en.Paysheet.Add(paysheet);
         en.SaveChanges();
     }
 }
示例#3
0
 public ActionResult Edit([Bind(Include = "Id,CustomerID,Chit_num,TruckLic_num,Job_num,DestinationID,Date_of_delivery,RateID,DriversID")] Paysheet paysheet)
 {
     if (ModelState.IsValid)
     {
         db.Entry(paysheet).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.CustomerID    = new SelectList(db.Customers, "Id", "FirstName", paysheet.CustomerID);
     ViewBag.DestinationID = new SelectList(db.Destinations, "Id", "Name", paysheet.DestinationID);
     ViewBag.DriversID     = new SelectList(db.Drivers, "Id", "FirstName", paysheet.DriversID);
     ViewBag.RateID        = new SelectList(db.Rates, "Id", "Name", paysheet.RateID);
     return(View(paysheet));
 }
示例#4
0
        // GET: Paysheets/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Paysheet paysheet = db.Paysheets.Find(id);

            if (paysheet == null)
            {
                return(HttpNotFound());
            }
            return(View(paysheet));
        }
示例#5
0
        public void PayrollWithLoan(Paysheet paysheet, Mov_CxC_Employees mov_CxC)
        {
            using (var en = new DB_SystemFoodTrucksEntities())
            {
                using (DbContextTransaction transaction = en.Database.BeginTransaction())
                {
                    try
                    {
                        //var payment_bd = new Paysheet()
                        //{
                        //    Amount = paysheet.Amount,
                        //    Payment_date = paysheet.Payment_date,
                        //    Id_employee = paysheet.Id_employee,
                        //    Note = paysheet.Note
                        //};
                        en.Paysheet.Add(paysheet);
                        en.SaveChanges();

                        var updateloan_bd = en.Mov_CxC_Employees.First(m => m.Id_employee == mov_CxC.Id_employee && m.Transaction_type == 1);
                        updateloan_bd.Amount_rest = mov_CxC.Amount_rest;
                        updateloan_bd.FeeRest     = mov_CxC.FeeRest;
                        en.SaveChanges();

                        var payloan = new Mov_CxC_Employees()
                        {
                            Id_employee      = mov_CxC.Id_employee,
                            Amount_charged   = mov_CxC.Amount_charged,
                            Transaction_date = mov_CxC.Transaction_date,
                            Transaction_type = mov_CxC.Transaction_type,
                            Loan_Amount      = 0,
                            Fee_Amount       = 0,
                            Fee         = 0,
                            FeeRest     = 0,
                            Amount_rest = 0
                        };
                        en.Mov_CxC_Employees.Add(payloan);
                        en.SaveChanges();


                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        MessageBoxRM.Show(ex.Message);
                        transaction.Rollback();
                    }
                }
            }
        }
示例#6
0
        // GET: Paysheets/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Paysheet paysheet = db.Paysheets.Find(id);

            if (paysheet == null)
            {
                return(HttpNotFound());
            }
            ViewBag.CustomerID    = new SelectList(db.Customers, "Id", "FirstName", paysheet.CustomerID);
            ViewBag.DestinationID = new SelectList(db.Destinations, "Id", "Name", paysheet.DestinationID);
            ViewBag.DriversID     = new SelectList(db.Drivers, "Id", "FirstName", paysheet.DriversID);
            ViewBag.RateID        = new SelectList(db.Rates, "Id", "Name", paysheet.RateID);
            return(View(paysheet));
        }
示例#7
0
        private void btnPaidPaysheet_Click(object sender, RoutedEventArgs e)
        {
            var employee = new Employees();
            var loan     = new Mov_CxC_Employees();
            int index    = cboEmployee.SelectedIndex;

            employee = (Employees)cboEmployee.Items[index];
            int desc = Convert.ToInt32(txtDesc.Text);

            loan = PaysheetBL.GetInstance().GetMov(employee.Id);
            string nota;

            if (string.IsNullOrEmpty(txtNota.Text))
            {
                nota = "-";
            }
            else
            {
                nota = txtNota.Text;
            }
            if (desc > 0)
            {
                var newPayment = new Paysheet()
                {
                    Amount       = Convert.ToInt32(txtSueldo.Text),
                    Payment_date = DateTime.Now,
                    Id_employee  = employee.Id,
                    Note         = nota
                };

                var updateLoan = new Mov_CxC_Employees()
                {
                    Id_employee      = employee.Id,
                    Amount_charged   = desc,
                    Amount_rest      = loan.Amount_rest - desc,
                    FeeRest          = loan.FeeRest - 1,
                    Transaction_date = DateTime.Now,
                    Transaction_type = 3
                };

                PaysheetBL.GetInstance().PayrollWithLoan(newPayment, updateLoan);
                MessageBoxRM.Show($"Pago nomina a {employee.Name} {employee.Last_name} aplicado.", "Pago nomina y cobro cuota de prestamo", MessageBoxButtonRM.OK, MessageBoxIconRM.Information);
                txtSueldo.Clear();
                txtDesc.Clear();
                txtMontoP.Clear();
                txtNota.Clear();
                cboEmployee.SelectedIndex = -1;
            }
            else
            {
                var newPayment = new Paysheet()
                {
                    Amount       = Convert.ToInt32(txtSueldo.Text),
                    Payment_date = DateTime.Now,
                    Id_employee  = employee.Id,
                    Note         = nota
                };
                PaysheetBL.GetInstance().PaymentPayroll(newPayment);
                MessageBoxRM.Show($"Pago nomina a {employee.Name} {employee.Last_name} aplicado.", "Pago nomina", MessageBoxButtonRM.OK, MessageBoxIconRM.Information);
                txtSueldo.Clear();
                txtDesc.Clear();
                txtMontoP.Clear();
                txtNota.Clear();
                cboEmployee.SelectedIndex = -1;
            }
        }