public int Delete(int Flag, Student2ViewModel objEntity)
{
int result = 0;
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT2_VIEWMODEL_DELETE))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, Flag);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_STUDENTID, DbType.Int32, objEntity.StudentId);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_STATUS, DbType.Int16, objEntity.Status);
objDB.AddOutParameter(sprocCmd, COLUMN_NAME_RESULT, DbType.Int32, result);
objDB.ExecuteNonQuery(sprocCmd);
result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_RESULT));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return result;
}
public ActionResult Report(string strFromDate, string strToDate, int filterId = 0)
{
Student2ViewModel objEntity = new Student2ViewModel();
var objStudent2Repository = new Student2Repository();
objEntity.Student2ReportList = new List<Student2ViewModel>();
if (string.IsNullOrEmpty(strFromDate))
{
objEntity.FromDate = null;
}
else
{
objEntity.strFromDate = strFromDate;
objEntity.FromDate = Convert.ToDateTime(strFromDate);
}
if (string.IsNullOrEmpty(strToDate))
{
objEntity.ToDate = null;
}
else
{
objEntity.strToDate = strToDate;
objEntity.ToDate = Convert.ToDateTime(strToDate);
}
objEntity.CourseId = filterId;
objEntity.filterId = filterId;
#region DatabaseDropdown
var objCourseRepository = new CourseRepository();
var objCourseViewModelEntity = objCourseRepository.Select(CourseFlags.SelectAll.GetHashCode(), new CourseViewModel());
objEntity.CourseList = new SelectList(objCourseViewModelEntity.Select(model => new { model.CourseId, model.CourseTitle }), "CourseId", "CourseTitle");
#endregion
if (objEntity.FromDate.HasValue && objEntity.ToDate.HasValue && objEntity.FromDate > objEntity.ToDate)
{
this.Flash("Warning", "From Date is smaller than To Date.");
return View(objEntity);
}
objEntity.Student2ReportList = objStudent2Repository.Report(StudentFlags.SelectAllByReport.GetHashCode(), objEntity);
if (objEntity.Student2ReportList.Count == 0 && (!string.IsNullOrEmpty(strFromDate) || !string.IsNullOrEmpty(strToDate) || filterId > 0))
{
this.Flash("Warning", "No matching records found.");
}
return View(objEntity);
}
public ActionResult Details(int id)
{
Student2Repository objStudent2Repository = new Student2Repository();
Student2ViewModel objEntity = new Student2ViewModel();
objEntity = objStudent2Repository.Select(StudentFlags.SelectByID.GetHashCode(), new Student2ViewModel()
{
StudentId = id
}).FirstOrDefault();
if (objEntity == null)
{
return RedirectToAction("Index");
}
return View(objEntity);
}
public Student2ViewModel Insert(Student2ViewModel objEntity)
{
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT2_VIEWMODEL_INSERT))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_NAME, DbType.String, objEntity.Name);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_GENDER, DbType.Int16, objEntity.Gender);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_CURRENTDATE, DbType.DateTime, objEntity.CurrentDate);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_CURRENTTIME, DbType.DateTime, objEntity.CurrentTime);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_CURRENTDATETIME, DbType.DateTime, objEntity.CurrentDateTime);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_CHECKBOX, DbType.Boolean, objEntity.Checkbox);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_RADIOBUTTON, DbType.Int16, objEntity.RadioButton);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FILENAME, DbType.String, objEntity.FileName);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_STATEID, DbType.Int32, objEntity.StateId);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_COURSEID, DbType.Int32, objEntity.CourseId);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_STATUS, DbType.Int32, objEntity.Status);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_CREATEDBY, DbType.Int32, objEntity.CreatedBy);
objDB.AddOutParameter(sprocCmd, COLUMN_NAME_STUDENTID, DbType.Int32, objEntity.StudentId);
objDB.AddOutParameter(sprocCmd, COLUMN_NAME_RESULT, DbType.Int32, objEntity.Result);
objDB.ExecuteNonQuery(sprocCmd);
objEntity.StudentId = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_STUDENTID));
objEntity.Result = Convert.ToInt32(objDB.GetParameterValue(sprocCmd, COLUMN_NAME_RESULT));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntity;
}
// GET: Student2
public ActionResult Create()
{
Student2ViewModel objEntity = new Student2ViewModel();
#region DatabaseDropdown
var objCourseRepository = new CourseRepository();
var objCourseViewModelEntity = objCourseRepository.Select(CourseFlags.SelectAll.GetHashCode(), new CourseViewModel());
objEntity.CourseList = new SelectList(objCourseViewModelEntity.Select(model => new { model.CourseId, model.CourseTitle }), "CourseId", "CourseTitle");
#endregion
#region DatabaseOptionGroup
CountryStateRepository objCountryStateRepository = new CountryStateRepository();
var objCountryStateEntityList = objCountryStateRepository.Select(CountryStateFlags.SelectAllForOptionGroup.GetHashCode(), new CountryStateViewModel());
objEntity.SelectCountryList = new SelectList(objCountryStateEntityList, "StateId", "StateName", "CountryName", 1);
#endregion
objEntity.CurrentDate = DateTime.Now;
objEntity.CurrentDateTime = DateTime.Now;
return View(objEntity);
}
// GET: Student3
public ActionResult Search(string Keyword)
{
if (!string.IsNullOrWhiteSpace(Keyword) || !string.IsNullOrEmpty(Keyword))
{
Keyword = Keyword.Trim();
}
var objEntity = new Student2ViewModel()
{
Keyword = Keyword
};
var objStudent2Repository = new Student2Repository();
// objEntity.Student2SearchList = new List<Student2ViewModel>();
objEntity.Student2SearchList = objStudent2Repository.Search(StudentFlags.SelectAllByKeyword.GetHashCode(), objEntity);
if (objEntity.Student2SearchList.Count >= 0 && !string.IsNullOrWhiteSpace(Keyword))
{
this.Flash("Success", string.Format("Your search for '{0}' returns {1} result(s).", Keyword, objEntity.Student2SearchList.Count().ToString()));
}
else if (objEntity.Student2SearchList.Count == 0)
{
this.Flash("Warning", string.Format(@"Your search returns {0} result(s)", 0));
//flash message
}
return View(objEntity);
}
public ActionResult Create(Student2ViewModel objEntity)
{
Student2Repository objStudent2Repository = new Student2Repository();
CountryStateRepository objCountryStateRepository = new CountryStateRepository();
string fileName = string.Empty;
if (ModelState.IsValid)
{
objEntity.Status = StatusEnum.Active;
objEntity.CreatedBy = 1;//admin userid
#region FileUpload
if (objEntity.UploadFile != null)
{
fileName = Guid.NewGuid().ToString() + Path.GetExtension(objEntity.UploadFile.FileName);
objEntity.FileName = fileName;
}
else
{
objEntity.FileName = string.Empty;
}
#endregion
objEntity = objStudent2Repository.Insert(objEntity);
if (objEntity.Result == ResultFlags.Success.GetHashCode())
{
#region FileUpload
//file name
if (objEntity.UploadFile != null)
{
string path = Path.Combine(Server.MapPath(ApplicationConstant.UPLOADED_STUDENT_IMAGE_PATH), fileName);
// WebImage.Save()
objEntity.UploadFile.SaveAs(path);
}
#endregion
// 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");
}
}
#region DatabaseDropdown
var objCourseRepository = new CourseRepository();
var objCourseViewModelEntity = objCourseRepository.Select(CourseFlags.SelectAll.GetHashCode(), new CourseViewModel());
objEntity.CourseList = new SelectList(objCourseViewModelEntity.Select(model => new { model.CourseId, model.CourseTitle }), "CourseId", "CourseTitle");
#endregion
#region DatabaseOptionGroup
var objCountryStateEntityList = objCountryStateRepository.Select(CountryStateFlags.SelectAllForOptionGroup.GetHashCode(), new CountryStateViewModel());
objEntity.SelectCountryList = new SelectList(objCountryStateEntityList, "StateId", "StateName", "CountryName", 1);
#endregion
return View(objEntity);
}
public ActionResult Edit(int id, Student2ViewModel objEntity)
{
Student2Repository objStudent2Repository = new Student2Repository();
CountryStateRepository objCountryStateRepository = new CountryStateRepository();
string fileName = string.Empty;
string oldFileName = string.Empty;
if (ModelState.IsValid)
{
objEntity.Name = objEntity.Name.Trim();
objEntity.StudentId = id;
oldFileName = objEntity.FileName;
#region FileUpload
if (objEntity.UploadFile != null)
{
fileName = Guid.NewGuid().ToString() + Path.GetExtension(objEntity.UploadFile.FileName);
objEntity.FileName = fileName;
}
#endregion
objEntity = objStudent2Repository.Update(StudentFlags.UpdateByID.GetHashCode(), objEntity);
if (objEntity.Result == ResultFlags.Success.GetHashCode())
{
#region FileUpload
//delete old file
//file name
if (objEntity.UploadFile != null)
{
if (!string.IsNullOrEmpty(objEntity.UploadFile.FileName))
{
ApplicationHelpers.DeleteFile(Path.Combine(Server.MapPath(ApplicationConstant.UPLOADED_STUDENT_IMAGE_PATH), oldFileName));
}
string path = Path.Combine(Server.MapPath(ApplicationConstant.UPLOADED_STUDENT_IMAGE_PATH), fileName);
// WebImage.Save()
objEntity.UploadFile.SaveAs(path);
}
#endregion
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");
}
}
#region DatabaseDropdown
var objCourseRepository = new CourseRepository();
var objCourseViewModelEntity = objCourseRepository.Select(CourseFlags.SelectAll.GetHashCode(), new CourseViewModel());
objEntity.CourseList = new SelectList(objCourseViewModelEntity.Select(model => new { model.CourseId, model.CourseTitle }), "CourseId", "CourseTitle");
#endregion
#region DatabaseOptionGroup
var objCountryStateEntityList = objCountryStateRepository.Select(CountryStateFlags.SelectAllForOptionGroup.GetHashCode(), new CountryStateViewModel());
objEntity.SelectCountryList = new SelectList(objCountryStateEntityList, "StateId", "StateName", "CountryName", 1);
#endregion
return View(objEntity);
}
public ActionResult Edit(int id)
{
Student2Repository objStudent2Repository = new Student2Repository();
Student2ViewModel objEntity = new Student2ViewModel();
CountryStateRepository objCountryStateRepository = new CountryStateRepository();
objEntity = objStudent2Repository.Select(StudentFlags.SelectByID.GetHashCode(), new Student2ViewModel()
{
StudentId = id
}).FirstOrDefault();
if (objEntity == null)
{
return RedirectToAction("Index");
}
objEntity.CurrentTimeValue = objEntity.CurrentTime.HasValue ? objEntity.CurrentTime.Value.ToString("hh:mm tt") : string.Empty;
#region DatabaseDropdown
var objCourseRepository = new CourseRepository();
var objCourseViewModelEntity = objCourseRepository.Select(CourseFlags.SelectAll.GetHashCode(), new CourseViewModel());
objEntity.CourseList = new SelectList(objCourseViewModelEntity.Select(model => new { model.CourseId, model.CourseTitle }), "CourseId", "CourseTitle");
#endregion
#region DatabaseOptionGroup
var objCountryStateEntityList = objCountryStateRepository.Select(CountryStateFlags.SelectAllForOptionGroup.GetHashCode(), new CountryStateViewModel());
objEntity.SelectCountryList = new SelectList(objCountryStateEntityList, "StateId", "StateName", "CountryName", 1);
#endregion
return View(objEntity);
}
public ActionResult Delete(int id)
{
int result = 0;
Student2Repository objStudent2Repository = new Student2Repository();
Student2ViewModel objEntity = new Student2ViewModel();
CountryStateRepository objCountryStateRepository = new CountryStateRepository();
objEntity = objStudent2Repository.Select(StudentFlags.SelectByID.GetHashCode(), new Student2ViewModel()
{
StudentId = id
}).FirstOrDefault();
if (objEntity == null)
{
//delete old file
ApplicationHelpers.DeleteFile(Path.Combine(Server.MapPath(ApplicationConstant.UPLOADED_STUDENT_IMAGE_PATH), objEntity.FileName));
}
result = objStudent2Repository.Delete(StudentFlags.DeleteByID.GetHashCode(), new Student2ViewModel()
{
StudentId = id,
});
if (result == ResultFlags.Success.GetHashCode())
{
this.Flash("success", "Student Delete successfully");
return RedirectToAction("Index");
}
else if (result == ResultFlags.Failure.GetHashCode())
{
this.Flash("error", "Faild to Delete Student");
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
public List<Student2ViewModel> Select(int Flag, Student2ViewModel objEntity)
{
var objEntityList = new List<Student2ViewModel>();
try
{
Database objDB = base.GetDatabase();
// Create a suitable command type and add the required parameter.
using (DbCommand sprocCmd = objDB.GetStoredProcCommand(SPS_STUDENT2_VIEWMODEL_SELECT))
{
objDB.AddInParameter(sprocCmd, COLUMN_NAME_FLAG, DbType.Int32, Flag);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_STUDENTID, DbType.Int32, objEntity.StudentId);
objDB.AddInParameter(sprocCmd, COLUMN_NAME_CREATEDBY, DbType.Int32, objEntity.CreatedBy);
using (IDataReader reader = objDB.ExecuteReader(sprocCmd))
{
while (reader.Read())
{
var objEntityViewModel = new Student2ViewModel();
objEntityViewModel.StudentId = reader.GetColumnValue<int>(COLUMN_NAME_STUDENTID);
objEntityViewModel.Name = reader.GetColumnValue<string>(COLUMN_NAME_NAME);
objEntityViewModel.Gender = (GenderEnum)reader.GetColumnValue<Int16>(COLUMN_NAME_GENDER);
objEntityViewModel.CurrentDate = reader.GetColumnValue<DateTime>(COLUMN_NAME_CURRENTDATE);
objEntityViewModel.CurrentTime = reader.GetColumnValue<DateTime>(COLUMN_NAME_CURRENTTIME);
objEntityViewModel.CurrentDateTime = reader.GetColumnValue<DateTime>(COLUMN_NAME_CURRENTDATETIME);
objEntityViewModel.Checkbox = reader.GetColumnValue<bool>(COLUMN_NAME_CHECKBOX);
objEntityViewModel.RadioButton = reader.GetColumnValue<Int16>(COLUMN_NAME_RADIOBUTTON);
objEntityViewModel.FileName = reader.GetColumnValue<String>(COLUMN_NAME_FILENAME);
objEntityViewModel.StateId = reader.GetColumnValue<Int32>(COLUMN_NAME_STATEID);
objEntityViewModel.CountryId = reader.GetColumnValue<Int32>(COLUMN_NAME_COUNTRYID);
objEntityViewModel.StateName = reader.GetColumnValue<String>(COLUMN_NAME_STATENAME);
objEntityViewModel.CountryName = reader.GetColumnValue<String>(COLUMN_NAME_COUNTRYNAME);
objEntityViewModel.CourseId = reader.GetColumnValue<int>(COLUMN_NAME_COURSEID);
objEntityViewModel.CourseTitle = reader.GetColumnValue<string>(COLUMN_NAME_COURSETITLE);
objEntityViewModel.Status = (StatusEnum)reader.GetColumnValue<Int16>(COLUMN_NAME_STATUS);
objEntityViewModel.CreatedBy = reader.GetColumnValue<Int32>(COLUMN_NAME_CREATEDBY);
objEntityViewModel.CreatedDate = reader.GetColumnValue<DateTime>(COLUMN_NAME_CREATEDDATE);
if (objEntityViewModel != null)
{
objEntityList.Add(objEntityViewModel);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return objEntityList;
}
