private void btnDeleteRow_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult delConf = MessageBox.Show("Are you sure delete this data?", "Delete data", MessageBoxButton.YesNo);
switch (delConf)
{
case MessageBoxResult.Yes:
var data = tblSupplier.SelectedItem;
emptyFields();
int id = Convert.ToInt32((tblSupplier.SelectedCells[0].Column.GetCellContent(data) as TextBlock).Text);
var rowSupplier = con.Suppliers.Where(s => s.Id == id).FirstOrDefault();
var rowRole = con.Roles.Where(s => s.Supplier.Id == rowSupplier.Id).FirstOrDefault();
con.Roles.Remove(rowRole);
con.Suppliers.Remove(rowSupplier);
var update = con.SaveChanges();
MessageBox.Show(update + " Data has been deleted");
emptyFields();
tblSupplier.ItemsSource = con.Suppliers.ToList();
break;
case MessageBoxResult.No:
break;
}
}
public void guardarClientes(List <Cliente> listaClientesCargados)
{
foreach (Cliente cliente in listaClientesCargados)
{
ctx.Cliente.Add(cliente);
ctx.SaveChanges();
}
}
public int Delete(int id)
{
var getByid = context.Departments.Find(id);
context.Departments.Remove(getByid);
var delete = context.SaveChanges();
return(delete);
}
//DELETE
public int Delete(int id)
{
// dapetin id nya
var getByid = context.Divisions.Find(id);
// execute delete
context.Divisions.Remove(getByid);
var delete = context.SaveChanges();
return(delete);
}
public ActionResult Create([Bind(Include = "Name, Price, Stock, Supplierid")] Item item)
{
if (ModelState.IsValid)
{
// TODO: Add insert logic here
connection.Items.Add(item);
connection.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(connection.Suppliers, "Id", "Name", item.Supplier);
return(View(item));
}
public ActionResult Create(Department department)
{
try
{
myConn.Departments.Add(department);
myConn.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void Btn_Insert_Click(object sender, RoutedEventArgs e)
{
try
{
if (TextBox_Name.Text == "" || TextBox_Address.Text == "" || TextBox_Email.Text == "")
{
if (TextBox_Name.Text == "")
{
MessageBox.Show("Name is required", "Warning", MessageBoxButton.OK);
TextBox_Name.Focus();
}
else if (TextBox_Address.Text == "")
{
MessageBox.Show("Address is required", "Warning", MessageBoxButton.OK);
TextBox_Address.Focus();
}
else if (TextBox_Email.Text == "")
{
MessageBox.Show("Email is required", "Warning", MessageBoxButton.OK);
TextBox_Email.Focus();
}
}
else
{
var check_email = connection.Suppliers.FirstOrDefault(S => S.Email == TextBox_Email.Text);
if (check_email == null)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Are You Sure?", "Insert Confirmation", System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
var input_supplier = new Supplier(TextBox_Name.Text, TextBox_Address.Text, TextBox_Email.Text);
connection.Suppliers.Add(input_supplier);
var insert = connection.SaveChanges();
if (insert >= 1)
{
MessageBox.Show(insert + " Supplier has been inserted");
}
TB_M_Supplier.ItemsSource = connection.Suppliers.ToList();
}
}
else
{
MessageBox.Show("Email has been used");
}
}
}
catch (Exception)
{
}
reset_supplier();
Combo_Supplier.ItemsSource = connection.Suppliers.ToList();
}
public ActionResult Create(Division division)
{
try
{
myConn.Divisions.Add(division);
myConn.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewBag.id_department = new SelectList(myConn.Departments, "Id", "Name", division.Name);
return(View());
}
}
private void btnDeleteRow_Click(object sender, RoutedEventArgs e)
{
var data = tblItem.SelectedItem;
emptyFields();
int id = Convert.ToInt32((tblItem.SelectedCells[0].Column.GetCellContent(data) as TextBlock).Text);
var rowItems = con.Items.Where(s => s.Id == id).FirstOrDefault();
con.Items.Remove(rowItems);
var update = con.SaveChanges();
MessageBox.Show(update + " Data has been deleted");
tblItem.ItemsSource = con.Items.ToList();
}
public ActionResult Create(Supplier supplier)
{
try
{
// TODO: Add insert logic here
conn.Suppliers.Add(supplier);
conn.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Add(Supplier supplier)
{
connection.Suppliers.Add(supplier);
connection.SaveChanges();
return(RedirectToAction("Index"));
//return Json(new { success = true, message = "Add Success" }, JsonRequestBehavior.AllowGet);
}
private void forgotpass_btn_Click(object sender, RoutedEventArgs e)
{
if (txb_email.Text == "")
{
MessageBox.Show("Please fill Email");
txb_email.Focus();
}
else
{
try
{
string password = System.Guid.NewGuid().ToString();
var row = con.Suppliers.Where(r => r.Email == txb_email.Text).FirstOrDefault();
var myid = con.Suppliers.Where(s => s.Id == row.Id).FirstOrDefault();
Sendmail(txb_email.Text, row.Name, password);
myid.Password = password;
con.SaveChanges();
MessageBox.Show("Success Reset Password \nPlease Check Your Email");
login.Show();
this.Close();
}
catch (Exception)
{
MessageBox.Show("Email not Registered");
txb_email.Text = "";
txb_email.Focus();
}
}
}
private void EFbuttonAdd_Click(object sender, EventArgs e)
{
// Add new Blog entry to Blogs table
try
{
using var dbContext = new myContext();
var newBlog = new Blog()
{
Title = "from EF",
CreatedAt = DateTime.Now,
Subtitle = "SubFromEF"
// Note : There is an issue with EF with this subtitle field
// Although this field IS marked as 'allow nulls' in the sql server, the EF doesn't work if it is null
// It is NOT a profiler issue, it is some issue with the EF core
// See: https://stackoverflow.com/a/55889874/5737562
};
dbContext.Blogs.Add(newBlog);
dbContext.SaveChanges();
var lastBlogId = newBlog.Id;
Console.WriteLine($"Added Blog: Blog with id {lastBlogId} was added");
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public ActionResult ConfirmarReserva(CarteleraReserva cr)
{
myContext ctx = new myContext();
if (ModelState.IsValid)
{
Reservas reserva = new Reservas();
string HoraInicio = cr.Horario.ToString();
int sitioDeCorte = 2;
string parte1 = HoraInicio.Substring(0, sitioDeCorte);
string parte2 = HoraInicio.Substring(3, sitioDeCorte);
int HoraInicioParte1, HoraInicioParte2;
Int32.TryParse(parte1, out HoraInicioParte1);
Int32.TryParse(parte2, out HoraInicioParte2);
DateTime Hora = DateTime.Today;
Hora = Hora.AddHours(HoraInicioParte1);
Hora = Hora.AddMinutes(HoraInicioParte2);
reserva.IdPelicula = cr.IdPelicula;
reserva.IdVersion = cr.IdVersion;
reserva.IdSede = cr.IdSede;
reserva.FechaHoraInicio = Hora;
reserva.FechaCarga = DateTime.Now;
reserva.Email = cr.Email;
reserva.IdTipoDocumento = cr.IdTipoDocumento;
reserva.NumeroDocumento = cr.NumeroDocumento;
reserva.CantidadEntradas = cr.CantidadEntradas;
ctx.Reservas.Add(reserva);
ctx.SaveChanges();
cr.IdReserva = reserva.IdReserva;
var sede = ctx.Sedes.Where(x => x.IdSede == cr.IdSede).FirstOrDefault();
ViewBag.PrecioTotal = cr.CantidadEntradas * sede.PrecioGeneral;
return(View(cr));
}
var a = ctx.Carteleras.Where(x => x.IdPelicula == cr.IdPelicula && x.IdSede == cr.IdSede && x.IdVersion == cr.IdVersion).First();
ViewBag.ImagenPelicula = ctx.Peliculas.Where(x => x.IdPelicula == cr.IdPelicula).FirstOrDefault().Imagen;
ViewBag.TiposDocumentos = PeliculaServicio.TraeTiposDeDocumentos();
cr.IdPelicula = a.IdPelicula;
cr.IdSede = a.IdSede;
cr.NumeroSala = a.NumeroSala;
cr.IdVersion = a.IdVersion;
cr.Peliculas = a.Peliculas;
cr.Sedes = a.Sedes;
cr.Versiones = a.Versiones;
cr.Horario = cr.Horario;
cr.Dia = cr.Dia;
return(View("FinalizarReserva", cr));
}
public static CookingInstruction AddCookInstr(CookingInstruction instr)
{
using (myContext db1 = new myContext())
{
var newItem = db1.CookingInstructions.Add(instr);
db1.SaveChanges();
return(newItem);
}
}
public static void RemoveCollectionOrder(int Id)
{
using (myContext db1 = new myContext())
{
var order = db1.AwaitOrders.First(m => m.Id == Id);
//db1.AwaitOrders.Remove(order);
db1.Entry(order).State = EntityState.Deleted;
db1.SaveChanges();
}
}
// Insert Supplier
private void Btn_Insert_Click(object sender, RoutedEventArgs e)
{
string password = System.Guid.NewGuid().ToString();
var iRole = conn.Roles.Where(S => S.Id == cb_role).FirstOrDefault();
var input = new Supplier(txtb_name.Text, txtb_address.Text, txtb_email.Text, password, iRole);
// pattern email
string pattern = @"^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9[\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$";
// validasi_supplier
if (txtb_name.Text == "")
{
MessageBox.Show("Nama tidak boleh kosong...");
txtb_name.Focus();
}
else if (txtb_address.Text == "")
{
MessageBox.Show("Address tidak boleh kosong...");
txtb_address.Focus();
}
else if (txtb_email.Text == "")
{
MessageBox.Show("Email tidak boleh kosong...");
txtb_email.Focus();
}
else if (!Regex.Match(txtb_email.Text, pattern).Success)
{
MessageBox.Show("Format email salah...");
txtb_email.Focus();
}
else
{
//push ke database
conn.Suppliers.Add(input);
conn.SaveChanges();
sendPassToEmail(txtb_email.Text, password, txtb_name.Text); // method send password to email
txtb_name.Text = string.Empty;
txtb_address.Text = string.Empty;
txtb_email.Text = string.Empty;
MessageBox.Show("Data Berhasil ditambahkan");
}
tbl_supplier.ItemsSource = conn.Suppliers.ToList(); // refresh table
}
public ActionResult Create([Bind(Include = "Name, Price, Stock, SupplierID")] Item item)
{
try
{
if (ModelState.IsValid)
{
conn.Items.Add(item);
conn.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (DataException /* dex */)
{
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
PopulateSuppliersDropDownList(item.SupplierID);
return(View(item));
}
public static void AddCollectionOrder(int orderId)
{
using (myContext db1 = new myContext())
{
var awaitOrder = new AwaitOrder()
{
OrderId = orderId
};
var result = db1.AwaitOrders.Add(awaitOrder);
db1.SaveChanges();
}
}
public IActionResult CreateUser(RegisUser user)
{
if (ModelState.IsValid)
{
PasswordHasher <RegisUser> Hasher = new PasswordHasher <RegisUser>();
user.Password = Hasher.HashPassword(user, user.Password);
User NewUser = new User
{
Firstname = user.Firstname,
Lastname = user.Lastname,
Email = user.Email,
Password = user.Password,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
_context.Add(NewUser);
_context.SaveChanges();
User justCreated = _context.Users.FirstOrDefault(User => user.Email == user.Email);
HttpContext.Session.SetInt32("UserId", justCreated.UserId);
HttpContext.Session.SetString("Firstname", justCreated.Firstname);
return(RedirectToAction("ActivityList"));
}
return(View("Index"));
}
public static void AddDeliverytoDespatch(int orderId)
{
using (myContext db1 = new myContext())
{
var deliveryOrder = new DeliverytoDespatch()
{
OrderId = orderId,
AssignedDriverId = 0
};
var result = db1.DeliveriestoDespatch.Add(deliveryOrder);
db1.SaveChanges();
}
}
public ActionResult AltaSede(Sedes sede)
{
if (ModelState.IsValid)
{
myContext ctx = new myContext();
sede.PrecioGeneral = Decimal.Parse(Request.Form["precioGeneral"]);
ctx.Sedes.Add(sede);
ctx.SaveChanges();
var a = (ctx.Sedes).ToList();
return(View("Sedes", a));
}
return(View());
}
public ActionResult AltaCartelera(Carteleras cartelera)
{
myContext ctx = new myContext();
if (ModelState.IsValid)
{
ViewBag.Mensaje = "";
cartelera.FechaCarga = DateTime.Now;
var sede = (ctx.Sedes).ToList();
var peli = (ctx.Peliculas).ToList();
var version = (ctx.Versiones).ToList();
ViewBag.Sedes = sede;
ViewBag.Peli = peli;
ViewBag.Version = version;
if (cartelera.IdSede == 0)
{
ViewBag.Mensaje = "Debe ingresar una sede";
return(View());
}
if (cartelera.IdPelicula == 0)
{
ViewBag.Mensaje = "Debe ingresar una película";
return(View());
}
if (AdministracionServicio.ValidaCartelera(cartelera))
{
ctx.Carteleras.Add(cartelera);
ctx.SaveChanges();
var a = (ctx.Carteleras).ToList();
return(View("Carteleras", a));
}
else
{
ViewBag.Mensaje = "ATENCIÓN !!! La cartelera ingresada no se encuentra disponible en las fechas: " + cartelera.FechaInicio.ToShortDateString() + " - " + cartelera.FechaFin.ToShortDateString();
return(View());
}
}
var b = (ctx.Sedes).ToList();
var c = (ctx.Peliculas).ToList();
var d = (ctx.Versiones).ToList();
ViewBag.Sedes = b;
ViewBag.Peli = c;
ViewBag.Version = d;
return(View());
}
public ActionResult editarPelicula(Peliculas peli, HttpPostedFileBase image)
{
myContext ctx = new myContext();//Instancio el contexto
if (ModelState.IsValid)
{
var file = image;
var id = Int32.Parse(Request.Form["idPelicula"]);
Peliculas peli2 = (from pel in ctx.Peliculas where pel.IdPelicula == id select pel).FirstOrDefault();
if (file != null && file.ContentLength > 0) // Agregar IMAGEN
{
try
{
string path = Path.Combine(Server.MapPath("~/Images"),
Path.GetFileName(file.FileName));
file.SaveAs(path);
peli2.Imagen = Path.GetFileName(file.FileName);
}
catch (Exception ex)
{
ViewBag.Message = "ERROR:" + ex.Message.ToString();
}
}
else
{
if (peli2.Imagen != Request.Form["Imagen"] && Request.Form["Imagen"] != "" && Request.Form["Imagen"] != null)
{
peli2.Imagen = Request.Form["Imagen"];
}
}
peli2.Nombre = peli.Nombre;
peli2.Descripcion = peli.Descripcion;
peli2.Duracion = peli.Duracion;
peli2.FechaCarga = DateTime.Now;
peli2.IdGenero = peli.IdGenero;
peli2.IdCalificacion = peli.IdCalificacion;
ctx.SaveChanges(); //persisto los datos en la bdd
var a = (ctx.Peliculas).ToList(); //Cargo el modelo para Peliculas
return(View("Peliculas", a));
}
ViewBag.Generos = AdministracionServicio.GetGeneros();
ViewBag.Calificaciones = AdministracionServicio.GetCalificaciones();
return(View(peli));
}
private void Btn_SendEmail_Click(object sender, RoutedEventArgs e)
{
try
{
if (TBEmail_Forget.Text == "")
{
MessageBox.Show("Email is required", "Warning", MessageBoxButton.OK);
TBEmail_Forget.Focus();
}
else
{
var check_email = connection.Users.FirstOrDefault(S => S.Email == TBEmail_Forget.Text);
if (check_email != null)
{
var this_email = check_email.Email;
if (TBEmail_Forget.Text == this_email)
{
string New_Password = Guid.NewGuid().ToString();
var check_user = connection.Users.FirstOrDefault(S => S.Email == TBEmail_Forget.Text);
check_user.Password = New_Password;
var chagepassword = connection.SaveChanges();
if (chagepassword >= 1)
{
MessageBox.Show("Password has been updated");
}
Outlook._Application openapp = new Outlook.Application();
Outlook.MailItem sentmail = (Outlook.MailItem)openapp.CreateItem(Outlook.OlItemType.olMailItem);
sentmail.To = TBEmail_Forget.Text;
sentmail.Subject = "Forgot Password " + DateTime.Now.ToString("dd/MM/yyyy");
sentmail.Body = "Dear " + TBEmail_Forget.Text + "\nThis Is Your Password : "******"Check Your Email for Your New Password", "Message", MessageBoxButton.OK);
}
}
else
{
MessageBox.Show("That Email Not Registered Yet!", "Warning", MessageBoxButton.OK);
}
}
}
catch (Exception)
{
}
}
public ActionResult Edit(int id, Supplier supplier)
{
try
{
// TODO: Add update logic here
using (myContext connection = new myContext())
{
connection.Entry(supplier).State = EntityState.Modified;
connection.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void btnSendPassword_Click(object sender, RoutedEventArgs e)
{
var userData = con.Suppliers.Where(s => s.Email == txtEmail.Text).FirstOrDefault();
if (userData == null)
{
MessageBox.Show("Email tidak terdaftar");
}
else
{
string newPassword = System.Guid.NewGuid().ToString();
userData.Password = newPassword;
var update = con.SaveChanges();
sendPasswordToEmail(userData.Email, newPassword, userData.Name);
MessageBox.Show("Please check your email");
}
}
public ActionResult Create(Customer customer)
{
myContext conn = new myContext();
try
{
// TODO: Add insert logic here
conn.Customers.Add(customer);
conn.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult EditarSede(Sedes sede)
{
myContext ctx = new myContext();
if (ModelState.IsValid)
{
Sedes sedeOrig = (from se in ctx.Sedes where se.IdSede == sede.IdSede select se).FirstOrDefault();
sedeOrig.Nombre = sede.Nombre;
sedeOrig.Direccion = sede.Direccion;
sedeOrig.PrecioGeneral = sede.PrecioGeneral;
ctx.SaveChanges();
var a = (ctx.Sedes).ToList();
return(View("Sedes", a));
}
return(View());
}
public ActionResult Create(Supplier supplier)
{
try
{
using (myContext connection = new myContext())
{
connection.Suppliers.Add(supplier);
connection.SaveChanges();
}
// TODO: Add insert logic here
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}