public StudentViewModel Edit(int Flag, StudentViewModel objEntity) { try { Database objDB = base.GetDatabase(); // Create a suitable command type and add the required parameter. using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT_VIEWMODEL_UPDATE)) { objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, Flag); objDB.AddInParameter(sprocCmd, COLUMN_NAME_ID, DbType.Int32, objEntity.Id); objDB.AddInParameter(sprocCmd, COLUMN_NAME_NAME, DbType.String, objEntity.Name); objDB.AddInParameter(sprocCmd, COLUMN_NAME_AGE, DbType.Int32, objEntity.Age); objDB.AddOutParameter(sprocCmd, COLUMN_NAME_RESULT, DbType.Int32, objEntity.Result); objDB.ExecuteNonQuery(sprocCmd); objEntity.Result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_RESULT)); } // } catch (Exception ex) { throw ex; } finally { } return objEntity; }
public ActionResult Create(StudentViewModel objEntity) { StudentRepository objStudentRepository = new StudentRepository(); if (ModelState.IsValid) { objEntity.Name = objEntity.Name.Trim(); objEntity = objStudentRepository.Insert(objEntity); if (objEntity.Result == ResultFlags.Success.GetHashCode()) { // Install-Package MvcFlashMessages this.Flash("success", "Student Insert successfully "); return RedirectToAction("Index"); } else if (objEntity.Result == ResultFlags.Failure.GetHashCode()) { this.Flash("error", "Faild to Insert Student"); return RedirectToAction("Index"); } else if (objEntity.Result == ResultFlags.Duplicate.GetHashCode()) { this.Flash("warning", "Student Name is Already Exist"); return RedirectToAction("Index"); } } return View(objEntity); }
public List<StudentViewModel> Select(int Flag, StudentViewModel objEntity) { var objEntityList = new List<StudentViewModel>(); try { Database objDB = base.GetDatabase(); // Create a suitable command type and add the required parameter. using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT_VIEWMODEL_SELECT)) { objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, Flag); objDB.AddInParameter(sprocCmd, COLUMN_NAME_ID, DbType.Int32, objEntity.Id); using (IDataReader reader = objDB.ExecuteReader(sprocCmd)) { while (reader.Read()) { var objEntityViewModel = new StudentViewModel(); objEntityViewModel.Id = reader.GetColumnValue<int>(COLUMN_NAME_ID); objEntityViewModel.Name = reader.GetColumnValue<string>(COLUMN_NAME_NAME); objEntityViewModel.Age = reader.GetColumnValue<int>(COLUMN_NAME_AGE); if (objEntityViewModel != null) { objEntityList.Add(objEntityViewModel); } } } } } catch (Exception ex) { throw ex; } finally { } return objEntityList; }
public List<StudentViewModel> Search(int flag, StudentViewModel entity, int pageIndex, int pageSize, out int totalCount) { totalCount = 0; var objEntityList = new List<StudentViewModel>(); try { Database objDB = base.GetDatabase(); // Create a suitable command type and add the required parameter. using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT_VIEWMODEL_SEARCH)) { objDB.AddInParameter(sprocCmd, COLUMN_NAME_PAGEINDEX, DbType.Int32, pageIndex); objDB.AddInParameter(sprocCmd, COLUMN_NAME_PAGESIZE, DbType.Int32, pageSize); objDB.AddOutParameter(sprocCmd, COLUMN_NAME_TOTALCOUNT, DbType.Int32, totalCount); using (IDataReader reader = objDB.ExecuteReader(sprocCmd)) { while (reader.Read()) { var objEntityViewModel = new StudentViewModel(); objEntityViewModel.Id = reader.GetColumnValue<int>(COLUMN_NAME_ID); objEntityViewModel.Name = reader.GetColumnValue<string>(COLUMN_NAME_NAME); objEntityViewModel.Age = reader.GetColumnValue<int>(COLUMN_NAME_AGE); if (objEntityViewModel != null) { objEntityList.Add(objEntityViewModel); } } } totalCount = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_TOTALCOUNT)); } } catch (Exception ex) { throw ex; } finally { } return objEntityList; }
public ActionResult Edit(int id, StudentViewModel objEntity) { var objStudentRepository = new StudentRepository(); if (ModelState.IsValid) { objEntity.Name = objEntity.Name.Trim(); objEntity.Id = id; objEntity = objStudentRepository.Edit(StudentFlags.UpdateByID.GetHashCode(), objEntity); if (objEntity.Result == ResultFlags.Success.GetHashCode()) { this.Flash("success", "Student Details updated successfully"); return RedirectToAction("Index"); } else if (objEntity.Result == ResultFlags.Failure.GetHashCode()) { this.Flash("error", "Student Details failed to Update"); } else if (objEntity.Result == ResultFlags.Duplicate.GetHashCode()) { this.Flash("warning", "Student Name is Already Exist"); } } return View(objEntity); }
public ActionResult Edit(int id) { var objStudentRepository = new StudentRepository(); var objEntity = new StudentViewModel(); objEntity = objStudentRepository.Select(StudentFlags.SelectByID.GetHashCode(), new StudentViewModel() { Id = id }).FirstOrDefault(); if (objEntity == null) { return RedirectToAction("Index"); } return View(objEntity); }