public ActionResult Create([Bind(Include = "Id,Name,Processor,Motherboard,Ram,Hard_drive,Delivery,Order,image")] Komputers komputers, HttpPostedFileBase upload) { if (ModelState.IsValid) { if (upload != null && upload.ContentLength > 0) { using (var reader = new System.IO.BinaryReader(upload.InputStream)) { komputers.image = reader.ReadBytes(upload.ContentLength); } } db.Komputers.Add(komputers); db.SaveChanges(); return(RedirectToAction("admin_index")); } ViewBag.Delivery = new SelectList(db.Deliveries, "id", "date", komputers.Delivery); ViewBag.Hard_drive = new SelectList(db.Hard_disks, "Id", "Name", komputers.Hard_drive); ViewBag.Motherboard = new SelectList(db.Motherboards, "Id", "Name", komputers.Motherboard); ViewBag.Order = new SelectList(db.Orders, "id", "date", komputers.Order); ViewBag.Processor = new SelectList(db.Processors, "Id", "Name", komputers.Processor); ViewBag.Ram = new SelectList(db.Rams, "Id", "Name", komputers.Ram); return(View(komputers)); }
public ActionResult Create(Cources cource) { if (ModelState.IsValid) { _db.Cources.Add(cource); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cource)); }
public ActionResult Create([Bind(Include = "Id,yardName")] yard yard) { if (ModelState.IsValid) { db.yards.Add(yard); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(yard)); }
public ActionResult Create([Bind(Include = "Id,location_name,longitude,latitude")] Place place) { if (ModelState.IsValid) { db.Places.Add(place); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(place)); }
public ActionResult Create([Bind(Include = "Id,Login,Password")] Admin admin) { if (ModelState.IsValid) { db.Admin.Add(admin); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(admin)); }
public ActionResult Create([Bind(Include = "Id,ConName")] container container) { if (ModelState.IsValid) { db.containers.Add(container); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(container)); }
public ActionResult Create([Bind(Include = "Id,Date,Num_Delivery")] Deliveries deliveries) { if (ModelState.IsValid) { db.Deliveries.Add(deliveries); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(deliveries)); }
public ActionResult Create([Bind(Include = "Id,DescricaoTipo,DataCadastro")] TipoDocumento tipoDocumento) { if (ModelState.IsValid) { db.TipoDocumentoes.Add(tipoDocumento); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tipoDocumento)); }
public ActionResult Create([Bind(Include = "Id,time,date,depart,arrive")] schedule schedule) { if (ModelState.IsValid) { db.schedules.Add(schedule); db.SaveChanges(); return RedirectToAction("Index"); } return View(schedule); }
public ActionResult Create([Bind(Include = "Id,Date,Num_Order")] Orders orders) { if (ModelState.IsValid) { db.Orders.Add(orders); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(orders)); }
public ActionResult Create([Bind(Include = "Id,Name")] Makers makers) { if (ModelState.IsValid) { db.Makers.Add(makers); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(makers)); }
public ActionResult Create([Bind(Include = "Id,Name,Price,Delivery,Order,Maker")] Motherboards motherboards) { if (ModelState.IsValid) { db.Motherboards.Add(motherboards); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Delivery = new SelectList(db.Deliveries, "Id", "date", motherboards.Delivery); ViewBag.Maker = new SelectList(db.Makers, "Id", "Name", motherboards.Maker); ViewBag.Order = new SelectList(db.Orders, "Id", "date", motherboards.Order); return(View(motherboards)); }
private void button2_Click(object sender, EventArgs e) { if (dataGridView2.Rows.Count <= 0) { MessageBox.Show("Belum ada barang yang di retur", "Warning!", MessageBoxButtons.OK); } else { db_Retur_Penjualan frpen = new db_Retur_Penjualan() { No_Retur_Penjualan = labelID.Text, No_Form_Penjualan_Grosir = comboBoxPenjGrosir.SelectedItem.ToString(), Tanggal = dateTimePicker1.Text, }; db.AddTodb_Retur_Penjualan(frpen); db.SaveChanges(); for (int i = 0; i < dataGridView2.RowCount; i++) { string ih = ""; string ah = ""; int h = 0; string eh = ""; try { ih = dataGridView2.Rows[i].Cells[0].Value.ToString(); ah = dataGridView2.Rows[i].Cells[1].Value.ToString(); h = int.Parse(dataGridView2.Rows[i].Cells[2].Value.ToString()); eh = dataGridView2.Rows[i].Cells[3].Value.ToString(); } catch (Exception) { } db_Detail_Retur_Penjualan dt = new db_Detail_Retur_Penjualan() { No_Retur_Penjualan = labelID.Text, ID_Barang = ih, Jumlah = h, Deskripsi = eh, Nama_Barang = ah, }; db.AddTodb_Detail_Retur_Penjualan(dt); db.SaveChanges(); } MessageBox.Show("Add Retur berhasil", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); button2.Enabled = false; button3.Enabled = false; button4.Enabled = false; } }
public ActionResult Upload(ClassArquivoUploadForm arq) { string[] allowedFiletypes = { ".doc", ".docx", ".pdf", ".xls", ".xlsx", ".xlsm", ".ppt", ".pptx" }; string ext = Path.GetExtension(arq.Arquivo.FileName); if (arq.Arquivo.ContentLength > 0 && allowedFiletypes.Contains(ext)) { byte[] arquivoBytes = new byte[arq.Arquivo.ContentLength]; using (BinaryReader binReader = new BinaryReader(arq.Arquivo.InputStream)) { arquivoBytes = binReader.ReadBytes(arq.Arquivo.ContentLength); } arquivos clsArq = new arquivos() { NomeArquivo = arq.Arquivo.FileName, ContentType = arq.Arquivo.ContentType, Visualizado = 0, IdDepartamento = arq.IdDepartamento, IdTipoDoc = arq.IdTipoDoc, IdUsuarioRemetente = arq.IdUsuarioRemetente, IdUsuarioDestinatario = arq.IdUsuarioDestinatario, Descricao = arq.Descricao, DataUpload = DateTime.Now, ContDownloads = 0, arquivo = arquivoBytes }; try { ctx.arquivos.Add(clsArq); if (ctx.SaveChanges() != 0) { //Envio de email } ModelState.Clear(); TempData["Message"] = "Arquivo enviado com sucesso!"; return(RedirectToAction("EnviarArquivo", "Arquivo")); } catch { ModelState.Clear(); return(Content("<script type='text/javascript'>alert('Ocorreu um erro inesperado no banco de dados.'); window.location = '/Arquivo/EnviarArquivo'</script>")); } } else { ModelState.Clear(); return(Content("<script type='text/javascript'>alert('Por favor, selecione um tipo de arquivo válido.'); window.location = '/Arquivo/EnviarArquivo';</script>")); } }
private void DeleteKaryawan(string id) { if (id == "") { MessageBox.Show("Pilih data yang ingin dihapus!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (MessageBox.Show(this, "Are you sure want to delete Karyawan " + textBox1.Text + " ?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { var t = (from a in db.db_Karyawan.ToList() where a.ID_Karyawan == id select a).First(); db.DeleteObject(t); db.SaveChanges(); } }
private void button5_Click(object sender, EventArgs e) { if (dataGridView1.Rows.Count <= 0) { MessageBox.Show("Tidak ada data untuk di simpan", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { db_Faktur_Pemesanan df = new db_Faktur_Pemesanan() { No_Faktur_Pemesanan = textBox1.Text, ID_Karyawan = textBox9.Text, ID_Supplier = textBox7.Text, Tanggal = dateTimePicker1.Text }; db.AddTodb_Faktur_Pemesanan(df); db.SaveChanges(); for (int i = 0; i < dataGridView1.RowCount; i++) { string ih = ""; string ah = ""; int h = 0; int hh = 0; try { ih = dataGridView1.Rows[i].Cells[1].Value.ToString(); ah = dataGridView1.Rows[i].Cells[3].Value.ToString(); hh = int.Parse(dataGridView1.Rows[i].Cells[5].Value.ToString()); h = int.Parse(dataGridView1.Rows[i].Cells[6].Value.ToString()); } catch (Exception) { } db_Detail_Faktur_Pemesanan dbf = new db_Detail_Faktur_Pemesanan() { No_Faktur_Pemesanan = textBox1.Text, ID_Barang = ih, Nama_Barang = ah, Harga = hh, Jumlah = h }; db.AddTodb_Detail_Faktur_Pemesanan(dbf); db.SaveChanges(); } MessageBox.Show("Transaksi berhasil", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); button2.Enabled = false; button5.Enabled = false; button3.Enabled = false; } }
public HttpResponseMessage Delete(int id) { try { using (databaseEntities dbEntities = new databaseEntities()) { var entity = dbEntities.Lends.FirstOrDefault(loanId => loanId.Id == id); if (entity != null) { //remove from database dbEntities.Lends.Remove(entity); dbEntities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There is no loan associated with the requested id: " + id.ToString())); } } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
public Transaction CreateNewTransaction(int userId, List <int> productIds, List <int> productAmounts) { using (var context = new databaseEntities()) { var u = (from x in context.Users where x.Id == userId select x).First(); var purchases = new List <Purchase>(); for (int i = 0; i < productIds.Count; i++) { var currentId = productIds[i]; var currentAmount = productAmounts[i]; purchases.Add(new Purchase(currentId, currentAmount, context.Products.Where(x => x.Id == currentId).First().Price)); } var totalPrice = purchases.Sum(x => x.TotalPrice); var stocks = (from x in context.Stocks from y in productIds where x.ProductId == y select x); if (!(u.Funds >= totalPrice)) { return(null); } for (int i = 0; i < productIds.Count; i++) { var currentId = productIds[i]; var currentAmount = productAmounts[i]; var stock = stocks.Single(x => x.Id == currentId); if (stock.Amount < currentAmount) { return(null); } } var t = new Transaction { UserId = userId }; context.Transactions.Add(t); u.Funds -= totalPrice; for (int i = 0; i < productIds.Count; i++) { var currentId = productIds[i]; var currentAmount = productAmounts[i]; var currentPrice = (from x in context.Products where x.Id == currentId select x).First().Price; (from y in stocks where y.ProductId == currentId select y).First().Amount -= currentAmount; context.TransactionRows.Add(new TransactionRow { ProductId = currentId, Amount = currentAmount, TransactionId = t.Id, Price = currentPrice }); } context.SaveChanges(); return(t); } }
public ActionResult Delete(int id) { //db.sp_delete_branch(id); //return RedirectToAction("Index"); var res = db.Branches.Where(x => x.BranchId == id).First(); db.Branches.Remove(res); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Cadastro(ClassUsuario user) { if (user.Senha == user.ConfirmarSenha) { try { var consultaUsuario = ctx.usuarios.Where(u => u.NomeUsuario == user.NomeUsuario || u.Email == user.Email).FirstOrDefault(); if (consultaUsuario == null) { int tipoUsu; if (user.TipoUsuario == "cliente") { tipoUsu = 1; } else { tipoUsu = 2; } var passwordBytes = Encoding.UTF8.GetBytes(user.Senha); var usu = new usuarios() { NomeUsuario = user.NomeUsuario, Email = user.Email, Senha = Convert.ToBase64String(passwordBytes), IdTipoUsu = tipoUsu, }; ctx.usuarios.Add(usu); ctx.SaveChanges(); ModelState.Clear(); ViewBag.Message = "Cadastro efetuado com sucesso!!"; return(View("~/Views/Workflow/PaginaCadastro.cshtml")); } else { ModelState.Clear(); return(Content("<script type='text/javascript'>alert('Este usuário/E-mail já está cadastrado no sistema. Por favor,tente novamente.'); window.location = '/Workflow/PaginaCadastro';</script>")); } } catch { ViewBag.Message = "Ocorreu um erro inesperado no cadastro. Tente novamente mais tarde."; ModelState.Clear(); return(View("~/Views/Workflow/PaginaCadastro.cshtml")); } } else { ModelState.Clear(); return(Content("<script type='text/javascript'>alert('senha e confirmar senha não são idênticos. Por favor,tente novamente.'); window.location = '/Workflow/PaginaCadastro';</script>")); } }
public User CreateNewUser(string username) { using (var context = new databaseEntities()) { var u = new User { Username = username, Password = new string(username.ToCharArray().Reverse().ToArray()), Funds = 100 }; context.Users.Add(u); context.SaveChanges(); return(u); } }
//[Route("post")] public HttpResponseMessage Post(Lend loan) { try { using (databaseEntities dbEntities = new databaseEntities()) { //add to database dbEntities.Lends.Add(loan); dbEntities.SaveChanges(); //get the response code of 201 for successful post and return the newly added loan var message = Request.CreateResponse(HttpStatusCode.Created, loan); message.Headers.Location = new Uri(Request.RequestUri + loan.Id.ToString()); return(message); } } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } }
public ActionResult RegisterConfirmed([Bind(Include = "Id,Login,Password")] Admin adm) { try { if (ModelState.IsValid) { //Хранимая процедура "NewAdmin" для регистрации нового администратора var regInfo = db.NewAdmin(adm.Login, adm.Password).ToList(); if (regInfo != null && Convert.ToInt32(regInfo[0]) != -1) { db.SaveChanges(); return(RedirectToAction("Auth")); } else { ModelState.AddModelError("Email", "ПОЛЬЗОВАТЕЛЬ С ТАКИМ ИМЕНЕМ (E-MAIL) УЖЕ СУЩЕСТВУЕТ."); } } } catch (Exception ex) { } return(View()); }
private void button2_Click(object sender, EventArgs e) { if (dataGridViewDetail.Rows.Count <= 0) { MessageBox.Show("Belum ada barang yang di retur", "Warning!", MessageBoxButtons.OK); } else { string tampID = ""; if (status == "FRJ") { try { tampID = listBoxID.Text; db_Retur_Pembelian frpem = new db_Retur_Pembelian() { No_Retur_Pembelian = labelID.Text, No_Retur_Penjualan = tampID, No_Faktur_Pemesanan = "", Tanggal = dateTimePicker3.Text, }; db.AddTodb_Retur_Pembelian(frpem); db.SaveChanges(); for (int i = 0; i < dataGridViewDetail.RowCount; i++) { string ih = ""; string ah = ""; int h = 0; string eh = ""; try { ih = dataGridViewDetail.Rows[i].Cells[0].Value.ToString(); ah = dataGridViewDetail.Rows[i].Cells[1].Value.ToString(); h = int.Parse(dataGridViewDetail.Rows[i].Cells[2].Value.ToString()); eh = dataGridViewDetail.Rows[i].Cells[3].Value.ToString(); } catch (Exception) { } db_Detail_Retur_Pembelian dd = new db_Detail_Retur_Pembelian() { No_Retur_Pembelian = labelID.Text, ID_Barang = ih, Jumlah = h, Deskripsi = eh, Nama_Barang = ah, }; db.AddTodb_Detail_Retur_Pembelian(dd); db.SaveChanges(); //var t = (from a in db.db_Detail_Retur_Penjualan where a.No_Retur_Penjualan == tampID && a.ID_Barang ==ih select a).First(); //t.Jumlah = t.Jumlah - h; //db.SaveChanges(); } } catch (Exception) { } } else if (status == "FPE") { try { tampID = listBoxID.Text; db_Retur_Pembelian frpem = new db_Retur_Pembelian() { No_Retur_Pembelian = labelID.Text, No_Retur_Penjualan = "", No_Faktur_Pemesanan = tampID, Tanggal = dateTimePicker3.Text, }; db.AddTodb_Retur_Pembelian(frpem); db.SaveChanges(); for (int i = 0; i < dataGridViewDetail.RowCount; i++) { string ih = ""; string ah = ""; int h = 0; string eh = ""; try { ih = dataGridViewDetail.Rows[i].Cells[0].Value.ToString(); ah = dataGridViewDetail.Rows[i].Cells[1].Value.ToString(); h = int.Parse(dataGridViewDetail.Rows[i].Cells[2].Value.ToString()); eh = dataGridViewDetail.Rows[i].Cells[3].Value.ToString(); } catch (Exception) { } db_Detail_Retur_Pembelian dt = new db_Detail_Retur_Pembelian() { No_Retur_Pembelian = labelID.Text, ID_Barang = ih, Jumlah = h, Deskripsi = eh, Nama_Barang = ah, }; db.AddTodb_Detail_Retur_Pembelian(dt); db.SaveChanges(); //try //{ // var t = (from a in db.db_Detail_Faktur_Pemesanan where a.No_Faktur_Pemesanan == tampID && a.ID_Barang == ih select a).First(); // t.Jumlah = t.Jumlah - h; //} //catch (Exception) { } } }catch (Exception) { } } MessageBox.Show("Add Retur berhasil", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); button2.Enabled = false; button1.Enabled = false; button4.Enabled = false; } }
private void button5_Click(object sender, EventArgs e) { if (dataGridView1.Rows.Count <= 0) { MessageBox.Show("Tidak ada data untuk di simpan", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { db_Form_Penjualan_Eceran fe = new db_Form_Penjualan_Eceran() { No_Form_Penjualan_Eceran = textBox6.Text, ID_Karyawan = textBox1.Text, Tanggal = dateTimePicker1.Text }; db.AddTodb_Form_Penjualan_Eceran(fe); db.SaveChanges(); for (int i = 0; i < dataGridView1.RowCount; i++) { string ih = ""; string ah = ""; int h = 0, l = 0; try { ih = dataGridView1.Rows[i].Cells[1].Value.ToString(); h = int.Parse(dataGridView1.Rows[i].Cells[3].Value.ToString()); l = int.Parse(dataGridView1.Rows[i].Cells[4].Value.ToString()); ah = dataGridView1.Rows[i].Cells[2].Value.ToString(); } catch (Exception) { } db_Detail_Form_Penjualan_Eceran dfe = new db_Detail_Form_Penjualan_Eceran() { No_Form_Penjualan_Eceran = textBox6.Text, ID_Barang = ih, Harga = h, Jumlah = l, Nama_Barang = ah }; db.AddTodb_Detail_Form_Penjualan_Eceran(dfe); db.SaveChanges(); try { var up = (from a in db.db_Barang where a.ID_Barang == ih select a).FirstOrDefault(); if (up.Stock != null) { up.Stock = up.Stock - l; db.SaveChanges(); if (up.Stock <= 500) { MessageBox.Show("Stock " + dataGridView1.Rows[i].Cells[2].Value.ToString() + " mulai menipis, harap segera buat Faktur Pemesanan! ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception) { } } MessageBox.Show("Transaksi berhasil", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); button4.Enabled = false; button5.Enabled = false; button6.Enabled = false; id = textBox6.Text; } }