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