public CrudOperations Update(int idToSearch, CrudOperations entity) { CrudOperations found = null; found = context.Find <CrudOperations>(idToSearch); if (entity.Age != 0) { found.Age = entity.Age; } if (!string.IsNullOrEmpty(entity.Name)) { found.Name = entity.Name; } if (!string.IsNullOrEmpty(entity.FatherName)) { found.FatherName = entity.FatherName; } if (!string.IsNullOrEmpty(entity.Location)) { found.Location = entity.Location; } if (!string.IsNullOrEmpty(entity.CNIC)) { found.CNIC = entity.CNIC; } context.SaveChanges(); return(entity); }
public void delete() { CrudOperations crud = new CrudOperations(); crud.deleteSchedule("scheduleDataBase", "nhiremat", Name.text); Destroy(gameObject); }
static void Main(string[] args) { int i = 0; SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-PFA0L7A\SQLEXPRESS;Initial Catalog=bookYourShowDB;Integrated Security=True"); //con.Open(); for (i = 0; i < 7; i++) { CrudOperations objCrud = new CrudOperations(); objCrud.Test(); SqlCommand cmdGetMovies = new SqlCommand("INSERT INTO MovieTheatreMapping VALUES (1,3,@date,(SELECT seatMatrix FROM TheatreScreenMapping WHERE TheatreScreenMappingID = 3))", con); cmdGetMovies.Parameters.AddWithValue("@date", 13 + i + "-2-2017:M"); cmdGetMovies.ExecuteNonQuery(); SqlCommand cmdGetMovies1 = new SqlCommand("INSERT INTO MovieTheatreMapping VALUES (1,3,@date,(SELECT seatMatrix FROM TheatreScreenMapping WHERE TheatreScreenMappingID = 3))", con); cmdGetMovies1.Parameters.AddWithValue("@date", 13 + i + "-2-2017:A"); cmdGetMovies1.ExecuteNonQuery(); SqlCommand cmdGetMovies2 = new SqlCommand("INSERT INTO MovieTheatreMapping VALUES (1,3,@date,(SELECT seatMatrix FROM TheatreScreenMapping WHERE TheatreScreenMappingID = 3))", con); cmdGetMovies2.Parameters.AddWithValue("@date", 13 + i + "-2-2017:N"); cmdGetMovies2.ExecuteNonQuery(); } con.Close(); }
public void GetItemsFromDatabase() { UnitOfWork unitOfWork = new UnitOfWork(new Entities()); CrudOperations <Births> .AddRange(_sicksObservableCollection, unitOfWork.Sicks.GetSicksByFemale(Female.code)); SicksListView.ItemsSource = _sicksObservableCollection; }
public void GetItemsFromDatabase() { var unitOfWork = new UnitOfWork(new Entities()); CrudOperations <DatabaseFirst.Sales> .AddRange(_salesObservableCollection, unitOfWork.Sales.GetAll()); SalesListView.ItemsSource = _salesObservableCollection; }
private void GetBirthsFromDatabase() { UnitOfWork unitOfWork = new UnitOfWork(new Entities()); CrudOperations <Births> .AddRange(_birthsObservableList, unitOfWork.Births.GetBirthsByFemale(Female.code).ToList()); BirthsListView.ItemsSource = _birthsObservableList; }
private void GetInseminationsFromDatabase() { UnitOfWork unitOfWork = new UnitOfWork(new Entities()); CrudOperations <Inseminations> .AddRange(_inseminationsObservableList, unitOfWork.Inseminations.GetInseminationsByFemale(Female.code)); InseminationsListView.ItemsSource = _inseminationsObservableList; }
//Contractor that loads initialies all the private fileds above public CasesController(ApplicationDbContext _context) { context = _context; caseOps = new CaseOps(context); offender = new OffenderOps(context); offence = new CrudOperations <Offence>(context); officer = new OfficerOps(context); caseof = new CaseOffenderOps(context); }
public CrudOperations Delete(int idToSearch) { CrudOperations found = null; found = context.Find <CrudOperations>(idToSearch); context.Remove(found); context.SaveChanges(); return(found); }
private static IEnumerable <T> GetCrudItems <T>(IEnumerable <T> items, CrudOperations type) where T : SObject { // TODO: Need to find a better way to have the operationtype // available during xml serialization of the objects, this is not the best return(items.Select(x => { x.OperationType = type; return x; }).ToArray()); }
public FinePaymentController(ApplicationDbContext _context, IAmortizationCalculate _amortizationCalculate) { context = _context; fineOps = new FineOps(context); caseOps = new CaseOps(context); amortizationCalculate = _amortizationCalculate; amortization = new CrudOperations <Amortization>(context); finepay = new CrudOperations <FinePayment>(context); offenderOps = new OffenderOps(context); offence = new CrudOperations <Offence>(context); }
public void delete() { Singleton singleton = Singleton.Instance(); String user = singleton.getUserName(); CrudOperations crud = new CrudOperations(); crud.deleteSchedule("scheduleDataBase", user, Name.text); Destroy(gameObject); }
public ModelCrudOperations MapToModelCrudOperations(CrudOperations crudOperations) { switch (crudOperations) { case CrudOperations.Delete: return(ModelCrudOperations.Delete); case CrudOperations.Update: return(ModelCrudOperations.Update); default: return(ModelCrudOperations.Create); } }
void Start() { locationsData = new Dictionary <string, string>(); sharedLocationsData = new Dictionary <string, JObject>(); dbDetails = new DB_Details(); crud = new CrudOperations(); // Set up the Editor before calling into the realtime database. FirebaseApp.DefaultInstance.SetEditorDatabaseUrl(dbDetails.getDBUrl()); // Get the root reference location of the database. reference = FirebaseDatabase.DefaultInstance.RootReference; singleton = Singleton.Instance(); ScheduleName = singleton.getScheduleName(); UserName = singleton.getUserName(); ScheduleNameText.text = ScheduleName; getScheduleData(); locationsDisplayed = false; }
public PayOnLineLogic() { PaymentBoxesManage = new CrudOperations <CAJAS_Pago>(); }
public PayOnLineLogic(BDCatastroTulancingoEntities context) { PaymentBoxesManage = new CrudOperations <CAJAS_Pago>(context); }
public static CrudViewModel ToModel(this CrudOperations entity) { return(new CrudViewModel { Id = entity.Id, Name = entity.Name, FatherName = entity.FatherName, CNIC = entity.CNIC, Age = entity.Age, Location = entity.Location }); }
public CrudOperations Add(CrudOperations entity) { context.Add(entity); context.SaveChanges(); return(entity); }
public OffendersController(ApplicationDbContext _context) { context = _context; offenderOps = new OffenderOps(context); status = new CrudOperations <OffenderStatus>(context); }