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 { }));
}
