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