public Nalozi RegisterNewRekreativac(RegisterViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Nalozi nalog = new Nalozi();
nalog.Email = model.Email;
nalog.Ime = model.Firstname;
nalog.Prezime = model.Lastname;
nalog.Lozinka = model.Password;
nalog.IsRekreativac = true;
nalog.IsAdministrator = false;
nalog.IsPlivac = false;
nalog.IsTrener = false;
nalog.Aktivan = true;
connection.Nalozi.Add(nalog);
connection.SaveChanges();
Rekreativci rekreativac = new Rekreativci();
rekreativac.Email = model.Email;
rekreativac.Ime = model.Firstname;
rekreativac.Prezime = model.Lastname;
rekreativac.NalogId = nalog.Id;
connection.Rekreativci.Add(rekreativac);
connection.SaveChanges();
return(nalog);
}
}
catch (Exception)
{
return(null);
}
}
public IActionResult Add(Teacher teacher)
{
_context.Teacher.Add(teacher);
_context.SaveChanges();
return(RedirectToAction("TeacherList"));
}
public IActionResult Add(Student student)
{
_context.Student.Add(student);
_context.SaveChanges();
return(RedirectToAction("StudentList"));
}
public bool DodajNovogKlijenta(KlijentViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Nalozi nalog = new Nalozi();
nalog.Email = model.Email;
nalog.Ime = model.Ime;
nalog.Prezime = model.Prezime;
nalog.Lozinka = model.DatumRodjenja.Value.ToString("ddMMyyyy");
nalog.IsRekreativac = model.IsRekreativac ? true : false;
nalog.IsAdministrator = false;
nalog.IsPlivac = model.IsPlivac ? true : false;
nalog.IsTrener = false;
nalog.Aktivan = true;
connection.Nalozi.Add(nalog);
connection.SaveChanges();
if (model.IsPlivac)
{
Plivaci plivac = new Plivaci();
plivac.Email = model.Email;
plivac.Ime = model.Ime;
plivac.Prezime = model.Prezime;
plivac.DatumRodjenja = model.DatumRodjenja;
plivac.Spol = model.Spol;
plivac.Telefon = model.Telefon;
plivac.NalogId = nalog.Id;
connection.Plivaci.Add(plivac);
connection.SaveChanges();
}
else
{
Rekreativci rekreativac = new Rekreativci();
rekreativac.Email = model.Email;
rekreativac.Ime = model.Ime;
rekreativac.Prezime = model.Prezime;
rekreativac.DatumRodjenja = model.DatumRodjenja;
rekreativac.Spol = model.Spol;
rekreativac.Telefon = model.Telefon;
rekreativac.NalogId = nalog.Id;
connection.Rekreativci.Add(rekreativac);
connection.SaveChanges();
}
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public IActionResult Create([FromBody] ITipoDoc postData)
{
if (postData == null)
{
return(BadRequest());
}
_context.TiposDoc.Add(postData);
_context.SaveChanges();
return(CreatedAtRoute("GetTiposDoc", new { Id = postData.Id }, postData));
}
public IActionResult StudentPaymentAdd(StudentPayment studentPayment)
{
Int64 Id = studentPayment.Id;
_context.StudentPayment.Add(studentPayment);
_context.SaveChanges();
return(RedirectToAction("Students", new{ id = Id }));
}
public IActionResult Create([FromBody] ICondicionIVA postData)
{
if (postData == null)
{
return(BadRequest());
}
_context.CondicionesIVA.Add(postData);
_context.SaveChanges();
return(CreatedAtRoute("GetCondicionesIVA", new { Id = postData.Id }, postData));
}
public IActionResult TeacherPaymentAdd(TeacherPayment teacherPayment)
{
Int64 Id = teacherPayment.TeacherId;
_context.TeacherPayment.Add(teacherPayment);
_context.SaveChanges();
return(RedirectToAction("Teacher", new { id = Id }));
}
public void AddItem(string type, int amount)
{
for (int i = 0; i < amount; i++)
{
var item = new Item()
{
Type = type,
InventoryCode = RandomString(6)
};
_db.Items.Add(item);
_db.SaveChanges();
}
}
private void cutomButton2_Click(object sender, EventArgs e)
{
User us = new User();
int cc = db.Users.Count();
if (txtRGPPassword.Text == txtRGPPassCheck.Text)
{
if (cc <= 0)
{
us.TC = txtRGPTC.Text;
us.name = txtRGPUserName.Text;
us.lastName = txtRGPLastName.Text;
us.password = txtRGPPassword.Text;
us.eMail = txtRGPmail.Text;
us.phone = txtRGPphone.Text;
us.driveLicense = txtRGPliceneNo.Text;
db.Users.Add(us);
db.SaveChanges();
MessageBox.Show("Kayıt başarılı");
}
else
{
foreach (User item in db.Users.ToList())
{
if (item.TC != txtRGPTC.Text)
{
us.TC = txtRGPTC.Text;
us.name = txtRGPUserName.Text;
us.lastName = txtRGPLastName.Text;
us.password = txtRGPPassword.Text;
us.eMail = txtRGPmail.Text;
us.phone = txtRGPphone.Text;
us.driveLicense = txtRGPliceneNo.Text;
db.Users.Add(us);
db.SaveChanges();
MessageBox.Show("Kayıt başarılı");
}
else
{
MessageBox.Show("Aynı TC'ye ait başka kullanıcı mevcut.");
}
}
}
}
else
{
txtRGPPassword.ForeColor = Color.Red;
txtRGPPassCheck.ForeColor = Color.Red;
MessageBox.Show("Girilen şifreler uyuşmadı!");
}
}
public IActionResult Create([FromBody] ICliente postData)
{
if (postData == null)
{
return(BadRequest());
}
postData.TipoDoc = _context.TiposDoc.Find(postData.TipoDoc.Id);
postData.CondicionIVA = _context.CondicionesIVA.Find(postData.CondicionIVA.Id);
_context.Clientes.Add(postData);
_context.SaveChanges();
_hubContext.Clients.All.SendAsync("cacheUpdate", "Clientes");
return(CreatedAtRoute("GetCliente", new { Id = postData.Id }, postData));
}
public void cutomButton1_Click(object sender, EventArgs e)
{
starDate = dateTimePicker1.Value;
endDate = dateTimePicker2.Value;
DateTime StartingDate = dateTimePicker1.Value;
DateTime EndingDate = dateTimePicker2.Value;
Car carCTRL = db.Cars.Where(x => x.CarID == Carid).First();
DateTime DataStartingDate = carCTRL.hireStart;
DateTime DataStartingEnd = carCTRL.hireEnd;
int ilksecim = DateTime.Compare(EndingDate, DataStartingDate);
int sonsecim = DateTime.Compare(StartingDate, DataStartingEnd);
if (ilksecim == 1 && sonsecim == 1)
{ //yes
if (endDate > starDate)
{
hireTime = Convert.ToInt32((EndDate - StarDate).TotalDays);
hr.hireStart = StarDate;
hr.hireEnd = EndDate;
hr.carID = Carid;
hr.price = price;
hr.UserID = UserID;
hr.hireTime = hireTime;
db.Hires.Add(hr);
db.SaveChanges();
MessageBox.Show("Araç kiralandı");
Car cr = db.Cars.Where(x => x.CarID == Carid).First();
cr.hireStart = StarDate;
cr.hireEnd = EndDate;
db.SaveChanges();
}
else
{
MessageBox.Show("Kiralama başlangıç tarihi teslim tarihinden önce olmalıdır!!");
}
}
else
{
MessageBox.Show("araç rezerve");
}
}
public void Additem(string username, int id)
{
var a = (User)_db.Users.AsNoTracking().Where(i => i.UserName == username).FirstOrDefault();
var item = (Item)_db.Items.AsNoTracking().FirstOrDefault(i => i.Id == id);
var ie = new Item()
{
Id = item.Id,
InventoryCode = item.InventoryCode,
Type = item.Type,
user = a
};
//var user = new User()
//{
// Id=a.Id,
// UserName=a.UserName,
// Name=a.Name,
// LastName=a.LastName,
// Email=a.Email,
// NormalizedEmail=a.NormalizedEmail,
// NormalizedUserName=a.NormalizedUserName,
// PasswordHash=a.PasswordHash,
// PhoneNumber=a.PhoneNumber,
// PhoneNumberConfirmed=a.PhoneNumberConfirmed,
// p
//};
//var x = _db.Users.Where(i => i.UserName == username).Include(i => i.i);
//_db.Update()
//a.Items.Add(ie);
//_db.Users.Update(a);
_db.Items.Update(ie);
_db.SaveChanges();
}
public IActionResult AttendanceTaken(List <AttendanceStudentListVM> attendanceStudentListVM)
{
if (HttpContext.Session.GetString("Faculty") != null &&
HttpContext.Session.GetString("Faculty") != "Expired")
{
var faculty = HttpContext.Session.GetString("Faculty");
var facultyId = db.Faculty.Where(a => a.UserName == faculty).FirstOrDefault();
ViewBag.FacultyName = facultyId.FirstName + " " + facultyId.LastName;
for (int i = 0; i < attendanceStudentListVM.Count; i++)
{
AttendanceList attendanceList = new AttendanceList();
attendanceList.ClassId = attendanceStudentListVM[i].classIdVM;
attendanceList.CourseId = attendanceStudentListVM[i].courseIdVM;
attendanceList.Date = attendanceStudentListVM[i].dateVM;
attendanceList.StudentId = attendanceStudentListVM[i].StudentIdVM;
attendanceList.TeacherId = facultyId.id;
attendanceList.ClassTimeId = attendanceStudentListVM[i].timeIdVM;
attendanceList.Status = attendanceStudentListVM[i].Status;
if (attendanceStudentListVM[i].Status == 0)
{
MessageList messageList = new MessageList();
{
messageList.MessageTitle = "Absent alert.";
messageList.TeacherId = facultyId.id;
messageList.Date = DateTime.Now.ToString("M/d/yyyy");
messageList.Time = DateTime.Now.ToString("hh:mm tt");
var courseId = db.Course.Where(a => a.Id == attendanceStudentListVM[i].courseIdVM).FirstOrDefault();
var sid = db.Student.Where(e => e.Id == attendanceList.StudentId).FirstOrDefault();
var sname = sid.FirstName + " " + sid.LastName;
messageList.MessageDetail = "Your son/daughter Mr/Mrs " + sname + " was absent in " + courseId.CourseName + " class at " + messageList.Time + " on " + messageList.Date + ".";
messageList.SentBy = "tc";
var gId = db.Student.Where(a => a.Id == attendanceList.StudentId).FirstOrDefault();
messageList.GuardianId = gId.GuardianId;
};
db.MessageList.Add(messageList);
db.SaveChanges();
}
db.AttendanceList.Add(attendanceList);
db.SaveChanges();
}
return(RedirectToAction("AttendancePanel"));
}
return(RedirectToAction("Login"));
}
public ActionResult Create(designation desg)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
db.designations.Add(desg);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(desg));
}
catch
{
return(View());
}
}
public ActionResult Create(office off)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
db.offices.Add(off);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(off));
}
catch
{
return(View());
}
}
public void CanUseContext()
{
using (var ctx = new dataContext())
{
ctx.Todos.Add(new Todos {
Id = 1
});
ctx.SaveChanges();
Assert.AreEqual(1, ctx.Todos.ToList().Count());
}
}
public bool DodajNovogTrenera(TrenerViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Nalozi nalog = new Nalozi();
nalog.Email = model.Email;
nalog.Ime = model.Ime;
nalog.Prezime = model.Prezime;
nalog.Lozinka = model.DatumRodjenja.Value.ToString("ddMMyyyy");
nalog.IsRekreativac = false;
nalog.IsAdministrator = false;
nalog.IsPlivac = false;
nalog.IsTrener = true;
nalog.Aktivan = true;
connection.Nalozi.Add(nalog);
connection.SaveChanges();
Treneri trener = new Treneri();
trener.Email = model.Email;
trener.Ime = model.Ime;
trener.Prezime = model.Prezime;
trener.DatumRodjenja = model.DatumRodjenja;
trener.Zvanje = model.Zvanje;
trener.Spol = model.Spol;
trener.Kontakt = model.Telefon;
trener.NalogId = nalog.Id;
connection.Treneri.Add(trener);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public IActionResult Register(Login login)
{
if (ModelState.IsValid)
{
_context.Login.Add(login);
_context.SaveChanges();
ModelState.Clear();
ViewBag.Message = login.Id + " is succesfully registered.";
}
return(RedirectToAction("Index"));
}
public ActionResult Contact()
{
ViewBag.Message = "Your contact page.";
string password = "******";
MD5 md5 = new MD5CryptoServiceProvider();
UTF8Encoding encoder = new UTF8Encoding();
Byte[] originalBytes = encoder.GetBytes(password);
Byte[] encodedBytes = md5.ComputeHash(originalBytes);
password = BitConverter.ToString(encodedBytes).Replace("-", "");
var result = password.ToLower();
Guid g = Guid.NewGuid();
//int g = 123456;
dataContext context = new dataContext();
context.Users.Add(new user()
{
email = "*****@*****.**", userName = "******", password = result, confirmCode = g.ToString()
});
context.SaveChanges();
try
{
SmtpClient client = new SmtpClient("smtp.yandex.com", 587);
client.EnableSsl = true;
client.DeliveryMethod = SmtpDeliveryMethod.Network;
client.Credentials = new NetworkCredential("*****@*****.**", "sifre84info");
MailAddress from = new MailAddress("*****@*****.**", "Hüseyin");
MailAddress to = new MailAddress("*****@*****.**");
MailMessage message = new MailMessage(from, to);
message.Body = "body" + g;
message.IsBodyHtml = true;
message.Subject = "subject";
message.SubjectEncoding = System.Text.Encoding.UTF8;
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls;
client.Send(message);
}
catch (Exception ex)
{
throw ex;
}
return(View());
}
public ActionResult Create([Bind(Include = "Imie, Nazwisko, Wiek, Opis, Data_zaginiecia, Znaki_szczegolne, Lokalizacja")] LosePeople losepeople)
{
try
{
if (ModelState.IsValid)
{
db.LosePeople.Add(losepeople);
db.SaveChanges();
return(RedirectToAction("List"));
}
}
catch (RetryLimitExceededException /* dex */)
{
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(losepeople));
}
private void buttonAddUser_Click(object sender, EventArgs e)
{
try {
dataContext data = new dataContext();
User newUser = new User()
{
_name = boxName.Text,
_userName = boxUserName.Text,
_password = boxPassword.Text
};
data.Users.Add(newUser);
data.SaveChanges();
new Message("Saved", 1);
}
catch {
new Message("Wrong Hapen :(", 2);
}
}
public bool DodajPlivacaNaTakmicenje(int takmicenjeId, int plivacId)
{
try
{
using (dataContext connection = new dataContext())
{
TakmicenjaPlivaci takmicenjePlivac = new TakmicenjaPlivaci();
takmicenjePlivac.PlivacId = plivacId;
takmicenjePlivac.TakmicenjeId = takmicenjeId;
connection.TakmicenjaPlivaci.Add(takmicenjePlivac);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool DodajGrupu(GrupaViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Grupe grupa = new Grupe();
grupa.Uzrast = model.Uzrast;
grupa.Vrsta = model.Vrsta;
connection.Grupe.Add(grupa);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool DodajBazen(BazenViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Bazeni bazen = new Bazeni();
bazen.Dimenzije = model.Dimenzije;
bazen.Naziv = model.Naziv;
bazen.Opis = model.Opis;
bazen.GradId = model.GradId;
if (model.Slika != null)
{
string pic = System.IO.Path.GetFileName(model.Slika.FileName);
string path = System.IO.Path.Combine(
System.Web.HttpContext.Current.Server.MapPath("~/assets/image/bazeni"), pic);
// file is uploaded
model.Slika.SaveAs(path);
// save the image path path to the database or you can send image
// directly to database
// in-case if you want to store byte[] ie. for DB
using (MemoryStream ms = new MemoryStream())
{
model.Slika.InputStream.CopyTo(ms);
byte[] array = ms.GetBuffer();
}
bazen.Slika = pic;
}
connection.Bazeni.Add(bazen);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public bool DodajNovoTakmicenje(TakmicenjeViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Takmicenja takmicenje = new Takmicenja();
takmicenje.Datum = model.Datum;
takmicenje.GradId = model.GradId;
takmicenje.Naziv = model.Naziv;
takmicenje.OsvojenaMjesta = model.OsvojenaMjesta;
connection.Takmicenja.Add(takmicenje);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
public IActionResult SentMessage(int TeachId, MessageList m)
{
if (HttpContext.Session.GetString("Guardian") != null &&
HttpContext.Session.GetString("Guardian") != "Expired")
{
var guardian = HttpContext.Session.GetString("Guardian");
var guardianId = db.Guardian.Where(a => a.UserName == guardian).FirstOrDefault();
ViewBag.GuardianName = guardianId.FirstName + " " + guardianId.LastName;
ViewBag.FacultyName = db.Faculty.Where(b => b.id == TeachId).FirstOrDefault();
ViewBag.StuName = db.Student.Where(b => b.GuardianId == guardianId.id).ToList();
var i = TeachId;
if (m.MessageTitle != null && m.MessageDetail != null)
{
MessageList msg = new MessageList()
{
MessageTitle = m.MessageTitle,
MessageDetail = m.MessageDetail,
TeacherId = m.TeacherId = TeachId,
GuardianId = m.GuardianId = guardianId.id,
Date = m.Date = DateTime.Now.ToString("M/d/yyyy"),
Time = m.Time = DateTime.Now.ToString("hh:mm tt"),
SentBy = m.SentBy = "gd",
};
db.MessageList.Add(msg);
db.SaveChanges();
ModelState.Clear();
return(RedirectToAction("ShowSentMessage"));
}
else
{
ViewBag.ErrorMessage = "Fill up all the field";
return(View());
}
}
return(RedirectToAction("Login"));
}
public bool DodajTermin(TerminViewModel model)
{
try
{
using (dataContext connection = new dataContext())
{
Termini termin = new Termini();
termin.TrenerId = model.TrenerId;
termin.GrupaId = model.GrupaId;
termin.BazenId = model.BazenId;
termin.VrijemeDo = model.VrijemeDo;
termin.VrijemeOd = model.VrijemeOd;
connection.Termin.Add(termin);
connection.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
private void btbSave_Click(object sender, EventArgs e)
{
var date1 = new DateTime(1900, 1, 1, 8, 30, 52);
var date2 = new DateTime(1900, 1, 1, 8, 30, 52);
Car cr = new Car();
cr.carBrand = txtCarBrad.Text;
cr.carModel = txtCarModel.Text;
cr.fuel = txtFuel.Text;
cr.gear = txtGear.Text;
cr.licensePlate = txtLicnPlate.Text;
cr.carType = txtType.Text;
cr.carPic = txtPicRL.Text;
cr.hireStart = date1;
cr.hireEnd = date2;
cr.priceClass = int.Parse(comboBox1.SelectedItem.ToString());
db.Cars.Add(cr);
db.SaveChanges();
ResetText();
carList();
}
public IActionResult addDummy([FromBody] dummyModel dummy)
{
db.People.Add(dummy);
db.SaveChanges();
return(Ok(dummy));
}
