public async Task <ActionResult <Anketa> > PostAnketa(Anketa anketa)
{
if (anketa.Odgovori != null)
{
foreach (var odgovor in anketa.Odgovori)
{
odgovor.Anketa = anketa;
_context.AnketaOdgovor.Add(odgovor);
}
}
var dtn = DateTime.Now;
var ankete = await _context.Anketa.Where(x => x.ZakljucenoDatum == null).ToListAsync();
foreach (var item in ankete)
{
item.ZakljucenoDatum = dtn;
}
_context.Anketa.Add(anketa);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetAnketa", new { id = anketa.Id }, anketa));
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (dataGridViewAnk.SelectedRows.Count == 0)
{
MessageBox.Show("Пожалуйста, выберите строку!");
return;
}
int rowIndex = dataGridViewAnk.SelectedRows[0].Index;
using (LoveDataContext db = new LoveDataContext())
{
Anketa anketa = db.Anketa.Find(Convert.ToInt32(dataGridViewAnk[0, rowIndex].Value));
DialogResult dialogResult = MessageBox.Show($"Вы увены, что хотите удалить анкету {anketa.FIO}?", "", MessageBoxButtons.OKCancel);
if (dialogResult != DialogResult.OK)
{
return;
}
db.Anketa.Remove(anketa);
db.SaveChanges();
}
FillTable();
ShowAll();
}
public async Task <IActionResult> Edit(int id, [Bind("ID,konacnaOcjena")] Anketa anketa)
{
if (id != anketa.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(anketa);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnketaExists(anketa.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(anketa));
}
public void Export(Questionnaire questionnaire, Anketa anketa)
{
using (var conn = new OleDbConnection(ConnectionString))
{
//формируем список колонок
var columnsList = string.Join(", ", questionnaire.Select(q => q.Id));
//формируем список параметров
var paramsList = string.Join(", ", questionnaire.Select(q => "@" + q.Id));
var sql = string.Format("INSERT INTO [{2}]({0}) VALUES({1});", columnsList, paramsList, TableName);
//создаем команду
using (var command = new OleDbCommand(sql, conn))
{
//инициализируем параметры значениями
foreach (var q in questionnaire)
{
var answer = anketa.FirstOrDefault(a => a.QuestId == q.Id);
var val = GetExportedAlternativeValue(q, answer);
command.Parameters.AddWithValue("@" + q.Id, val);
}
//исполняем SQL запрос
conn.Open();
command.ExecuteNonQuery();
}
conn.Close();
}
}
public async Task <Anketa> Zavrsi(bool vis)
{
Anketa pitanje = new Anketa
{
IdZbor = App.Zbor.Id,
VisestrukiOdgovor = vis,
DatumKraja = Datum,
Pitanje = Pitanje
};
int i = 0;
foreach (var odgovor in Odgovori)
{
if (odgovor.Value.Trim() == "")
{
throw new ArgumentException();
}
pitanje.OdgovorAnkete.Add(new OdgovorAnkete
{
Odgovor = odgovor.Value,
Redoslijed = i
});
i++;
}
var novo = await _apiServices.NovoPitanjeAsync(App.Zbor.Id, pitanje);
return(novo);
}
public bool Calculate(Anketa anketa, Condition condition)
{
if (condition == null || string.IsNullOrEmpty(condition.Expression))
{
return(true);
}
//заменяем имена вопросов на значения
var expression = Regex.Replace(condition.Expression, QuestNamePattern,
(m) =>
{
var questId = m.Value;
//ищем ответ
var answer = anketa.FirstOrDefault(a => a.QuestId == questId);
if (answer != null)
{
//заменяем имя вопроса на ответ
if (string.IsNullOrEmpty(answer.Text))
{
return(answer.AlternativeCode.ToString());
}
return("'" + answer.Text + "'");
}
return("0"); //код отсутствия ответа
});
//вычислем выражение
return((bool)new DataTable().Compute(expression, null));
}
public async Task <IActionResult> Edit(int id, [Bind("AnketaId,Surname,Name,Middlename,SurnameR,NameR,MiddlenameR,Birthday,Sex,IdentityNumber,PassportSeries,PassportNumber,DateOfIssue,DateOfValidity,IssuedBy,PlaceOfBirth,Postcode,Region,TypeOfSettlement,NameOfSettlement,StreetType,StreetName,HouseNumber,HullNumber,ApartmentNumber,HomePhone,SocialBehavior,KinshipTypeFather,SurnameFather,NameFather,MiddlenameFather,AddressFather,KinshipTypeMother,SurnameMother,NameMother,MiddlenameMother,AddressMother,EducationLevel,Institution,YearOfEnding,PlaceOfWorkAndPosition,SeniorityGeneral,SeniorityProfileSpecialty,SpecialtyId,DocumentTypeId")] Anketa anketa)
{
if (id != anketa.AnketaId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(anketa);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AnketaExists(anketa.AnketaId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["DocumentTypeId"] = new SelectList(_context.DocumentTypes, "DocumentTypeId", "Name", anketa.DocumentTypeId);
ViewData["SpecialtyId"] = new SelectList(_context.Specialties, "SpecialtyId", "GetSpecialtyNameBranch", anketa.SpecialtyId);
return(View(anketa));
}
public async Task <IActionResult> Create([Bind("AnketaId,Surname,Name,Middlename,SurnameR,NameR,MiddlenameR,Birthday,Sex,IdentityNumber,PassportSeries,PassportNumber,DateOfIssue,DateOfValidity,IssuedBy,PlaceOfBirth,Postcode,Region,TypeOfSettlement,NameOfSettlement,StreetType,StreetName,HouseNumber,HullNumber,ApartmentNumber,HomePhone,SocialBehavior,KinshipTypeFather,SurnameFather,NameFather,MiddlenameFather,AddressFather,KinshipTypeMother,SurnameMother,NameMother,MiddlenameMother,AddressMother,EducationLevel,Institution,YearOfEnding,PlaceOfWorkAndPosition,SeniorityGeneral,SeniorityProfileSpecialty,SpecialtyId,DocumentTypeId")] Anketa anketa)
{
if (ModelState.IsValid)
{
var user = await _userManager.FindByNameAsync(User.Identity.Name);
if (user == null)
{
return(NotFound("Пользователь не найден"));
}
await _context.AddAsync(anketa);
await _context.SaveChangesAsync();
user.AnketaId = anketa.AnketaId;
_context.Users.Update(user);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["DocumentTypeId"] = new SelectList(_context.DocumentTypes, "DocumentTypeId", "Name", anketa.DocumentTypeId);
ViewData["SpecialtyId"] = new SelectList(_context.Specialties, "SpecialtyId", "GetSpecialtyNameBranch", anketa.SpecialtyId);
return(View(anketa));
}
public ActionResult ZapisiGlas(Anketa anketa)
{
if (Session["id_lice"] != null)
{
using (var db = new AnketiEntities5())
{
foreach (int i in anketa.GlasoviId)
{
DateTime date = DateTime.Now;
string datum = date.ToString("yyyy-MM-dd HH:mm:ss");
var novGlas = db.Glasas.Create();
novGlas.id_anketa = anketa.id_anketa;
novGlas.id_lice = (int)Session["id_lice"];
novGlas.id_odg = i;
novGlas.datum_glasanje = Convert.ToDateTime(datum);
db.Glasas.Add(novGlas);
}
db.SaveChanges();
}
return(RedirectToAction("Details", "Anketa", new { id = anketa.id_anketa }));
}
//ViewBag.id_lice = new SelectList(db.Lice, "id_lice", "ime", anketa.id_lice);
return(View(anketa));
}
public ActionResult dodajPitanje([Bind(Include = "pit_brj,pit_sadrz,pit_anktbrj,pit_datumpost,odg1,odg2,odg3,odg4")] Pitanje pitanje)
{
TempData["Sifra"] = null;
pitanje.odg1_glas = 0;
pitanje.odg2_glas = 0;
pitanje.odg3_glas = 0;
pitanje.odg4_glas = 0;
pitanje.brojotvaranja = 0;
pitanje.pit_anktbrj = db.Anketas.First().ankt_brj;
Sifra sif = TempData["sifra"] as Sifra;
// if (db.Anketas.First().ankt_brj != null)
// pitanje.pit_anktbrj = db.Anketas.First().ankt_brj;
// else
pitanje.pit_datumpost = DateTime.Now;
if (ModelState.IsValid)
{
db.Pitanjes.Add(pitanje);
db.SaveChanges();
Anketa anketa = db.Anketas.First();
anketa.ankt_brjpit++;
db.Entry(anketa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("dodajPitanje"));
}
return(View(pitanje));
}
private void dataGridPitanja_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
Anketa anketaIzmenaPitanja = null;
foreach (Anketa anketa in ListePodataka.ListaAnketa)
{
if (idAnkete > 0 && anketa.AnketaID == idAnkete)
{
anketaIzmenaPitanja = anketa;
}
}
if (anketaIzmenaPitanja != null) //ako je pronadjena anketa na osnovu id, razlikuje se od null
{
if (anketaIzmenaPitanja.ListaPitanja.Count > 0 && dataGridPitanja.SelectedIndex != -1)
{
Pitanje pitanje = (Pitanje)dataGridPitanja.SelectedItem;
dataGridOdgovor.ItemsSource = pitanje.ListaOdgovora; //setuje items source 2. data grida, zato sto sadrzi odgovore za to pitanje
tbIzmenaTekstaPitanja.Text = pitanje.TekstPitanja;
idPitanjaIzmenaBrisanje = pitanje.PitanjeID; //setovana globalna promenljiva kojoj ce se pristupiti prilikom izmene
}
}
}
public ActionResult DeleteConfirmed(int id)
{
Anketa anketa = db.Anketas.Find(id);
db.Anketas.Remove(anketa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Update(Anketa _anketa)
{
using (var context = _Setting.GetNewContext())
{
context.Entry(_anketa).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Add(Anketa _anketa)
{
using (var context = _Setting.GetNewContext())
{
context.Entry(_anketa).State = EntityState.Added;
context.Anketa.Add(_anketa);
context.SaveChanges();
}
}
public void Remove(Anketa _anketa)
{
using (var context = _Setting.GetNewContext())
{
context.Entry(_anketa).State = EntityState.Deleted;
//context.Anketa.Remove(_anketa);
context.SaveChanges();
}
}
public void Fio_1()
{
string fio = "Кузнецова Дарья";
string expected = "1";
Anketa a = new Anketa();
string actual = a.FIO(fio);
Assert.AreEqual(expected, actual);
}
public void Tel_4()
{
string tel = "+789969584432";
string expected = "0";
Anketa a = new Anketa();
string actual = a.Tel(tel);
Assert.AreEqual(expected, actual);
}
public void Data_3()
{
string data = "288.11.2000";
string expected = "0";
Anketa a = new Anketa();
string actual = a.Data(data);
Assert.AreEqual(expected, actual);
}
public ActionResult Edit([Bind(Include = "ankt_brj,ankt_naslov,ankt_brjpit,ankt_brjotvaranja,ankt_datumotv,ankt_datposljotv")] Anketa anketa)
{
if (ModelState.IsValid)
{
db.Entry(anketa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(anketa));
}
public void Data_4()
{
string data = "dd.cc.gggg";
string expected = "0";
Anketa a = new Anketa();
string actual = a.Data(data);
Assert.AreEqual(expected, actual);
}
public void Tel_5()
{
string tel = "qwertyuiopa";
string expected = "0";
Anketa a = new Anketa();
string actual = a.Tel(tel);
Assert.AreEqual(expected, actual);
}
public void Mail_5()
{
string mail = "da@[email protected]";
string expected = "0";
Anketa a = new Anketa();
string actual = a.Mail(mail);
Assert.AreEqual(expected, actual);
}
public void Export(Questionnaire questionnaire, Anketa anketa, List <Tuple <string, object> > additionalParameters = null)
{
using (var conn = new OleDbConnection(ConnectionString))
{
//формируем список колонок
var columnsList = string.Join(", ", questionnaire.Select(q => q.Id));
//имена колонок для дополнительных параметров
if (additionalParameters != null)
{
columnsList += ", " + string.Join(", ", additionalParameters.Select(p => p.Item1));
columnsList = columnsList.Trim(' ', ',');
}
//формируем список параметров
var paramsList = string.Join(", ", questionnaire.Select(q => "@" + q.Id));
//список доп параметров
if (additionalParameters != null)
{
paramsList += ", " + string.Join(", ", Enumerable.Range(0, additionalParameters.Count).Select(p => ADD_PARAM_PREFIX + p));
paramsList = paramsList.Trim(' ', ',');
}
//формируем SQL запрос
var sql = string.Format("INSERT INTO [{2}]({0}) VALUES({1});", columnsList, paramsList, TableName);
//создаем команду
using (var command = new OleDbCommand(sql, conn))
{
//инициализируем параметры значениями
foreach (var q in questionnaire)
{
var answer = anketa.FirstOrDefault(a => a.QuestId == q.Id);
var val = GetExportedAlternativeValue(q, answer);
command.Parameters.AddWithValue("@" + q.Id, val);
}
//инициализируем доп параметры значениями
if (additionalParameters != null)
{
for (int i = 0; i < additionalParameters.Count; i++)
{
command.Parameters.AddWithValue(ADD_PARAM_PREFIX + i, additionalParameters[i].Item2);
}
}
//исполняем SQL запрос
conn.Open();
command.ExecuteNonQuery();
}
conn.Close();
}
}
public AnketaExtension(Anketa anketa)
{
Id = anketa.Id;
KorisnikId = anketa.KorisnikId;
Naslov = anketa.Naslov;
Datum = anketa.Datum;
ZakljucenoDatum = anketa.ZakljucenoDatum;
Korisnik = anketa.Korisnik;
Odgovori = anketa.Odgovori;
}
public ActionResult Edit([Bind(Include = "id_anketa,prasanje,opis_a,kraen_datum,id_lice,datum_kreiranje,multi_choice")] Anketa anketa)
{
if (ModelState.IsValid)
{
db.Entry(anketa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_lice = new SelectList(db.Lice, "id_lice", "ime", anketa.id_lice);
return(View(anketa));
}
public async Task <IActionResult> Create([Bind("ID,Text,mackeKojeSuUcestvovale")] Anketa anketa)
{
if (ModelState.IsValid)
{
_context.Add(anketa);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(anketa));
}
public ActionResult SaveAnketa(Anketa ank)
{
if (ank.ID != 0)
{
_Facade.Keeper.Update(ank);
}
else
{
_Facade.Keeper.Add(ank);
}
return(new EmptyResult());
}
public ActionResult obrisipitanja()
{
ApplicationDbContext con = new ApplicationDbContext();
con.Database.ExecuteSqlCommand("TRUNCATE TABLE [Pitanje]");
Anketa anketa = db.Anketas.First();
anketa.ankt_brjpit = 0;
db.Entry(anketa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
public async Task <IActionResult> Create([Bind("ID,ocjena1,ocjena2,ocjena3,ocjena4,ocjena5,doktorID")] Anketa anketa)
{
if (ModelState.IsValid)
{
var konacna = (anketa.ocjena1 + anketa.ocjena2 + anketa.ocjena3 + anketa.ocjena4 + anketa.ocjena5) / 5;
anketa.konacnaOcjena = konacna;
_context.Add(anketa);
await _context.SaveChangesAsync();
return(Redirect("~/IzborniMeni"));
}
return(View(anketa));
}
// GET: /Anketa/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Anketa anketa = db.Anketas.Find(id);
if (anketa == null)
{
return(HttpNotFound());
}
return(View(anketa));
}
