protected void btnAddExistingChild_Click(object sender, EventArgs e) { List<child> subscribedChildren = (List<child>) Session["subscribedChildren"] ?? new List<child>(); List<int> selectedChildIndices = lstAllChildren.GetSelectedIndices().ToList(); List<child> childrenToAdd = new List<child>(); int courseID = Convert.ToInt32(Request.QueryString["courseID"]); course course = new crud().selectCourse(courseID); selectedChildIndices.ForEach(childIndex => childrenToAdd.Add(new crud().selectChild(Convert.ToInt32(lstAllChildren.Items[childIndex].Value)))); bool containsErroneousChild = false; foreach (child child in childrenToAdd) { if (childHasCorrectAge(child.dateOfBirth, course.courseType.ageFrom, course.courseType.ageToInclusive)) { subscribedChildren.Add(child); } else { containsErroneousChild = true; } } if (containsErroneousChild) { ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, "Enkel de kinderen met een toegelaten leeftijd werden toegevoegd."); } Session["subscribedChildren"] = subscribedChildren; refreshLists(courseID); }
public int simpanberita(string idberita, string idkatberita, string judul, string tanggal, string isiberita, string sumber, string idadmin, string foto) { crud con = new crud(); SqlConnection sqlcon = con.sambung(); int result = 0; using (sqlcon) { sqlcon.Open(); string sql = "INSERT INTO Berita VALUES(@ID_Berita, @ID_Kategori, @Judul, @Tanggal, @IsiBerita, @Sumber, @ID_Admin, @Foto)"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Berita", idberita)); sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", idkatberita)); sqlcom.Parameters.Add(new SqlParameter("@Judul", judul)); sqlcom.Parameters.Add(new SqlParameter("@Tanggal", tanggal)); sqlcom.Parameters.Add(new SqlParameter("@IsiBerita", isiberita)); sqlcom.Parameters.Add(new SqlParameter("@Sumber", sumber)); sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", idadmin)); sqlcom.Parameters.Add(new SqlParameter("@Foto", foto)); sqlcom.ExecuteNonQuery(); } //HttpResponse.ReferenceEquals("KatBerita.aspx"); } return(result); }
protected void grdResults_RowCommand(object sender, GridViewCommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = grdResults.Rows[index]; int subscriptionID = Convert.ToInt32(row.Cells[0].Text); switch (e.CommandName) { case "paySubscription": crud crud = new crud(); subscription subscription = crud.selectSubscription(subscriptionID); subscription.paymentConfirmed = true; crud.updateSubscription(subscription); break; case "removeSubscription": new crud().deleteSubscription(subscriptionID); break; default: break; } if (ddCourseNames.SelectedIndex > 0) { ddCourseNames_SelectedIndexChanged(sender, EventArgs.Empty); return; } else if (ddUserProfiles.SelectedIndex > 0) { ddUserProfiles_SelectedIndexChanged(sender, EventArgs.Empty); return; } else { cldrDates_SelectionChanged(sender, EventArgs.Empty); } }
public ActionResult DeleteConfirmed(int id) { crud crud = db.crud.Find(id); db.crud.Remove(crud); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,name,mobile,email")] crud crud) { if (ModelState.IsValid) { db.Entry(crud).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(crud)); }
public ActionResult executefiles(uidata sample) { crud objj2 = new crud(); string storeserver = TempData["storeserver"].ToString(); string path = sample.path; objj2.setconn(storeserver, "master"); ViewBag.hello = objj2.ExecuteSequentialFile(path, storeserver); return(View("home")); }
protected void btnSaveNewCourse_Click(object sender, EventArgs e) { customValidator validator = new customValidator(); validator.addValidationRule(new customValidationRule(txtNewName, validator.required, null, "Gelieve een naam in te vullen")); validator.addValidationRule(new customValidationRule(txtNewDescription, validator.required, null, "Gelieve een omschrijving in te vullen")); validator.addValidationRule(new customValidationRule(txtNewStartDate, validator.required, null, "Gelieve een startdatum in te vullen")); validator.addValidationRule(new customValidationRule(txtNewStartDate, validator.validDate, null, "Gelieve een geldige startdatum in te vullen")); validator.addValidationRule(new customValidationRule(txtNewEndDateInclusive, validator.required, null, "Gelieve een einddatum in te vullen")); validator.addValidationRule(new customValidationRule(txtNewEndDateInclusive, validator.validDate, null, "Gelieve een geldige einddatum in te vullen")); validator.addValidationRule(new customValidationRule(txtNewStartHour, validator.required, null, "Gelieve een startuur in te vullen")); validator.addValidationRule(new customValidationRule(txtNewStartHour, validator.hour, null, "Gelieve een geldig startuur in te vullen")); validator.addValidationRule(new customValidationRule(txtNewEndHour, validator.required, null, "Gelieve een einduur in te vullen")); validator.addValidationRule(new customValidationRule(txtNewEndHour, validator.hour, null, "Gelieve een geldig einduur in te vullen")); validator.addValidationRule(new customValidationRule(txtNewMaxSubscriptions, validator.required, null, "Gelieve het maximum aantal inschrijvingen in te vullen")); validator.addValidationRule(new customValidationRule(txtNewMaxSubscriptions, validator.numeric, null, "Gelieve het maximum aantal inschrijvingen in te vullen als geheel getal")); validator.addValidationRule(new customValidationRule(txtNewPrice, validator.required, null, "Gelieve een prijs in te vullen")); validator.addValidationRule(new customValidationRule(txtNewPrice, validator.numeric, null, "Gelieve een prijs in te vullen als geheel getal")); List<string> errors = validator.validate(); StringBuilder messageText = new StringBuilder(); if (errors.Count > 0) { foreach (string error in errors) { messageText.Append(error + "<br>"); } ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, messageText.ToString()); return; } if (selectedCourseType == null || selectedLocation == null) { ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, "Gelieve een cursustype en locatie te selecteren"); return; } crud crud = new crud(); course course = new course() { name = txtNewName.Text, description = txtNewDescription.Text, courseType = selectedCourseType, location = selectedLocation, startDate = Convert.ToDateTime(txtNewStartDate.Text), endDateInclusive = Convert.ToDateTime(txtNewEndDateInclusive.Text), startHour = txtNewStartHour.Text, endHour = txtNewEndHour.Text, maxSubscriptions = Convert.ToInt32(txtNewMaxSubscriptions.Text), price = Convert.ToInt32(txtNewPrice.Text) }; crud.insertCourse(course); clearNewCourseForm(); fillCoursesList(crud); }
protected void Delete(object sender, EventArgs e) { LinkButton lnkRemove = (LinkButton)sender; crud hapus = new crud(); hapus.DeleteAdmin(lnkRemove.CommandArgument); Response.Write("<script>alert('Data Berhasil Dihapus');</script>"); Response.Redirect("EditDeleteAdmin.aspx"); }
public ActionResult Create([Bind(Include = "id,name,mobile,email")] crud crud) { if (ModelState.IsValid) { db.crud.Add(crud); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(crud)); }
internal bool login(string username, string password) { string encryptedPassword = new PNV_Cryptor.PNV_Cryptor("forgirlswholoveskateboarding", PNV_Cryptor.PNV_Cryptor.EncryptionMethods.TripleDes).EncryptData(password); int id = new crud().getIdForCredentials(username, encryptedPassword); if (id > 0) { Session["userID"] = id; return true; }; return false; }
protected void simpanKat_Click(object sender, EventArgs e) { try { crud smpn = new crud(); smpn.simpanadmin(txtid.Text, txtnama.Text, txtuser.Text, txtpswd1.Text); Response.Write("<script>alert('Data Success Added');</script>"); Response.Redirect("AddAdmin.aspx"); } catch (Exception ex) { txtError.Text = ex.Message; } }
// GET: cruds/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } crud crud = db.crud.Find(id); if (crud == null) { return(HttpNotFound()); } return(View(crud)); }
protected void btnAddNewChild_Click(object sender, EventArgs e) { // validate fields before continuing customValidator validator = new customValidator(); validator.addValidationRule(new customValidationRule(txtName, validator.required, null, settingsHelper.get("validator_required_name"))); validator.addValidationRule(new customValidationRule(txtFirstName, validator.required, null, settingsHelper.get("validator_required_firstname"))); validator.addValidationRule(new customValidationRule(txtDateOfBirth, validator.required, null, settingsHelper.get("validator_required_date_of_birth"))); validator.addValidationRule(new customValidationRule(txtDateOfBirth, validator.validDate, null, settingsHelper.get("validator_valid_date"))); List<string> errors = validator.validate(); StringBuilder messageText = new StringBuilder(); if (errors.Count > 0) { foreach (string error in errors) { messageText.Append(error + "<br>"); } ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, messageText.ToString()); return; } // if all is validated, continue... List<child> subscribedChildren = (List<child>) Session["subscribedChildren"] ?? new List<child>(); try { child newChild = new child(); newChild.name = txtName.Text; newChild.firstName = txtFirstName.Text; newChild.dateOfBirth = CreateDate(txtDateOfBirth.Text); newChild.id = generateTemporaryChildID(subscribedChildren.Select(child => child.id).ToList()); newChild.userProfileID = Convert.ToInt32(Session["userID"]); int courseID = Convert.ToInt32(Request.QueryString["courseID"]); course course = new crud().selectCourse(courseID); if (childHasCorrectAge(newChild.dateOfBirth, course.courseType.ageFrom, course.courseType.ageToInclusive)) { subscribedChildren.Add(newChild); Session["subscribedChildren"] = subscribedChildren; refreshLists(courseID); clearNewChildUI(); } else { ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, settingsHelper.get("error_child_wrong_age")); } } catch { ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, settingsHelper.get("error_complete_all_fields")); } }
public string saveChangesToCourse(string courseID, string description, string courseTypeID, string startDate, string endDate, string locationID, string maxSubscriptions, string price, string startHour, string endHour, string name) { const string success = "success"; const string failed = "failed"; // validate fields before continuing if (string.IsNullOrWhiteSpace(courseID) || string.IsNullOrWhiteSpace(description) || string.IsNullOrWhiteSpace(courseTypeID) || string.IsNullOrWhiteSpace(startDate) || string.IsNullOrWhiteSpace(endDate) || string.IsNullOrWhiteSpace(locationID) || string.IsNullOrWhiteSpace(maxSubscriptions) || string.IsNullOrWhiteSpace(price) || string.IsNullOrWhiteSpace(startHour) || string.IsNullOrWhiteSpace(endHour) || string.IsNullOrWhiteSpace(name)) { return "Gelieve alle velden in te vullen of na te kijken"; } customValidator validator = new customValidator(); if (!validator.validDate(startDate) || !validator.validDate(endDate)) return "Gelieve geldige datums in te vullen (dd/mm/yyyy)"; if (!validator.hour(startHour) || !validator.hour(endHour)) return "Gelieve geldige uren in te vullen (hh:mm)"; // if all is validated, continue... crud crud = new crud(); course course = crud.selectCourse(Convert.ToInt32(courseID)); course.name = name; course.description = description; course.courseType = crud.selectCourseType(Convert.ToInt32(courseTypeID)); course.startDate = Convert.ToDateTime(startDate); course.endDateInclusive = Convert.ToDateTime(endDate); course.location = crud.selectLocation(Convert.ToInt32(locationID)); course.maxSubscriptions = Convert.ToInt32(maxSubscriptions); course.price = Convert.ToInt32(price); course.startHour = startHour; course.endHour = endHour; if (crud.updateCourse(course) > 0) { return success; }; return failed; }
protected void simpanKat_Click(object sender, EventArgs e) { try { crud updt = new crud(); updt.ubahAdmin(txtidadmin.Text, txtnama.Text, txtuser.Text, txtpwd.Text); Response.Write("<script>alert('Data Berhasil Diperbaharui');</script>"); Response.Redirect("EditDeleteAdmin.aspx"); fillgvKat(); } catch (Exception ex) { txtError.Text = ex.Message; } }
protected void ddUserProfiles_SelectedIndexChanged(object sender, EventArgs e) { int userProfileID = Convert.ToInt32(ddUserProfiles.SelectedValue); crud crud = new crud(); List<subscription> subscriptions = crud.getAllSubscriptionsForUserProfile(userProfileID); DataTable table = getFilledSubscriptionTable(subscriptions); grdResults.DataSource = table; grdResults.DataBind(); resultsFor.InnerText = ddUserProfiles.SelectedItem.Text; ddCourseNames.SelectedIndex = -1; cldrDates.SelectedDate = DateTime.Now; }
protected void cldrDates_SelectionChanged(object sender, EventArgs e) { DateTime selectedDate = cldrDates.SelectedDate; crud crud = new crud(); List<subscription> subscriptions = crud.getAllSubscriptionsForCoursesOnDate(selectedDate); DataTable table = getFilledSubscriptionTable(subscriptions); grdResults.DataSource = table; grdResults.DataBind(); resultsFor.InnerText = selectedDate.ToShortDateString(); ddCourseNames.SelectedIndex = -1; ddUserProfiles.SelectedIndex = -1; }
protected void simpanKat_Click(object sender, EventArgs e) { try { //string kat,strid; //int id = 0; //kat = txtKat.Text; ////sampai disini buat sendiri validasinya ya //strid = txtid.Text; ////jika strid kosong berarti form dalam kondisi untuk menginsert, jika ada isinya maka dalam kondisi mengupdate //if (strid.Length > 0) //{ // id = int.Parse(strid); //} //bool isSukses = this.insertKat(id, kat); //simpanKat.Text = "Simpan"; //fillgvKat(); //if (isSukses == true) //{ // txtError.Text = "Sukses Menyimpan Data"; // //bersihkan form // txtKat.Text = string.Empty; // txtid.Value = string.Empty; //} //else //{ // txtError.Text = "Gagal Menyimpan Data"; //} crud smpn = new crud(); smpn.simpan(txtid.Text, txtKat.Text); Response.Write("<script>alert('Data Success Added');</script>"); Response.Redirect("AddNewsCategory.aspx"); } catch (Exception ex) { txtError.Text = ex.Message; } }
public void DeleteAdmin(string IDAdmin) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "DELETE FROM Admin WHERE ID_Admin = @ID_Admin"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", IDAdmin)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
// initializers protected void Page_Load(object sender,EventArgs e) { NinaSubscriptionsMaster master = this.Master as NinaSubscriptionsMaster; master.setHeaderTitle(settingsHelper.get("title_mijn_gegevens")); userProfile user = master.getLoggedInUserProfile(); if (user == null) { Response.Redirect("~/Pages/Public/bekijkAanbod.aspx"); }; fillPersonalData(user); crud crud = new crud(); lstvChildren.DataSource = crud.getAllChildrenForUserProfile(user.id); lstvChildren.DataBind(); lstvSubscriptions.DataSource = crud.getAllSubscriptionsForUserProfile(user.id); lstvSubscriptions.DataBind(); }
public void Delete(string IDcat) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "DELETE FROM Kategori WHERE ID_Kategori = @ID_Kategori"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", IDcat)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
public void ubah(string idkat, string namakat) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "UPDATE Kategori SET NamaKategori = @NamaKategori WHERE ID_Kategori = @ID_Kategori"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", idkat)); sqlcom.Parameters.Add(new SqlParameter("@NamaKategori", namakat)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
public void simpan(string id, string nama) { crud con = new crud(); SqlConnection sqlcon = con.sambung(); using (sqlcon) { sqlcon.Open(); string sql = "INSERT INTO Kategori VALUES(@ID_Kategori, @NamaKategori)"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Kategori", id)); sqlcom.Parameters.Add(new SqlParameter("@NamaKategori", nama)); sqlcom.ExecuteNonQuery(); } sqlcon.Close(); //HttpResponse.ReferenceEquals("KatBerita.aspx"); } }
public ActionResult Nuevo(CrudViewModel model) { if (ModelState.IsValid) { using (PruebaEntities db = new PruebaEntities()) { var oCrud = new crud(); oCrud.Id = model.Id; oCrud.Nombre = model.Nombre; oCrud.Correo = model.Correo; oCrud.Fecha_nacimiento = model.Fecha_Nacimiento; db.crud.Add(oCrud); db.SaveChanges(); } return(Redirect("~/Crud/")); } return(View(model)); }
//crud untuk berita //public void cbIDkasus() //{ // crud con = new crud(); // SqlConnection sqlcon = con.sambung(); // SqlDataAdapter sqlda = new SqlDataAdapter("select * from Kategori", sqlcon); // sqlcon.Open(); // SqlCommand sqlselect = new SqlCommand("Select ID_Kategori from Kategori", sqlcon); // SqlDataReader dr = sqlselect.ExecuteReader(); // while (dr.Read()) // { // ArrayList MyAL = new ArrayList(); // MyAL.Add(dr.GetString(0)); // foreach (string s in MyAL) // cbidkasus.Items.Add(s); // cbidkasus.SelectedIndex = 0; // } // sqlcon.Close(); //} // crud untuk admin public void ubahAdmin(string idA, string namaA, string username, string pass) { crud con = new crud(); conn = con.sambung(); using (conn) { conn.Open(); string sql = "UPDATE Admin SET Nama = @Nama, Username = @Username, Password = @Password WHERE ID_Admin = @ID_Admin"; SqlCommand sqlcom = new SqlCommand(sql, conn); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", idA)); sqlcom.Parameters.Add(new SqlParameter("@Nama", namaA)); sqlcom.Parameters.Add(new SqlParameter("@Username", username)); sqlcom.Parameters.Add(new SqlParameter("@Password", pass)); sqlcom.ExecuteNonQuery(); } conn.Close(); } }
public void simpanadmin(string id, string nama, string user, string password) { crud con = new crud(); SqlConnection sqlcon = con.sambung(); using (sqlcon) { sqlcon.Open(); string sql = "INSERT INTO Admin VALUES(@ID_Admin, @Nama, @Username, @Password)"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.Add(new SqlParameter("@ID_Admin", id)); sqlcom.Parameters.Add(new SqlParameter("@Nama", nama)); sqlcom.Parameters.Add(new SqlParameter("@Username", user)); sqlcom.Parameters.Add(new SqlParameter("@Password", password)); sqlcom.ExecuteNonQuery(); } sqlcon.Close(); //HttpResponse.ReferenceEquals("KatBerita.aspx"); } }
protected void Page_Load(object sender,EventArgs e) { NinaSubscriptionsMaster master = this.Master as NinaSubscriptionsMaster; // set page title master.setHeaderTitle(settingsHelper.get("title_bekijk_aanbod")); // load courses crud crud = new crud(); List<course> allCourses = crud.getAllCourses(); if (allCourses.Count < 1) { divNoCourses.Visible = true; lstvCourses.Visible = false; } else { divNoCourses.Visible = false; lstvCourses.Visible = true; lstvCourses.DataSource = allCourses; lstvCourses.DataBind(); } }
public ActionResult getfiles(uidata sample) { int i = 1; crud objj2 = new crud(); List <SelectListItem> filelist = new List <SelectListItem>(); string path = sample.path; DirectoryInfo dir = new DirectoryInfo(path); foreach (FileInfo flInfo in dir.GetFiles()) { filelist.Add(new SelectListItem { Text = flInfo.Name, Value = i.ToString() }); i++; } uidata uidata = new uidata(); uidata.filename = filelist; return(View("home", uidata)); }
public ActionResult connectservercall(uidata sample) { List <SelectListItem> filelist = new List <SelectListItem>(); filelist.Add(new SelectListItem { Text = "", Value = "" }); uidata uidata = new uidata(); uidata.filename = filelist; crud objj = new crud(); int result = Int32.Parse(sample.at); if (sample.servername != null) { TempData["storeserver"] = sample.servername; if (result == 1) { objj.setconn(sample.servername, "master"); } else { objj.setsqlconn(sample.servername, "master", sample.username, sample.password); } } ViewBag.connmessage = "Conncetion established successfully!!!"; objj.giveservernametobll(sample.servername); return(View("home", uidata)); }
protected void btnSaveSubscriptions_Click(object sender, EventArgs e) { crud crud = new crud(); List<child> subscribedChildren = (List<child>) Session["subscribedChildren"] ?? new List<child>(); int courseID = Convert.ToInt32(Request.QueryString["courseID"]); course course = crud.selectCourse(courseID); subscription subscription = new subscription(); subscription.course = course; subscription.paymentConfirmed = false; subscribedChildren.ForEach(child => child.id = child.id >= int.MaxValue - 10000 ? crud.insertChild(child) : child.id); foreach (child child in subscribedChildren) { subscription.child = child; if (new crud().getSubscriptionOnCourseAndChild(course.id, child.id).Count < 1) { crud.insertSubscription(subscription); } }; ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageSuccess, settingsHelper.get("success_subscriptions_saved")); }
// initializers protected void Page_Load(object sender, EventArgs e) { NinaSubscriptionsMaster master = this.Master as NinaSubscriptionsMaster; master.setHeaderTitle(settingsHelper.get("title_subscribe_to_course")); userProfile user = master.getLoggedInUserProfile(); if (user == null) { Response.Redirect(settingsHelper.get("default_redirect_page")); }; int courseID = Convert.ToInt32(Request.QueryString["courseID"]); crud crud = new crud(); course course = crud.selectCourse(courseID); fillCourseData(course); if (!IsPostBack) { Session.Remove("subscribedChildren"); refreshLists(courseID); }; }
// UI handlers protected void lstSubscribedChildren_ItemCommand(object sender, ListViewCommandEventArgs e) { if (string.Equals(e.CommandName, "removeChild")) { int childID = Convert.ToInt32(e.CommandArgument.ToString()); int courseID = Convert.ToInt32(Request.QueryString["courseID"]); List<subscription> subscriptions = new crud().getSubscriptionOnCourseAndChild(courseID, childID); subscription subscription = null; if (subscriptions.Count > 0) { subscription = subscriptions[0]; }; if (subscription == null || !subscription.paymentConfirmed) { List<child> subscribedChildren = (List<child>) Session["subscribedChildren"] ?? new List<child>(); subscribedChildren.Remove(subscribedChildren.Find(x => x.id == childID)); Session["subscribedChildren"] = subscribedChildren; } else { ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, "Inschrijvingen die reeds betaald werden kunnen niet worden verwijderd."); } refreshLists(Convert.ToInt32(Request.QueryString["courseID"])); } }
protected void lstvCourses_ItemCommand(object sender, ListViewCommandEventArgs e) { if (string.Equals(e.CommandName, "removeCourse")) { crud crud = new crud(); crud.deleteCourse(Convert.ToInt32(e.CommandArgument)); clearNewCourseForm(); fillCoursesList(crud); } }
private void refreshLists(int courseID) { crud crud = new crud(); List<child> subscribedChildren = (List<child>) Session["subscribedChildren"] ?? crud.getAllSubscriptionsForCourse(courseID).Select(x => x.child).ToList<child>(); List<child> childrenForUserProfile = new crud().getAllChildrenForUserProfile(Convert.ToInt32(Session["userID"])); subscribedChildren = subscribedChildren.Where(sChild => childrenForUserProfile.Find(uChild => uChild.id == sChild.id) != null ? true : sChild.id > int.MaxValue - 10001 ? true : false).ToList<child>(); subscribedChildren.ForEach(sChild => childrenForUserProfile.Remove(childrenForUserProfile.Find(uChild => uChild.id == sChild.id))); Session["subscribedChildren"] = subscribedChildren; // fill select box (all children for user profile) if (childrenForUserProfile.Count < 1) { divExistingChildSelector.Visible = false; divHasNoExistingChildren.Visible = true; } else { divExistingChildSelector.Visible = true; divHasNoExistingChildren.Visible = false; lstAllChildren.Items.Clear(); childrenForUserProfile.ForEach(uChild => lstAllChildren.Items.Add(new ListItem(uChild.firstName + " " + uChild.name, uChild.id.ToString()))); }; // fill list of children to subscribe lstSubscribedChildren.DataSource = subscribedChildren; lstSubscribedChildren.DataBind(); }
// initializers protected void Page_Load(object sender, EventArgs e) { NinaSubscriptionsMaster master = this.Master as NinaSubscriptionsMaster; master.setHeaderTitle(settingsHelper.get("title_beheer_cursussen")); userProfile user = master.getLoggedInUserProfile(); if (user == null || user.isAdmin == false) { Response.Redirect("~/Pages/Public/bekijkAanbod.aspx"); }; crud crud = new crud(); locations = crud.getAllLocations(); courseTypes = crud.getAllCourseTypes(); if (IsPostBack) { try { selectedCourseType = crud.selectCourseType(Convert.ToInt32(ddNewCourseType.SelectedValue)); selectedLocation = crud.selectLocation(Convert.ToInt32(ddNewLocation.SelectedValue)); } catch { // objecten blijven null, hierop wordt later gecontroleerd } } else { fillCoursesList(crud); } }
// helpers private void fillCoursesList(crud crud) { if (crud == null) { crud = new crud(); }; List<course> allCourses = crud.getAllCourses(); lstvCourses.DataSource = allCourses; lstvCourses.DataBind(); }
// initializers protected void Page_Load(object sender, EventArgs e) { NinaSubscriptionsMaster master = this.Master as NinaSubscriptionsMaster; master.setHeaderTitle(settingsHelper.get("title_bekijk_inschrijvingen")); userProfile user = master.getLoggedInUserProfile(); if (user == null || user.isAdmin == false) { Response.Redirect("~/Pages/Public/bekijkAanbod.aspx"); }; if (!IsPostBack) { crud crud = new crud(); // fill course dropdown List<course> allCourses = crud.getAllCourses(); course emptyCourse = new course() { id = 0 }; allCourses.Insert(0, emptyCourse); ddCourseNames.DataSource = allCourses; ddCourseNames.DataTextField = "name"; ddCourseNames.DataValueField = "id"; ddCourseNames.DataBind(); List<userProfile> allUserProfiles = crud.getAllUserProfiles(); userProfile emptyProfile = new userProfile() { id = 0 }; allUserProfiles.Insert(0, emptyProfile); ddUserProfiles.DataSource = allUserProfiles; ddUserProfiles.DataTextField = "fullname"; ddUserProfiles.DataValueField = "id"; ddUserProfiles.DataBind(); cldrDates.SelectedDate = DateTime.Now; } }
protected void btnRegister_Click(object sender, EventArgs e) { customValidator validator = new customValidator(); validator.addValidationRule(new customValidationRule(txtUsername, validator.required, null, "Gelieve een gebruikersnaam in te vullen")); validator.addValidationRule(new customValidationRule(txtName, validator.required, null, "Gelieve een naam in te vullen")); validator.addValidationRule(new customValidationRule(txtFirstName, validator.required, null, "Gelieve een voornaam in te vullen")); validator.addValidationRule(new customValidationRule(txtEmailAddress, validator.required, null, "Gelieve een emailadres in te vullen")); validator.addValidationRule(new customValidationRule(txtEmailAddress, validator.email, null, "Gelieve een geldig emailadres in te vullen")); validator.addValidationRule(new customValidationRule(txtPhone, validator.required, null, "Gelieve een telefoonnummer in te vullen")); validator.addValidationRule(new customValidationRule(txtStreet, validator.required, null, "Gelieve een straat in te vullen")); validator.addValidationRule(new customValidationRule(txtNumber, validator.required, null, "Gelieve een huisnummer in te vullen")); validator.addValidationRule(new customValidationRule(txtNumber, validator.numeric, null, "Gelieve een geheel getal in te vullen")); validator.addValidationRule(new customValidationRule(txtPostalCode, validator.required, null, "Gelieve een postcode in te vullen")); validator.addValidationRule(new customValidationRule(txtPlace, validator.required, null, "Gelieve een plaats in te vullen")); validator.addValidationRule(new customValidationRule(txtPassword, validator.required, null, "Gelieve een wachtwoord in te vullen")); validator.addValidationRule(new customValidationRule(txtPasswordRepeat, validator.required, null, "Gelieve een wachtwoord in te vullen")); List<string> errors = validator.validate(); StringBuilder messageText = new StringBuilder(); if (errors.Count > 0) { foreach (string error in errors) { messageText.Append(error + "<br>"); } ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, messageText.ToString()); return; } if (txtPassword.Text != txtPasswordRepeat.Text) { ((NinaSubscriptionsMaster) this.Master).setMessage(messageClasses.messageError, "De ingegeven wachtwoorden komen niet overeen."); return; } // if all is validated, continue... crud crud = new crud(); userProfile profile = new userProfile(); profile.userName = txtUsername.Text; profile.passwordHash = new PNV_Cryptor.PNV_Cryptor("forgirlswholoveskateboarding", PNV_Cryptor.PNV_Cryptor.EncryptionMethods.TripleDes).EncryptData(txtPassword.Text); profile.name = txtName.Text; profile.firstName = txtFirstName.Text; profile.emailAddress = txtEmailAddress.Text; profile.phone = txtPhone.Text; profile.street = txtStreet.Text; profile.number = Convert.ToInt32(txtNumber.Text); profile.postalCode = Convert.ToInt32(txtPostalCode.Text); profile.place = txtPlace.Text; profile.isAdmin = false; if (crud.insertUserProfile(profile) > 0) { NinaSubscriptionsMaster master = this.Master as NinaSubscriptionsMaster; if (master.login(txtUsername.Text, txtPassword.Text)) { master.setUIatLogin(); }; string redirectUrl = "bekijkAanbod.aspx"; if (Session["urlBeforeLogin"] != null) { redirectUrl = Session["urlBeforeLogin"].ToString(); }; string redirect = "<a href=\"" + redirectUrl + "\">U heeft zich succesvol geregistreerd. Klik hier om terugkeren naar de vorige pagina.</a>"; master.setMessage(messageClasses.messageSuccess, redirect); clearUI(); } else { NinaSubscriptionsMaster master = this.Master as NinaSubscriptionsMaster; master.setMessage(messageClasses.messageError, "Gelieve alle velden correct in te vullen."); }; }
protected void simpanBer_Click(object sender, EventArgs e) { if (katberita.SelectedItem.Value != "") { if (FileUploadControl.HasFile) { try { if (FileUploadControl.PostedFile.ContentType == "image/jpeg" || FileUploadControl.PostedFile.ContentType == "image/png") { if (FileUploadControl.PostedFile.ContentLength < 102400) { string filename = Path.GetFileName(FileUploadControl.FileName); FileUploadControl.SaveAs(Server.MapPath("../photoberita/") + filename); try { string strConn = WebConfigurationManager.ConnectionStrings["berita"].ConnectionString; koneksi = new SqlConnection(strConn); koneksi.Open(); string sql = @"select ID_Kategori from Kategori where NamaKategori = @NamaKategori"; SqlCommand cmd1 = new SqlCommand(sql, koneksi); cmd1.Parameters.AddWithValue("@NamaKategori", katberita.SelectedItem.Text); SqlDataReader dr = cmd1.ExecuteReader(); if (dr.Read()) { string id = dr.GetString(0); string idberita1 = txtidberita.Text; string idkatberita1 = id; string tanggal1 = lbldatetime.Text; string judul1 = txtjudul.InnerText; string isiberita1 = textareas.InnerText; string sumber1 = txtsumber.InnerText; string idadmin1 = txtidadmin.Text; crud test = new crud(); int result = test.simpanberita(idberita1, idkatberita1, tanggal1, judul1, isiberita1, sumber1, idadmin1, filename); Response.Write("<script>alert('Data Success Added');</script>"); reset(); Response.Redirect("AddNews.aspx"); if (result != 0) { Response.Redirect("AddNews.aspx"); } } } catch (Exception cek) { StatusLabel.Text = cek.Message; } finally { koneksi.Close(); } } else { StatusLabel.Text = "Status: The file has to be less than 100 kb!"; } } else { StatusLabel.Text = "Status: Only JPEG AND PNG files are accepted!"; } } catch (Exception ex) { StatusLabel.Text = "Status: The file could not be uploaded. The following error occured: " + ex.Message; } } } }