// Get All Occupation By ID
public OccupationModel GetOccupationById(int id)
{
// Declare list to work with
OccupationModel occupation = new OccupationModel();
// Establish database connection
SqlConnection con = new SqlConnection(connectionString);
con.Open();
// sql command get occupation by provided id
SqlCommand cmd = new SqlCommand("select * from Occupation where OccupationId = " + id, con);
// This read database command
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read() == true)
{
occupation.OccupationId = reader.GetInt32(0);
occupation.Description = reader.GetString(1);
}
// Close current connection to the database
con.Close();
return(occupation);
}
// Get All Occupations
public List <OccupationModel> GetAllOccupations()
{
// Declare list to work with
List <OccupationModel> occupationsList = new List <OccupationModel>();
// Establish database connection
SqlConnection con = new SqlConnection(connectionString);
con.Open();
// sql command for Occupation
SqlCommand cmd = new SqlCommand("select * from Occupation order by Description", con);
// This read database command
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
// create new occupation instance
OccupationModel occupations = new OccupationModel
{
OccupationId = reader.GetInt32(0),
Description = reader.GetString(1)
};
// add all occupation to the list
occupationsList.Add(occupations);
}
// Close current connection to the database
con.Close();
return(occupationsList);
}
public ActionResult CreateOccupation(OccupationModel ObjOccupation)
{
var resultDto = new ResultDto();
if (ModelState.IsValid)
{
var occupationDto = Mapper.Map <OccupationModel, OccupationDto>(ObjOccupation);
occupationDto.UserId = UserInfo.UserID;
if (occupationDto.OccupationID == 0)
{
resultDto = _OccupationService.Insert(occupationDto);
}
else
{
resultDto = _OccupationService.Update(occupationDto);
}
if (resultDto.ObjectId > 0)
{
occupationDto = _OccupationService.GetByID(resultDto.ObjectId);
ObjOccupation = Mapper.Map <OccupationDto, OccupationModel>(occupationDto);
resultDto.ObjectCode = occupationDto.OccupationCode;
}
}
SelectList occupationCategory = GetDropDownListByMasterCode(Enums.RefMasterCodes.OCCUPATION_TYPE);
ViewBag.OccupationCategory = occupationCategory;
ViewBag.Result = resultDto;
return(View(ObjOccupation));
}
public ActionResult OccupationView(int iets = 0)
{
string dateInput = Request.Form["date1"];
DateTime beginDate = new DateTime(00 - 00 - 0000);
DateTime endDate = new DateTime(00 - 00 - 0000);
if (dateInput.Equals("") == false)
{
beginDate = DateTime.ParseExact(dateInput, "yyyy/MM/dd", provider);
}
string dateInput2 = Request.Form["date2"];
if (dateInput2.Equals("") == false)
{
endDate = DateTime.ParseExact(dateInput2, "yyyy/MM/dd", provider);
}
OccupationModel model = new OccupationModel();
model.movies = ChairRepo.Chairs.Where(c => c.ScheduleID.Date >= beginDate && c.ScheduleID.Date <= endDate && c.Reservation == 2).OrderBy(c => c.ScheduleID.movie.Name).GroupBy(c => c.ScheduleID.movie.Name).Select(c => c.Key).ToList();
model.countMovie = ChairRepo.Chairs.Where(c => c.ScheduleID.Date >= beginDate && c.ScheduleID.Date <= endDate && c.Reservation == 2).OrderBy(c => c.ScheduleID.movie.Name).GroupBy(c => c.ScheduleID.movie.Name).Select(c => c.Count()).ToList();
model.halls = ChairRepo.Chairs.Where(c => c.ScheduleID.Date >= beginDate && c.ScheduleID.Date <= endDate && c.Reservation == 2).OrderBy(c => c.ScheduleID.hall.Name).GroupBy(c => c.ScheduleID.hall.Name).Select(c => c.Key).ToList();
model.countHall = ChairRepo.Chairs.Where(c => c.ScheduleID.Date >= beginDate && c.ScheduleID.Date <= endDate && c.Reservation == 2).OrderBy(c => c.ScheduleID.hall.Name).GroupBy(c => c.ScheduleID.hall.Name).Select(c => c.Count()).ToList();
return(View("OccupationResults", model));
}
public ActionResult CreateOccupation(string ID)
{
//SelectList occupationCategory = GetDropDownListByMasterCode(Enums.RefMasterCodes.OCCUPATION_TYPE);
int occupationId = string.IsNullOrEmpty(ID.DecryptString()) ? default(int) : Convert.ToInt32(ID.DecryptString());
SelectList occupationCategory = GetDropDownListByMasterCode(Enums.RefMasterCodes.OCCUPATION_TYPE);
ViewBag.OccupationCategory = occupationCategory;
OccupationDto occupationDto = new OccupationDto();
if (occupationId > 0)
{
occupationDto = _OccupationService.GetByID(occupationId);
}
OccupationModel occupationmodel = Mapper.Map <OccupationDto, OccupationModel>(occupationDto);
ViewBag.Result = new ResultDto();
return(View(occupationmodel));
//OccupationModel occupationModel = new OccupationModel();
//if (ID.HasValue)
//{
// occupationDto = _OccupationService.GetByID(ID.Value);
// occupationModel = Mapper.Map<OccupationDto, OccupationModel>(occupationDto);
// //}
// if (occupationId>0)
// occupationDto= _OccupationService.GetByID(occupationId);
// ViewBag.Result = new ResultDto();
//// SelectList occupationCategory = GetDropDownListByMasterCode(Enums.RefMasterCodes.OCCUPATION_TYPE);
// ViewBag.OccupationCategory = occupationCategory;
// return View(occupationmodel);
}
public OccupationViewModel(OccupationModel model)
{
this.model = model;
this.model.PropertyChanged += new PropertyChangedEventHandler(model_PropertyChanged);
}
