public async Task <IHttpActionResult> Update([FromBody] UsuarioViewModel usuario)
{
using (var context = new RedContext())
{
var ExistUsuario = await context.Usuarios.FirstOrDefaultAsync(b => b.Id == usuario.Id);
if (ExistUsuario == null)
{
return(NotFound());
}
ExistUsuario.Address = usuario.Address;
ExistUsuario.CityId = usuario.CityId;
ExistUsuario.DepartmentId = usuario.DepartmentId;
ExistUsuario.CountryId = usuario.CountryId;
ExistUsuario.FirstName = usuario.FirstName;
ExistUsuario.Genero = usuario.Genero;
ExistUsuario.LastName = usuario.LastName;
ExistUsuario.Phone = usuario.Phone;
ExistUsuario.Photo = usuario.Photo;
ExistUsuario.UserName = usuario.UserName;
ExistUsuario.Password = usuario.Password;
await context.SaveChangesAsync();
return(Ok(new UsuarioViewModel(ExistUsuario)));
}
}
private void InitGrid(RedComboBox[] comboboxes, RedContext context)
{
foreach (RedComboBox cb in comboboxes)
{
var row = new DataGridViewRow();
var c1 = new DataGridViewTextBoxCell();
c1.Value = cb.Name;
DataGridViewCell c2;
if (cb.query.ToLowerInvariant() == "textedit")
{
c2 = new DataGridViewTextBoxCell();
c2.Value = "";
}
else
{
c2 = new DataGridViewComboBoxCell();
var t = cb.GetValues(context);
foreach (DataRow r in t.Rows)
{
(c2 as DataGridViewComboBoxCell).Items.Add(r[0].ToString());
}
(c2 as DataGridViewComboBoxCell).Value = (c2 as DataGridViewComboBoxCell).Items[0];
}
c2.ReadOnly = false;
row.Cells.Add(c1);
row.Cells.Add(c2);
dataGridView1.Rows.Add(row);
}
}
public Form1(DBConfig config)
{
log4net.Config.XmlConfigurator.Configure();
log.Debug("Application started...");
this.config = config;
InitializeComponent();
context = new RedContext()
{
Provider = new RedDBProvider(config.ConnectionString)
};
LoginForm lf = new LoginForm(context);
while (lf.CurrentUser == null)
{
lf.ShowDialog();
}
currentUser = lf.CurrentUser;
log.DebugFormat("User {0} loged in.", currentUser.Login);
InitForm();
dataGridView1.AutoGenerateColumns = false;
}
public ViewForm(RedComboBox[] comboboxes, RedContext context)
{
InitializeComponent();
dataGridView1.AutoGenerateColumns = false;
parametrs = new List <string>();
InitGrid(comboboxes, context);
}
public async Task <IHttpActionResult> Get()
{
using (var context = new RedContext())
{
return(Ok(await context.VotingPlaces.ToListAsync()));
}
}
public async Task <IHttpActionResult> Get(int id)
{
using (var context = new RedContext())
{
return(Ok(await context.VotingPlaces.Where(v => v.CityId == id).ToListAsync()));
}
}
public async Task <IHttpActionResult> Get(int id)
{
using (var context = new RedContext())
{
return(Ok(await context.Departments.FirstOrDefaultAsync(b => b.Id == id)));
}
}
private void відкритиПоточнийСтанToolStripMenuItem_Click(object sender, EventArgs e)
{
context = new RedContext()
{
Provider = new RedDBProvider(config.ConnectionString)
};
InitForm();
MessageBox.Show("Поточний стан бази завантажено.");
}
public StudentCompetitionReportGeneration(RedContext context)
{
InitializeComponent();
this.context = context;
var students = context.Provider.ExecuteSelectCommand(studQuery);
comboBox1.ValueMember = "Id";
comboBox1.DisplayMember = "Name";
comboBox1.DataSource = students;
}
public async Task <IHttpActionResult> Save([FromBody] DepartmentViewModel department)
{
using (var context = new RedContext())
{
var newDepartment = context.Departments.Add(new Department
{
CountryId = department.CountryId,
Name = department.DepartmentName
});
await context.SaveChangesAsync();
return(Ok(new DepartmentViewModel(newDepartment)));
}
}
public async Task <IHttpActionResult> Save([FromBody] CountryViewModel country)
{
using (var context = new RedContext())
{
var newCountry = context.Countries.Add(new Country
{
Id = country.CountryId,
Name = country.CountryName
});
await context.SaveChangesAsync();
return(Ok(new CountryViewModel(newCountry)));
}
}
public ChartForm(RedContext context)
{
InitializeComponent();
this.context = context;
var sectTable = context.Provider.ExecuteSelectCommand(sectionsQuery);
comboBox1.DisplayMember = sectTable.Columns[0].ColumnName;
comboBox1.DataSource = sectTable;
minYear = DateTime.Parse(context.Provider.ExecuteSelectCommand(minYearQuery).Rows[0][0].ToString()).Year;
maxYear = DateTime.Parse(context.Provider.ExecuteSelectCommand(maxYearQuery).Rows[0][0].ToString()).Year;
zedGraphControl1.GraphPane.XAxis.Type = AxisType.Text;
zedGraphControl1.GraphPane.Title.Text = graphLable;
zedGraphControl1.GraphPane.XAxis.Title.Text = "Навчальні роки";
zedGraphControl1.GraphPane.YAxis.Title.Text = "Кількість студентів";
zedGraphControl1.Refresh();
}
public async Task <IHttpActionResult> Delete(int id)
{
using (var context = new RedContext())
{
var votingplace = await context.VotingPlaces.FirstOrDefaultAsync(r => r.Id == id);
if (votingplace == null)
{
return(NotFound());
}
context.VotingPlaces.Remove(votingplace);
await context.SaveChangesAsync();
}
return(Ok());
}
public async Task <IHttpActionResult> Delete(int id)
{
using (var context = new RedContext())
{
var department = await context.Departments.FirstOrDefaultAsync(r => r.Id == id);
if (department == null)
{
return(NotFound());
}
context.Departments.Remove(department);
await context.SaveChangesAsync();
}
return(Ok());
}
public async Task <IHttpActionResult> Save([FromBody] CityViewModel city)
{
using (var context = new RedContext())
{
var newCity = context.Cities.Add(new City
{
CountryId = city.CountryId,
DepartmentId = city.DepartmentId,
Name = city.CityName
});
await context.SaveChangesAsync();
return(Ok(new CityViewModel(newCity)));
}
}
public async Task <IHttpActionResult> Save([FromBody] CommuneViewModel commune)
{
using (var context = new RedContext())
{
var newCommune = context.Communes.Add(new Commune
{
CommuneId = commune.CommuneId,
Name = commune.Name,
CountryId = commune.CountryId,
DepartmentId = commune.DepartmentId,
CityId = commune.CityId
});
await context.SaveChangesAsync();
return(Ok(new CommuneViewModel(newCommune)));
}
}
private void відкритиАрхівToolStripMenuItem_Click(object sender, EventArgs e)
{
var oad = new OpenArchive();
oad.ShowDialog();
if (!string.IsNullOrEmpty(oad.SelectedFile))
{
var dbname = Path.GetFileNameWithoutExtension(oad.SelectedFile);
context = new RedContext()
{
Provider =
new RedDBProvider(string.Format(config.ArchiveConnectionStringPattern, dbname))
};
log.DebugFormat("User {0} opened archive database {1}", currentUser.Login, "");
InitForm();
MessageBox.Show("Архів бази завантажено.");
}
}
public async Task <IHttpActionResult> Update([FromBody] CountryViewModel country)
{
using (var context = new RedContext())
{
var Existcountry = await context.Countries.FirstOrDefaultAsync(b => b.Id == country.CountryId);
if (Existcountry == null)
{
return(NotFound());
}
Existcountry.Name = country.CountryName;
await context.SaveChangesAsync();
return(Ok(new CountryViewModel(Existcountry)));
}
}
public async Task <IHttpActionResult> Save([FromBody] VotingPlaceViewModel votingplace)
{
using (var context = new RedContext())
{
var newVotingPlace = context.VotingPlaces.Add(new VotingPlace
{
Id = votingplace.VotingPlaceId,
Name = votingplace.Name,
CountryId = votingplace.CountryId,
DepartmentId = votingplace.DepartmentId,
CityId = votingplace.CityId,
Code = votingplace.Code
});
await context.SaveChangesAsync();
return(Ok(new VotingPlaceViewModel(newVotingPlace)));
}
}
public async Task <IHttpActionResult> Update([FromBody] DepartmentViewModel department)
{
using (var context = new RedContext())
{
var ExistDepartment = await context.Departments.FirstOrDefaultAsync(b => b.Id == department.DepartmentId);
if (ExistDepartment == null)
{
return(NotFound());
}
ExistDepartment.CountryId = department.CountryId;
ExistDepartment.Name = department.DepartmentName;
await context.SaveChangesAsync();
return(Ok(new DepartmentViewModel(ExistDepartment)));
}
}
public async Task <IHttpActionResult> Update([FromBody] CommuneViewModel commune)
{
using (var context = new RedContext())
{
var ExistCommune = await context.Communes.FirstOrDefaultAsync(b => b.CommuneId == commune.CommuneId);
if (ExistCommune == null)
{
return(NotFound());
}
ExistCommune.Name = commune.Name;
ExistCommune.CountryId = commune.CountryId;
ExistCommune.DepartmentId = commune.DepartmentId;
ExistCommune.CityId = commune.CityId;
await context.SaveChangesAsync();
return(Ok(new CommuneViewModel(ExistCommune)));
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RegisterGlobalFilters(GlobalFilters.Filters);
RegisterRoutes(RouteTable.Routes);
XmlSerializer serializer = new XmlSerializer(typeof(DBConfig));
var conf = new DBConfig();
using (var stream = File.OpenRead(@"d:\TK\Lesia\LabaBoiko\FizDb\ProjectsManager\FizDb.WebClient\bin\DBConfig.xml"))
{
conf = (DBConfig)serializer.Deserialize(stream);
}
var context = new RedContext()
{
Provider = new RedDBProvider(conf.ConnectionString)
};
Container.Context = context;
Container.Dataset = GetDataSet(conf, context);
}
public async Task <IHttpActionResult> Update([FromBody] VotingPlaceViewModel votingplace)
{
using (var context = new RedContext())
{
var ExistVotingPlace = await context.VotingPlaces.FirstOrDefaultAsync(b => b.Id == votingplace.VotingPlaceId);
if (ExistVotingPlace == null)
{
return(NotFound());
}
ExistVotingPlace.Name = votingplace.Name;
ExistVotingPlace.CountryId = votingplace.CountryId;
ExistVotingPlace.DepartmentId = votingplace.DepartmentId;
ExistVotingPlace.CityId = votingplace.CityId;
ExistVotingPlace.Code = votingplace.Code;
await context.SaveChangesAsync();
return(Ok(new VotingPlaceViewModel(ExistVotingPlace)));
}
}
public async Task <IHttpActionResult> Save([FromBody] UsuarioViewModel usuario)
{
using (var context = new RedContext())
{
var newUsuario = context.Usuarios.Add(new User
{
Id = usuario.Id,
Address = usuario.Address,
CityId = usuario.CityId,
DepartmentId = usuario.DepartmentId,
CountryId = usuario.CountryId,
FirstName = usuario.FirstName,
Genero = usuario.Genero,
LastName = usuario.LastName,
Phone = usuario.Phone,
Photo = usuario.Photo,
UserName = usuario.UserName,
Password = usuario.Password
});
var role = context.Roles.First(c => c.Name == "User").Id;
var User = context.Users.Add(new IdentityUser("usuario")
{
Email = newUsuario.UserName, EmailConfirmed = true
});
User.Roles.Add(new IdentityUserRole {
RoleId = role
});
await context.SaveChangesAsync();
var store = new RedUserStore();
await store.SetPasswordHashAsync(User, new RedUserManager().PasswordHasher.HashPassword(usuario.Password));
return(Ok(new UsuarioViewModel(newUsuario)));
}
}
private Red.RedDataSet GetDataSet(DBConfig config, RedContext context)
{
var dataSet = new RedDataSet();
foreach (var t in config.Tables)
{
dataSet.AddTable(t.query, t.name, t.SearchQuery == null? null: t.SearchQuery.Query, context);
if (t.Comboboxes != null)
{
foreach (var c in t.Comboboxes)
{
dataSet.tables[t.name].AddComboBox(c.name, new RedComboBox(c.query, c.name));
}
}
if (t.Columns != null)
{
foreach (var c in t.Columns)
{
dataSet.tables[t.name].AddColumnAliasHere(c.Name, c.Alias);
}
}
}
foreach (var r in config.Requests)
{
dataSet.AddView(r.query, r.name, r.desc, context);
if (r.Comboboxes != null)
{
foreach (var c in r.Comboboxes)
{
dataSet.views[r.name].AddComboBox(c.name, new RedComboBox(c.query, c.name));
}
}
}
return(dataSet);
}
public LoginForm(RedContext context)
{
InitializeComponent();
this.context = context;
}
