public ActionResult Create(FormCollection collection) { try { // TODO: Add insert logic here try { //fill business object var info = new EducationLevelInfo(); /* info.EducationLevelId = collection["EducationLevelId"]; info.Name = collection["Name"]; info.Description = collection["Description"]; info.CreatedBy = collection["CreatedBy"]; */ EducationLevelRepository.Create(info); } catch (Exception ex) { } return RedirectToAction("Index"); } catch { return View(); } }
private static List<EducationLevelInfo> FillEducationLevelCollection(IDataReader reader, out int totalRecords) { var retVal = new List<EducationLevelInfo>(); totalRecords = 0; try { while (reader.Read()) { //fill business object var info = new EducationLevelInfo(); info.EducationLevelId = ConvertHelper.ToInt32(reader["EducationLevelId"]); info.Name = ConvertHelper.ToString(reader["Name"]); info.Description = ConvertHelper.ToString(reader["Description"]); info.CreatedBy = ConvertHelper.ToInt32(reader["CreatedBy"]); info.CreatedDate = ConvertHelper.ToDateTime(reader["CreatedBy"]); retVal.Add(info); } //Get the next result (containing the total) reader.NextResult(); //Get the total no of records from the second result if (reader.Read()) { totalRecords = Convert.ToInt32(reader[0]); } } catch (Exception exc) { //DotNetNuke.Services.Exceptions.Exceptions.LogException(exc); } finally { //close datareader ObjectHelper.CloseDataReader(reader, true); } return retVal; }
public string Edit(FormDataCollection form) { var retVal = string.Empty; var operation = form.Get("oper"); var id = ConvertHelper.ToInt32(form.Get("EducationLevelId")); var curUserInfo = UserRepository.GetCurrentUserInfo(); if (!string.IsNullOrEmpty(operation)) { EducationLevelInfo info = null; switch (operation) { case "edit": info = EducationLevelRepository.GetInfo(id); if (info != null) { info.Name = form.Get("Name"); info.Description = form.Get("Description"); EducationLevelRepository.Update(info); } break; case "add": info = new EducationLevelInfo { Name = form.Get("Name"), Description = form.Get("Description"), CreatedBy = curUserInfo.UserID, CreatedDate = DateTime.Now }; EducationLevelRepository.Create(info); break; case "del": EducationLevelRepository.Delete(id); break; } } StoreData.ListEducationLevel = EducationLevelRepository.GetAll(); return retVal; }
public static void Update(EducationLevelInfo info) { DataProvider.Instance().EducationLevels_Update( info.EducationLevelId, info.Name, info.Description, info.CreatedBy,info.CreatedDate); }
public static int Create(EducationLevelInfo info) { return DataProvider.Instance().EducationLevels_Insert( info.Name, info.Description, info.CreatedBy, info.CreatedDate); }