public async Task <bool> Create(RentReturn entity) { if (entity == null) { return(false); } entity.Active = true; entity.CreationDate = DateTime.Now; entity.UpdateDate = DateTime.Now; try { await _rentCarDbContext.RentReturns.AddAsync(entity); var result = await _rentCarDbContext.SaveChangesAsync(); if (result > 0) { var carRent = await _carRentInformationService.ChangeState(entity.CarRentInformationId, RentStateEnum.Delivered); return(carRent); } return(false); } catch (Exception e) { return(false); } }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } RentReturn rentReturn = db.RentReturn.Find(id); if (rentReturn == null) { return(HttpNotFound()); } return(View(rentReturn)); }
private void button1_Click(object sender, EventArgs e) { try { ComboBoxItem item; item = (ComboBoxItem)cbxEmpleados.SelectedItem; int empleado = item.Value; item = (ComboBoxItem)cbxEquipo.SelectedItem; int equipo = item.Value; item = (ComboBoxItem)cbxUsuario.SelectedItem; int usuario = item.Value; string noPay = txtNoPrestamo.Text; DateTime fechaprestamo = Convert.ToDateTime(dtFechaPrestamo.Text); DateTime fechadevolucion = Convert.ToDateTime(dtFechaDevolucion.Text); string comentario = txtComentario.Text; Model.Equiment f = (from x in audiovisualEntities.Equiments where x.Id == equipo select x).First(); f.StateId = 3; audiovisualEntities.SaveChanges(); data = new RentReturn(); data.NoPay = noPay; data.EmployeeId = empleado; data.EquimentId = equipo; data.UserId = usuario; data.LoanDate = fechaprestamo; data.ReturnDate = fechadevolucion; data.Comentary = comentario; audiovisualEntities.RentReturns.Add(data); audiovisualEntities.SaveChanges(); Common.Util.Message("Datos fueron insertados correctamente"); this.Close(); } catch (Exception ex) { Common.Util.MessageError(ex.Message); } }
public ActionResult DeleteConfirmed(int id) { RentReturn rentReturn = db.RentReturn.Find(id); if (db.RentStats.Any(x => x.RentId == rentReturn.RentId && DateTime.Now <= x.EndDate)) { using (SqlConnection con = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand("UpdateOnReturn", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@RentID", SqlDbType.Int).Value = rentReturn.RentId; cmd.Parameters.Add("@EndDate", SqlDbType.Date).Value = DateTime.Now.Date.AddDays(-1); cmd.Parameters.Add("@EndTime", SqlDbType.DateTime).Value = DateTime.Now; con.Open(); cmd.ExecuteNonQuery(); } } } db.RentReturn.Remove(rentReturn); db.SaveChanges(); return(RedirectToAction("Index")); }
private void returnBookbtn_Click(object sender, EventArgs e) { var rntForm = new RentReturn(); Nav(rntForm, contentPanel); }
public Task <bool> Update(RentReturn entity) { throw new System.NotImplementedException(); }