public void deleteFirm(string metroLabel) { PrinterFirmID = Convert.ToInt32(metroLabel); using (ContextModel db = new ContextModel()) { PrinterFirm printerFirm = db.PrinterFirm .Where(p => p.PrinterFirmID == PrinterFirmID) .FirstOrDefault(); db.PrinterFirm.Remove(printerFirm); db.SaveChanges(); } }
public void deleteCatrige(string metroLabel) { CatrigeID = Convert.ToInt32(metroLabel); using (ContextModel db = new ContextModel()) { Catrige catrige = db.Catrige .Where(p => p.CatrigeID == CatrigeID) .FirstOrDefault(); db.Catrige.Remove(catrige); db.SaveChanges(); } }
public void save(Role dbitem) { if (dbitem.Id == 0) //create { context.Role.Add(dbitem); var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Role", QueryDetail = "Add " + dbitem.RoleName, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); } else //edit { context.Role.Attach(dbitem); var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Role", QueryDetail = "Edit " + dbitem.RoleName, RemoteAddress = AppHelper.GetIPAddress(), IdUser = 1 }; context.Auditrail.Add(auditrail); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public void Delete() { int LocationID = Convert.ToInt32(ID); using (ContextModel db = new ContextModel()) { LocationRoom location = db.LocationRoom .Where(p => p.LocationID == LocationID) .FirstOrDefault(); db.LocationRoom.Remove(location); db.SaveChanges(); } }
public void deleteTitul(string metroLabel) { PrinterTitulID = Convert.ToInt32(metroLabel); using (ContextModel db = new ContextModel()) { Titul titul = db.Titul .Where(p => p.TitulID == PrinterTitulID) .FirstOrDefault(); db.Titul.Remove(titul); db.SaveChanges(); } LoadTitul(); }
public void delete() { int CatrigeStatusID = Convert.ToInt32(StatusID); using (ContextModel db = new ContextModel()) { CatrigeStatus catrigeStatus = db.CatrigeStatus .Where(p => p.CatrigeStatusID == CatrigeStatusID) .FirstOrDefault(); db.CatrigeStatus.Remove(catrigeStatus); db.SaveChanges(); load(); } }
public void save(HistoryJalanTruck dbitem) { if (dbitem.Id == 0) //create { context.HistoryJalanTruck.Add(dbitem); } else //edit { context.HistoryJalanTruck.Attach(dbitem); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public void delete() { int PrinterStatusID = Convert.ToInt32(StatusID); using (ContextModel db = new ContextModel()) { PrinterStatus printerStatus = db.PrinterStatus .Where(p => p.PrinterStatusID == PrinterStatusID) .FirstOrDefault(); db.PrinterStatus.Remove(printerStatus); db.SaveChanges(); load(); } }
public void Delete() { int ID = Convert.ToInt32(PrinterModelID); using (ContextModel db = new ContextModel()) { PrinterModel printerModel = db.PrinterModel .Where(p => p.PrinterModelID == ID) .FirstOrDefault(); db.PrinterModel.Remove(printerModel); db.SaveChanges(); } Load(); }
public void deleteLocation(string metroLabel) { LocationID = Convert.ToInt32(metroLabel); using (ContextModel db = new ContextModel()) { LocationRoom location = db.LocationRoom .Where(p => p.LocationID == LocationID) .FirstOrDefault(); db.LocationRoom.Remove(location); db.SaveChanges(); } }
public void deletePrinterLocation(string metroLabel) { int ID = Convert.ToInt32(metroLabel); using (ContextModel db = new ContextModel()) { PrinterLocation printerLocation = db.PrinterLocations .Where(p => p.LocationID == ID) .FirstOrDefault(); db.PrinterLocations.Remove(printerLocation); db.SaveChanges(); load(); } }
public ActionResult Create(int FYearId, string OCode, string ODescription) { Objective objective = new Objective(); objective.ODescription = ODescription; objective.FYearId = FYearId; objective.OCode = OCode; if (FYearId > 0 && !(String.IsNullOrEmpty(OCode)) && !(String.IsNullOrEmpty(ODescription))) { db.Objectives.Add(objective); db.SaveChanges(); return(RedirectToAction("Index")); } var Fyear = db.FYears.Where(x => x.Status == "Active").FirstOrDefault(); if (Fyear != null) { ViewBag.FYearId = Fyear.FYearId; ViewBag.FYear = Fyear.Year; } return(View(objective)); }
public void save(Spk spk_dbitem, int id) { if (spk_dbitem.Id == 0) //create { context.Spk.Add(spk_dbitem); var query = "INSERT INTO dbo.\"Spk\" (\"Jenis\", \"Permintaan\", \"Keterangan\", \"Mekanik1\", \"Mekanik2\", \"Workshop_id\", \"Status\", \"ServiceIn\", \"Estimasi\", \"ServiceOut\", " + "\"RevEstimasi\", \"KeteranganSPK\") VALUES ( " + spk_dbitem.Jenis + ", " + spk_dbitem.Permintaan + ", " + spk_dbitem.Keterangan + ", " + spk_dbitem.Mekanik1 + ", " + spk_dbitem.Mekanik2 + ", " + spk_dbitem.Workshop_id + ", " + spk_dbitem.Status + ", " + spk_dbitem.ServiceIn + ", " + spk_dbitem.Estimasi + ", " + spk_dbitem.ServiceOut + ", " + spk_dbitem.RevEstimasi + ", " + spk_dbitem.KeteranganSPK + ");"; var auditrail = new Auditrail { Actionnya = "Spk", EventDate = DateTime.Now, Modulenya = "Workshop", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); } else //edit { context.Spk.Attach(spk_dbitem); var spk_history = new SpkHistory { Tanggal = DateTime.Now, Jenis = spk_dbitem.Jenis, Estimasi = spk_dbitem.Estimasi ?? DateTime.Now, Status = spk_dbitem.Status, RevEstimasi = spk_dbitem.RevEstimasi ?? 0, WorkshopId = spk_dbitem.Workshop_id }; context.SpkHistory.Add(spk_history); var query = "UPDATE dbo.\"Spk\" SET \"Jenis\" = " + spk_dbitem.Jenis + ", \"Permintaan\" = " + spk_dbitem.Permintaan + ", \"Keterangan\" = " + spk_dbitem.Keterangan + ", \"Mekanik1\" \" = " + spk_dbitem.Mekanik1 + ", \"Mekanik2\" = \" = " + spk_dbitem.Mekanik2 + ", \"Workshop_id\" = \" = " + spk_dbitem.Workshop_id + ", \"Status\" = \" = " + spk_dbitem.Status + ", \"ServiceIn\" = \" = " + spk_dbitem.ServiceIn + ", \"Estimasi\" = \" = " + spk_dbitem.Estimasi + ", \"ServiceOut\" = \" = " + spk_dbitem.ServiceOut + ", \"RevEstimasi\" = \" = " + spk_dbitem.RevEstimasi + ", \"KeteranganSPK\" = \" = " + spk_dbitem.KeteranganSPK + " WHERE \"Id\" = " + spk_dbitem.Id + ";" + "INSERT INTO dbo.\"SpkHistory\" (\"Jenis\", \"Status\", \"Estimasi\", \"Tanggal\", \"RevEstimasi\", \"WorkshopId\") VALUES (" + spk_history.Jenis + ", " + spk_history.Status + ", " + spk_history.Estimasi + ", " + spk_history.Tanggal + ", " + spk_history.RevEstimasi + ", " + spk_history.WorkshopId + ");"; var auditrail = new Auditrail { Actionnya = "Spk", EventDate = DateTime.Now, Modulenya = "Workshop", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); var entry = context.Entry(spk_dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public void save(Klaim dbitem, int id) { if (dbitem.Id == 0) //create { context.Klaim.Add(dbitem); var query = "INSERT INTO dbo.\"Klaim\" (\"NoKlaim\", \"TanggalPengajuan\", \"StatusKlaim\", \"SumberInformasiId\", \"LaporanKejadian\", \"HasilPemeriksaan\", \"Penyelesaian\", \"Kesalahan\", " + "\"KesalahanLain\", \"SalesOrderId\", \"TotalPengajuanClaim\", \"NilaiDisetujui\", \"AsuransiFlag\", \"Asuransi\", \"BebanClaim\", \"BebanClaimDriverPercentage\", \"BebanClaimDriver\", " + "\"BebanClaimKantorPercentage\", \"BebanClaimKantor\", \"Keterangan\", \"LastUpdate\", \"SalesOrderKontrakId\", \"IdBap\", \"NoBap\", \"IsClaim\", \"Code\") VALUES (" + dbitem.NoKlaim + ", " + dbitem.TanggalPengajuan + ", " + dbitem.StatusKlaim + ", " + dbitem.SumberInformasiId + ", " + dbitem.LaporanKejadian + ", " + dbitem.HasilPemeriksaan + ", " + dbitem.Penyelesaian + ", " + dbitem.Kesalahan + ", " + dbitem.KesalahanLain + ", " + dbitem.SalesOrderId + ", " + dbitem.TotalPengajuanClaim + ", " + dbitem.NilaiDisetujui + ", " + dbitem.AsuransiFlag + ", " + dbitem.Asuransi + ", " + dbitem.BebanClaim + ", " + dbitem.BebanClaimDriverPercentage + ", " + dbitem.BebanClaimDriver + ", " + dbitem.BebanClaimKantorPercentage + ", " + dbitem.BebanClaimKantor + ", " + dbitem.Keterangan + ", " + dbitem.LastUpdate + ", " + dbitem.SalesOrderKontrakId + ", " + dbitem.IdBap + ", " + dbitem.NoBap + ", " + dbitem.IsClaim + ", " + dbitem.Code + ");"; var auditrail = new Auditrail { Actionnya = "Add", EventDate = DateTime.Now, Modulenya = "Klaim", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); } else //edit { context.Klaim.Attach(dbitem); var query = "UPDATE dbo.\"Klaim\" SET \"NoKlaim\" = " + dbitem.NoKlaim + ", \"TanggalPengajuan\" = " + dbitem.TanggalPengajuan + ", \"StatusKlaim\" = " + dbitem.StatusKlaim + ", \"SumberInformasiId\" = " + dbitem.SumberInformasiId + ", \"LaporanKejadian\" = " + dbitem.LaporanKejadian + ", \"HasilPemeriksaan\" = " + dbitem.HasilPemeriksaan + ", \"Penyelesaian\" = " + dbitem.Penyelesaian + ", \"Kesalahan\" = " + dbitem.Kesalahan + ", \"KesalahanLain\" = " + dbitem.KesalahanLain + ", \"SalesOrderId\" = " + dbitem.SalesOrderId + ", \"TotalPengajuanClaim\" = " + dbitem.TotalPengajuanClaim + ", \"NilaiDisetujui\" = " + dbitem.NilaiDisetujui + ", \"AsuransiFlag\" = " + dbitem.AsuransiFlag + ", \"Asuransi\" = " + dbitem.Asuransi + ", \"BebanClaim\" = " + dbitem.BebanClaim + ", \"BebanClaimDriverPercentage\" = " + dbitem.BebanClaimDriverPercentage + ", \"BebanClaimDriver\" = " + dbitem.BebanClaimDriver + ", \"BebanClaimKantorPercentage\" = " + dbitem.BebanClaimKantorPercentage + ", \"BebanClaimKantor\" = " + dbitem.BebanClaimKantor + ", \"Keterangan\" = " + dbitem.Keterangan + ", \"LastUpdate\" = " + dbitem.LastUpdate + ", \"SalesOrderKontrakId\" = " + dbitem.SalesOrderKontrakId + ", \"IdBap\" = " + dbitem.IdBap + ", \"NoBap\" = " + dbitem.NoBap + ", \"IsClaim\" = " + dbitem.IsClaim + ", \"Code\" = " + dbitem.Code + " WHERE \"Id\" = " + dbitem.Id + ";"; var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Klaim", QueryDetail = query, RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public void Delete(MetroLabel catrigeID) { using (ContextModel db = new ContextModel()) { int ID = Convert.ToInt32(catrigeID.Text); Catrige catrige = db.Catrige .Where(p => p.CatrigeID == ID) .FirstOrDefault(); db.Catrige.Remove(catrige); db.SaveChanges(); } }
public void save(SalesOrder dbitem) { dbitem.DateStatus = DateTime.Now; var order_history = new OrderHistory(); if (dbitem.Id == 0) //create { context.SalesOrder.Add(dbitem); } else { context.SalesOrder.Attach(dbitem); if (dbitem.Status == "save") { var last_oh = context.OrderHistory.Where(d => d.SalesOrderId == dbitem.Id && d.StatusFlow == 1).FirstOrDefault(); if (last_oh == null) { order_history = new OrderHistory { SalesOrderId = dbitem.Id, StatusFlow = 1, FlowDate = DateTime.Now, SavedAt = DateTime.Now, ProcessedAt = DateTime.Now, PIC = dbitem.UpdatedBy } } ; else { order_history = new OrderHistory { SalesOrderId = dbitem.Id, StatusFlow = 1, FlowDate = DateTime.Now, SavedAt = last_oh.SavedAt, ProcessedAt = DateTime.Now, PIC = dbitem.UpdatedBy } }; } context.OrderHistory.Add(order_history); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; } dbitem.DateStatus = DateTime.Now; context.SaveChanges(); }
public ActionResult Create([Bind(Include = "Id,Price,DateOfService,ServiceTypesId")] AditionServices aditionServices, int?LivingId) { aditionServices.LivingsId = LivingId; Living living = db.Livings.Where(x => x.Id == LivingId).First(); //Проверка корректности даты оказания дополнительных услуг if (aditionServices.DateOfService < living.Settling) { ModelState.AddModelError("Number", "Дата оказания услуги не может быть меньше даты заезда"); } if (aditionServices.DateOfService > living.Eviction) { ModelState.AddModelError("Number", "Дата оказания услуги не может быть больше даты выезда"); } if (ModelState.IsValid) { db.AditionServices.Add(aditionServices); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aditionServices)); }
public void Delete() { using (ContextModel db = new ContextModel()) { int ID = Convert.ToInt32(PrinterFirmID); PrinterFirm printerFirm = db.PrinterFirm .Where(p => p.PrinterFirmID == ID) .FirstOrDefault(); db.PrinterFirm.Remove(printerFirm); db.SaveChanges(); } Load(); }
public void Delete() { int ID = Convert.ToInt32(CatrigeModelID.Text); using (ContextModel db = new ContextModel()) { CatrigeModel catrigeModel = db.CatrigeModel .Where(p => p.CatrigeModelID == ID) .FirstOrDefault(); db.CatrigeModel.Remove(catrigeModel); db.SaveChanges(); } Load(); }
public ActionResult Create(Entrada entrada, Cliente cliente, bool cadastrarCliente = false) { if (cadastrarCliente) { entrada.Cliente = cliente; } else { entrada.IdCliente = cliente.Id; } _db.Entradas.Add(entrada); _db.SaveChanges(); return(RedirectToAction("Index")); }
public void UpdateDataTrukMonitoringTrim() { ContextModel context = new ContextModel(); var dataTruck = context.DataTruck.ToList(); foreach (var item in dataTruck) { item.VehicleNo = item.VehicleNo.Trim(); context.DataTruck.Attach(item); var entry = context.Entry(item); entry.State = EntityState.Modified; context.SaveChanges(); } context.Dispose(); }
public void Delete() { using (ContextModel db = new ContextModel()) { int ID = Convert.ToInt32(PrinterID.Text); Printer printer = db.Printer .Where(p => p.PrinterID == ID) .FirstOrDefault(); db.Printer.Remove(printer); db.SaveChanges(); Load(); } }
static void DeleteOperation(string postId) { //Delete The Operation and Data refer to it ModelDB.Data.Remove(ModelDB.Data.Where(s => s.PostID == postId).First()); ModelDB.Likes.RemoveRange(ModelDB.Likes.Where(s => s.To == postId)); ModelDB.Comments.RemoveRange(ModelDB.Comments.Where(s => s.PostID == postId)); ModelDB.SaveChanges(); Console.WriteLine("Deleted Succsessfully Bay..\n"); for (int i = 5; i > 0; i--) { Thread.Sleep(250); Console.Write(" " + i); Console.Beep(); } Application.Restart(); }
public bool EditarNombre(Usuario user) { bool status = false; model.Entry(user).State = EntityState.Modified; model.SaveChanges(); status = true; return(status); }
public void save(Dokumen dbitem, int id, string strQuery = null) { if (dbitem.Id == 0) //create { context.Dokumen.Add(dbitem); } else //edit { context.Dokumen.Attach(dbitem); var entry = context.Entry(dbitem); entry.State = EntityState.Modified; var query = "UPDATE dbo.\"Dokumen\" SET \"IsComplete\" = " + dbitem.IsComplete + " \"ModifiedDate\" = " + dbitem.ModifiedDate + "\"IsReturn\" = " + dbitem.IsReturn + " WHERE \"Id\" = " + dbitem.Id + ";"; var auditrail = new Auditrail { Actionnya = "Edit", EventDate = DateTime.Now, Modulenya = "Dokumen", QueryDetail = query + (strQuery == null ? "" : strQuery), RemoteAddress = AppHelper.GetIPAddress(), IdUser = id }; context.Auditrail.Add(auditrail); } context.SaveChanges(); }
public void InsertDataTrukMonitoring() { ContextModel context = new ContextModel(); var dataMonitoring = context.MonitoringVehicle.Select(d => d.VehicleNo).ToList(); var dataTruck = context.DataTruck.ToList(); dataTruck = dataTruck.Where(d => !dataMonitoring.Contains(d.VehicleNo)).ToList(); foreach (var item in dataTruck) { context.MonitoringVehicle.Add(new MonitoringVehicle() { VehicleNo = item.VehicleNo, Type = item.JenisTrucks.StrJenisTruck, LastUpdate = DateTime.Now }); context.SaveChanges(); } context.Dispose(); }
public bool AddUser(string nombre, string email, string password) { try { ContextModel context = new ContextModel(); Usuario user = new Usuario(); user.Nombre = nombre; user.Email = email; user.Password = password; //user.TipoUsuario = usuario.TipoUsuario; //user.CuentaVerificada = usuario.CuentaVerificada; context.Usuario.Add(user); context.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public virtual int Save() { try { return(_context.SaveChanges()); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entidade do tipo \"{0}\" no estado \"{1}\" tem os seguintes erros de validação:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Erro: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }
public ActionResult Cadastrar(string tipo, string descricao, string valor, string data) { if (tipo == "entrada") { Entrada entrada = new Entrada(); entrada.Descricao = descricao; entrada.Valor = Convert.ToDecimal(valor); entrada.Data = Convert.ToDateTime(data); db.Entradas.Add(entrada); } else { Saida saida = new Saida(); saida.Descricao = descricao; saida.Valor = Convert.ToDecimal(valor); saida.Data = Convert.ToDateTime(data); db.Saidas.Add(saida); } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult FinishTheRegistration(int?ApartmentId, int?LivingId, int?ClientId, DateTime?Settling, DateTime?Eviction, int?ValueOfGuests, int?ValueOfKids) { Apartments currentApartment = db.Apartments.Include(a => a.ApartmentType).Where(x => x.Id == ApartmentId).First(); Client currentClient = db.Clients.Include(l => l.Livings).Include(l => l.Livings).Where(x => x.Id == ClientId).First(); Living currentLiving = new Living(); currentLiving.Id = (int)LivingId; currentLiving.ApartmentsId = ApartmentId; currentLiving.ClientId = ClientId; currentLiving.Settling = (DateTime)Settling; currentLiving.Eviction = (DateTime)Eviction; currentLiving.ValueOfGuests = (int)ValueOfGuests; currentLiving.ValueOfKids = (int)ValueOfKids; if ((currentClient.Bookings.Count + currentClient.Livings.Count) < 6) { db.Livings.Add(currentLiving); db.SaveChanges(); } return(RedirectToAction("Index", "Livings", new { })); }