public ActionResult DeleteFeeRecords(IEnumerable <string> deletefee, string delFee, string hiddenInput)
{
if (deletefee != null && hiddenInput != "")
{
if (delFee != null)
{
string result = EmployeesModel.DeleteFeeRecordsOfStudents(deletefee);
if (result == "OK")
{
return(RedirectToAction("FeeRecords", "Fee", new { res = SherlockHolmesEncryptDecrypt.Encrypt("Successfully Records Deleted!") }));
}
else
{
return(RedirectToAction("FeeRecords", "Fee", new { res = SherlockHolmesEncryptDecrypt.Encrypt(result) }));
}
}
else
{
return(RedirectToAction("FeeRecords", "Fee"));
}
}
else
{
return(RedirectToAction("FeeRecords", "Fee", new { res = SherlockHolmesEncryptDecrypt.Encrypt("Plz Select Records To Delete!") }));
}
}
public ActionResult Edit(int id)
{
List <EmployeesModel> allEmployees = unitofWork.employeeRepository.GetEmployees();
EmployeesModel employeemodeldet = allEmployees.SingleOrDefault(x => x.ID == id);
return(View(employeemodeldet));
}
public bool Update(EmployeesModel employee)
{
if (employee == null)
{
return(false);
}
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"UPDATE {EmployeesTable} " +
$"SET FirstName = '{employee.FirstName}', " +
$"MiddleName = '{employee.MiddleName}', " +
$"LastName = '{employee.LastName}', " +
$"Email = '{employee.Email}' , " +
$"Team_Id = {employee.Team_Id}" +
$" WHERE {EmployeesTable}.Id = {employee.Id}";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit(int id, FormCollection frmcollection)
{
if (ModelState.IsValid)
{
EmployeeRepository EmployeeRepository = new EmployeeRepository();
List <EmployeesModel> allstudents = EmployeeRepository.GetEmployees();
EmployeesModel studentmodeledit = allstudents.FirstOrDefault(x => x.ID == id);
studentmodeledit.ID = id;
studentmodeledit.First_Name = frmcollection["First_Name"].ToString();
studentmodeledit.Last_Name = frmcollection["Last_Name"].ToString();
studentmodeledit.Email = frmcollection["Email"].ToString();
studentmodeledit.Dob = Convert.ToDateTime(frmcollection["Dob"].ToString());
studentmodeledit.Gender = frmcollection["Gender"].ToString();
studentmodeledit.Address = frmcollection["Address"].ToString();
studentmodeledit.City = frmcollection["City"].ToString();
studentmodeledit.State = frmcollection["State"].ToString();
studentmodeledit.Pin = frmcollection["Pin"].ToString();
EmployeeRepository.EditEmployeesModel(studentmodeledit);
return(RedirectToAction("Index"));
}
return(View());
}
public IActionResult SaveEmployee([FromBody] EmployeesModel model)
{
var msg = new Message <EmployeesModel>();
var data = DbClientFactory <EmployeeDbClient> .Instance.SaveEmployee(model, appSettings.Value.DbConn);
if (data == "C200")
{
msg.IsSuccess = true;
if (model.Id == 0)
{
msg.ReturnMessage = "Employee saved successfully";
}
else
{
msg.ReturnMessage = "Employee updated successfully";
}
}
else if (data == "C201")
{
msg.IsSuccess = false;
msg.ReturnMessage = "Email Id already exists";
}
else if (data == "C202")
{
msg.IsSuccess = false;
msg.ReturnMessage = "Mobile Number already exists";
}
return(Ok(msg));
}
public async Task <IActionResult> GetCustomerDay(string EmpSearch, EmployeesModel employeesModel)
{
var userId = this.User.FindFirstValue(ClaimTypes.NameIdentifier);
employeesModel = _context.Employees.Where(e => e.IdentityUserId == userId).SingleOrDefault();
DateTime dateTime = DateTime.Now;
var date = dateTime.ToString("dddd");
ViewData["GetCustomerDay"] = EmpSearch;
try
{
var empquery = _context.Customers.Where(c => c.ZipCode == employeesModel.ZipCode && c.SuspendService != true || c.OneTimeDate == dateTime).ToList();
empquery.RemoveAll(d => d.SuspendStart <= dateTime || d.SuspendEnd >= dateTime);
if (!String.IsNullOrEmpty(EmpSearch))
{
EmpSearch = DayOfWeekFormatter.FormatDay(EmpSearch);
empquery = empquery.Where(x => x.PickUpDay.Contains(EmpSearch)).ToList();
}
return(View(empquery));
}
catch
{
return(View("Index"));
}
}
public ActionResult Create(EmployeesModel model)
{
try
{
if (ModelState.IsValid)
{
Employees employees = new Employees()
{
Name = model.Name,
Email = model.Email,
PhoneNumber = model.PhoneNumber,
Created = DateTime.Now,
CreatedBy = "system",
RecordActive = true,
RecordDeleted = false,
RecordOrder = 0
};
var response = _employeesServices.AddNewEmployees(employees);
if (response)
{
return(RedirectToAction("Index"));
}
}
// TODO: Add insert logic here
}
catch
{
}
return(View(model));
}
public async Task <ActionResult <EmployeesModel> > PostEmployeesModel(EmployeesModel employeesModel)
{
_context.AssignedEmployee.Add(employeesModel);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEmployeesModel", new { id = employeesModel.EmployeeId }, employeesModel));
}
public static int SaveEmployee(EmployeesModel model)
{
string sql = @"Update dbo.Employees set FirstName = @FirstName, LastName = @LastName, Salary = @Salary, IsCEO = @IsCEO, IsManager = @IsManager,
ManagerId = @ManagerId where Id = @Id;" ;
return(SqlDataAccess.SaveData(sql, model));
}
public ActionResult WelcomeAdmin()
{
EmployeesModel empModel = new EmployeesModel();
string[] mainScreenItems = empModel.WelcomeEmployeesScreenResults();
if (mainScreenItems.Length > 0)
{
ViewBag.DegreePrograms = mainScreenItems[0];
//mainScreenItems.RemoveAt(0);
ViewBag.Subjects = mainScreenItems[1];
//mainScreenItems.RemoveAt(0);
ViewBag.Students = mainScreenItems[2];
//mainScreenItems.RemoveAt(0);
ViewBag.Teachers = mainScreenItems[3];
//mainScreenItems.RemoveAt(0);
}
Guid AdminID = Guid.Parse(Session["AdminID"].ToString());
var getLoggedInAdminPicture = rc.Admins.Where(s => s.ID == AdminID).Select(s => s).FirstOrDefault();
Session["Picture"] = getLoggedInAdminPicture.Picture;
ViewBag.Data = StatisticsForAdmins();
return(View());
}
public async Task <IActionResult> PutEmployeesModel(long id, EmployeesModel employeesModel)
{
if (id != employeesModel.EmployeeId)
{
return(BadRequest());
}
_context.Entry(employeesModel).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeesModelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public HomeControllerTest()
{
employee1 = new EmployeesModel {
ID = 1, First_Name = "Sweety", Last_Name = "Sharma", Email = "*****@*****.**", Dob = Convert.ToDateTime("12/12/1973"), Gender = "Female", Address = "New Link Road", City = "Saran", State = "MHS", Pin = "1231"
};
employee2 = new EmployeesModel {
ID = 2, First_Name = "Jatin", Last_Name = "Kumar", Email = "*****@*****.**", Dob = Convert.ToDateTime("12/12/1972"), Gender = "Male", Address = "New Link Road", City = "Saran", State = "MHS", Pin = "1231"
};
employee3 = new EmployeesModel {
ID = 3, First_Name = "Sweta", Last_Name = "shah", Email = "*****@*****.**", Dob = Convert.ToDateTime("12/12/1971"), Gender = "Female", Address = "New Link Road", City = "Saran", State = "MHS", Pin = "1231"
};
employee4 = new EmployeesModel {
ID = 4, First_Name = "yasmin", Last_Name = "Sheikh", Email = "*****@*****.**", Dob = Convert.ToDateTime("12/12/1978"), Gender = "Female", Address = "New Link Road", City = "Saran", State = "MHS", Pin = "1231"
};
employee5 = new EmployeesModel {
ID = 5, First_Name = "weetetar", Last_Name = "Rao", Email = "*****@*****.**", Dob = Convert.ToDateTime("12/12/1975"), Gender = "Male", Address = "New Link Road", City = "Saran", State = "MHS", Pin = "1231"
};
employeeModelList = new List <EmployeesModel>
{
employee1,
employee2,
employee3,
employee4
};
employeeRepository = new DummyEmployeeRepository(employeeModelList);
unitofwork = new unitofwork(employeeRepository);
controller = new EmployeeController(unitofwork);
}
public ActionResult CreateEmploye(EmployeesModel empModel)
{
EmployesRepositery empRp = new EmployesRepositery();
Employees emp = new Employees();
if (!ModelState.IsValidField("FirstName") || !ModelState.IsValidField("LastName") ||
!ModelState.IsValidField("Email") || !ModelState.IsValidField("Telephone"))
{
empModel.AspNetUsersList = empRp.getAllUsers().ToList();
empModel.polesList = empRp.getAllPoles().ToList();
return(View("EmployesFormulaire", empModel));
}
emp.Employee_ID = Guid.NewGuid();
String userUmail = Convert.ToString(Request.Form["userList"]);
emp.User_ID = empRp.getUserByMail(userUmail);
if (empRp.getAllPoles().ToList().Count() == 0)
{
emp.Pole_ID = null;
}
else
{
emp.Pole_ID = new Guid(Convert.ToString(Request.Form["poleList"]));
}
emp.FirstName = Convert.ToString(Request.Form["FirstName"]);
emp.LastName = Convert.ToString(Request.Form["LastName"]);
emp.Email = Convert.ToString(Request.Form["Email"]);
emp.Telephone = Convert.ToString(Request.Form["Telephone"]);
empRp.AddEmployes(emp);
return(RedirectToAction("AllEmployees"));
}
public ActionResult Searche(int?pageIndex, String query)
{
var countElementPage = 10;
EmployesRepositery empRp = new EmployesRepositery();
AspNetUsers user = new AspNetUsers();
PolesModel pole = new PolesModel();
var employers = empRp.getSerachingemployees(query);
List <EmployeesModel> employersModel = new List <EmployeesModel>();
foreach (var emp in employers)
{
var polId = emp.Pole_ID != null ? emp.Pole_ID : null;
EmployeesModel empModel = new EmployeesModel();
empModel.Email = emp.Email;
empModel.Employee_ID = emp.Employee_ID;
empModel.FirstName = emp.FirstName;
empModel.LastName = emp.LastName;
empModel.Telephone = emp.Telephone;
empModel.User_ID = emp.User_ID;
empModel.Pole_ID = emp.Pole_ID;
empModel.AspNetUsers = empRp.getUserById(emp.User_ID);
empModel.Poles.Name = empRp.getPoleById(emp.Pole_ID).Name;
employersModel.Add(empModel);
}
IQueryable <EmployeesModel> listEmp = employersModel.AsQueryable();
PaginatedList <EmployeesModel> lst = new PaginatedList <EmployeesModel>(listEmp, pageIndex, countElementPage);
return(View("Allmployes", lst));
}
public List <EmployeesModel> GetEmployeeList()
{
IList <EmployeesModel> getEmpList = new List <EmployeesModel>();
_ds = new DataSet();
using (SqlConnection con = new SqlConnection(connection))
{
con.Open();
SqlCommand cmd = new SqlCommand("EmployeeViewOrInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mode", "GetEmpList");
_adapter = new SqlDataAdapter(cmd);
_adapter.Fill(_ds);
if (_ds.Tables.Count > 0)
{
for (int i = 0; i < _ds.Tables[0].Rows.Count; i++)
{
EmployeesModel obj = new EmployeesModel();
obj.Id = Convert.ToInt32(_ds.Tables[0].Rows[i]["Id"]);
obj.EmpName = Convert.ToString(_ds.Tables[0].Rows[i]["EmpName"]);
obj.EmpAge = Convert.ToString(_ds.Tables[0].Rows[i]["EmpAge"]);
obj.EmailId = Convert.ToString(_ds.Tables[0].Rows[i]["EmailId"]);
obj.MobileNo = Convert.ToString(_ds.Tables[0].Rows[i]["MobileNo"]);
getEmpList.Add(obj);
}
}
}
return((List <EmployeesModel>)getEmpList);
}
public ActionResult EditEmployees(Guid EmpID, Employee em, HttpPostedFileBase file
, Nullable <System.DateTime> date1)
{
var getEMP = r.Employees.Where(s => s.EmpID == EmpID).Select(s => s).FirstOrDefault();
if (em != null)
{
if (EmployeesModel.UpdateEmployeeRecord(EmpID, em, file, date1))
{
ViewBag.Message = "Successfully Updated Record";
ViewBag.Message2 = "";
return(View(getEMP));
}
else
{
ViewBag.Message = "No Changes were Made to Update the Record";
return(View(getEMP));
}
}
else
{
ViewBag.Message = "No Changes were Made to Update the Record";
return(View(getEMP));
}
}
public EmployeesModel GetEditById(int Id)
{
EmployeesModel model = new EmployeesModel();
using (SqlConnection con = new SqlConnection(connection))
{
con.Open();
SqlCommand cmd = new SqlCommand("EmployeeViewOrInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mode", "GetEmployeeById");
cmd.Parameters.AddWithValue("@EmpId", Id);
_adapter = new SqlDataAdapter(cmd);
_ds = new DataSet();
_adapter.Fill(_ds);
if (_ds.Tables.Count > 0 && _ds.Tables[0].Rows.Count > 0)
{
model.Id = Convert.ToInt32(_ds.Tables[0].Rows[0]["Id"]);
model.EmpName = Convert.ToString(_ds.Tables[0].Rows[0]["EmpName"]);
model.EmpAge = Convert.ToString(_ds.Tables[0].Rows[0]["EmpAge"]);
model.EmailId = Convert.ToString(_ds.Tables[0].Rows[0]["EmailId"]);
model.MobileNo = Convert.ToString(_ds.Tables[0].Rows[0]["MobileNo"]);
}
}
return(model);
}
public ActionResult StudentRecords(string search, int StudentType, int?page)
{
bool checker = false;
IEnumerable <Registeration> DataBasedOnRollnos = EmployeesModel.GetAllStudentRecords();
foreach (var item in DataBasedOnRollnos)
{
if (item.Rollno.StartsWith(search))
{
checker = true;
break;
}
}
if (checker)
{
ViewBag.SearchQuery = "True";
IEnumerable <Registeration> SearchedData = EmployeesModel.getSpecificSearchRecord(search, StudentType);
return(View(SearchedData.ToPagedList(page ?? 1, 10)));
}
else
{
ViewBag.SearchQuery = "Roll no Doesnot Exists";
return(View());
}
}
public ActionResult Index(EmployeesModel model)
{
Employee employee = (Employee)System.Web.HttpContext.Current.Session["_SessionUser"];
if (employee == null)
{
return(RedirectToAction("Index", "Login"));
}
ViewBag.Nombre = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(string.Format("{0} {1} {2}", employee.FirstName.ToLower(), employee.LastName.ToLower(), employee.MiddleName.ToLower()));
ViewBag.EmailUser = employee.CompanyEmail;
ViewBag.ImageUser = employee.GoogleImage;
ViewBag.AccessGroup = employee.AreaName;
ViewBag.Rol = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(employee.PositionName.ToLower());
ViewBag.EnumRol = employee.Rol;
EmployeeService employeeService = new EmployeeService(model);
model.Rol = employee.Rol;
model.EmployeeIdConected = Convert.ToInt32(employee.EmployeeId);
model.LstEmployees = employeeService.GetAllEmployees();
TempData["PageCount"] = model.PageCount;
TempData["RecordCount"] = model.RecordCount;
TempData["CurrentPageIndex"] = model.CurrentPageIndex;
return(View(model));
}
public ActionResult TeacherRecords(string search, int?page, IEnumerable <string> deleteTeacher, string TeacherType)
{
bool checker = false;
IEnumerable <Teacher> DataBasedOnRollnos = EmployeesModel.GetAllTeacherRecords();
foreach (var item in DataBasedOnRollnos)
{
if (item.TeacherID.StartsWith(search))
{
checker = true;
break;
}
}
if (checker)
{
ViewBag.SearchQuery = "True";
IEnumerable <Teacher> SearchedData = EmployeesModel.getSpecificSearchRecordForTeacher(search, TeacherType);
return(View(SearchedData.ToPagedList(page ?? 1, 10)));
}
else
{
ViewBag.SearchQuery = "ID no Doesnot Exists";
return(View());
}
}
public ActionResult Create(FormCollection collection)
{
try
{
// TODO: Add insert logic here
EmployeesModel studentmodel = new EmployeesModel();
studentmodel.First_Name = collection["First_Name"].ToString();
studentmodel.Last_Name = collection["Last_Name"].ToString();
studentmodel.Email = collection["Email"].ToString();
studentmodel.Dob = Convert.ToDateTime(collection["Dob"].ToString());
studentmodel.Gender = collection["Gender"].ToString();
studentmodel.Address = collection["Address"].ToString();
studentmodel.City = collection["City"].ToString();
studentmodel.State = collection["State"].ToString();
studentmodel.Pin = collection["Pin"].ToString();
EmployeeRepository EmployeeRepository = new EmployeeRepository();
EmployeeRepository.InsertEmployeesModel(studentmodel);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult TeacherAttendance(int?page, string search, string month, string year)
{
if (search == null || search == "")
{
ViewBag.Message = "Plz Enter Teacher ID to Search Records";
return(View("TeacherAttendance", null));
}
else
{
IEnumerable <Teacher_Attendance> EndResultListOfMarks = EmployeesModel.showResultsTeacherAttendance_EmployeeModelFunction(search, month, year);
if (EndResultListOfMarks != null)
{
TempData["T_ID"] = "Teacher ID: " + search + ", Total Lectures: "
+ EndResultListOfMarks.Count() + ", Attended Lectures:" + EndResultListOfMarks.Where(s => s.Present.StartsWith("Y")).Select(s => s).Count() +
@", Month: " + month + ", Year: " + year;
return(View("TeacherAttendance", EndResultListOfMarks.OrderBy(s => s.TeacherID).Take(50).ToPagedList(page ?? 1, 10)));
}
else
{
TempData["T_ID"] = search;
ViewBag.Message = "No Records Founds";
return(View("TeacherAttendance", null));
}
}
}
public async Task <ActionResult> Edit(EmployeesModel model)
{
try
{
if (ModelState.IsValid)
{
if (HttpContext.Session.GetString("Token") == null || HttpContext.Session.GetString("Token") == "")
{
return(RedirectToAction("Login", "Account"));
}
using (HttpClient client = new HttpClient())
{
var token = "Bearer " + HttpContext.Session.GetString("Token");
client.DefaultRequestHeaders.Add("Authorization", token);
StringContent content = new StringContent(JsonConvert.SerializeObject(model), Encoding.UTF8, "application/json");
using (var response = await client.PutAsync("http://localhost:55327/api/Employees/PutEmployee?id=" + model.Id, content))
{
return(RedirectToAction("Index"));
}
}
}
else
{
return(View());
}
}
catch (Exception e)
{
_logger.LogError(e.Message);
return(RedirectToAction("Error", "Account"));
}
}
public ActionResult Teacher_Batches(int?page, string val)
{
TempData["TeacherID"] = null;
//TempData["Batch"] = null;
//TempData["Section"] = null;
//TempData["Degree"] = null;
IEnumerable <Teachers_Batches> EndResultListOfMarks = EmployeesModel.GetAllTeacher_batchesRecords();
var ListofDegreePrograms = r.Degree_Program.OrderBy(s => s.ProgramID).Select(s => s);
var TeachersIDS = r.Teachers.OrderBy(s => s.TeacherID).Select(s => s.TeacherID);
var ListofSections = r.Sections.Select(s => s);
if (EndResultListOfMarks != null)
{
ViewBag.ListofDegreePrograms = ListofDegreePrograms;
//ViewBag.ListofPartsInDegree = r.Teachers_Batches.Where(s => s.TeacherID == t_id).Select(s => s.);
ViewBag.ListofSections = ListofSections;
ViewBag.TeacherIDs = TeachersIDS;
ViewBag.Message = val;
return(View("Teacher_Batches", EndResultListOfMarks.ToPagedList(page ?? 1, 10)));
}
else
{
ViewBag.ListofDegreePrograms = ListofDegreePrograms;
//ViewBag.ListofPartsInDegree = r.Teachers_DegreeProgram.Where(s => s.TeacherID == t_id).Select(s => s.Part);
ViewBag.ListofSections = r.Sections.Select(s => s);
ViewBag.TeacherIDs = TeachersIDS;
ViewBag.Message = val;
ViewBag.Message = "No Records Founds";
return(View("Teacher_Batches", EndResultListOfMarks.ToPagedList(page ?? 1, 10)));
}
}
public void Create(EmployeesModel newEmployee)
{
try
{
// TODO: Add insert logic here
EmployeesModel studentmodel = new EmployeesModel();
studentmodel.First_Name = newEmployee.First_Name.ToString();
studentmodel.Last_Name = newEmployee.Last_Name.ToString();
studentmodel.Email = newEmployee.Email.ToString();
studentmodel.Dob = Convert.ToDateTime(newEmployee.Dob.ToString());
studentmodel.Gender = newEmployee.Gender.ToString();
studentmodel.Address = newEmployee.Address.ToString();
studentmodel.City = newEmployee.City.ToString();
studentmodel.State = newEmployee.State.ToString();
studentmodel.Pin = newEmployee.Pin.ToString();
unitofWork.employeeRepository.InsertEmployeesModel(studentmodel);
}
catch (Exception e)
{
string s = e.ToString();
}
}
public ActionResult Teacher_Batches(int?page, string val, string teacherID)
{
TempData["TeacherID"] = teacherID;
var TeachersIDS = r.Teachers.OrderBy(s => s.TeacherID).Select(s => s.TeacherID);
if (teacherID == null)
{
ViewBag.TeacherIDs = TeachersIDS;
ViewBag.Message = val;
ViewBag.Message = "No Records Founds";
return(View("Teacher_Batches", null));
}
else
{
IEnumerable <Teachers_Batches> EndResultListOfMarks = EmployeesModel.GetAllSearchSpecificTeacher_BatchesRecords(teacherID);
if (EndResultListOfMarks != null)
{
ViewBag.TeacherIDs = TeachersIDS;
ViewBag.Message = val;
return(View("Teacher_Batches", EndResultListOfMarks.ToPagedList(page ?? 1, 10)));
}
else
{
ViewBag.TeacherIDs = TeachersIDS;
ViewBag.Message = val;
ViewBag.Message = "No Records Founds";
return(View("Teacher_Batches", EndResultListOfMarks.ToPagedList(page ?? 1, 10)));
}
}
}
public ActionResult createPole(PolesModel poleModel)
{
if (!ModelState.IsValid)
{
PolesRepository poleRep = new PolesRepository();
EmployeesModel empModel = new EmployeesModel();
List <Employees> lisEmpManager = poleRep.getAllManager();
Debug.WriteLine("nombre d element :" + lisEmpManager.Count());
if (lisEmpManager.ToList().Count() == 0)
{
ViewData["erreur"] = "Employers";
return(View("ErrorEmptyElement"));
}
foreach (Employees emp in lisEmpManager)
{
Debug.WriteLine("element de list :" + emp.Email);
empModel.Employee_ID = emp.Employee_ID;
empModel.FirstName = emp.FirstName;
poleModel.Employees.Add(empModel);
break;
}
return(View("PoleFormulaire", poleModel));
}
Poles pole = new Poles();
PolesRepository polRep = new PolesRepository();
pole.Pole_ID = Guid.NewGuid();
pole.Name = Convert.ToString(Request.Form["Name"]);
pole.Manager_ID = new Guid(Convert.ToString(Request.Form["managerSelect"]));
polRep.AddPoles(pole);
return(RedirectToAction("AllPoles"));
}
public ActionResult ManageEmployees(int?page, string search)
{
bool checker = false;
IEnumerable <Employee> DataBasedOnRollnos = EmployeesModel.GetAllEmployeesRecords();
foreach (var item in DataBasedOnRollnos)
{
if (item.Name.StartsWith(search))
{
checker = true;
break;
}
}
if (checker)
{
ViewBag.SearchQuery = "True";
IEnumerable <Employee> SearchedData = EmployeesModel.getSpecificSearchRecordForEmployees(search);
return(View(SearchedData.ToPagedList(page ?? 1, 10)));
}
else
{
ViewBag.SearchQuery = "Name Doesnot Exists";
return(View());
}
}
public bool Create(EmployeesModel employee)
{
if (employee == null)
{
return(false);
}
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"INSERT INTO {EmployeesTable} (FirstName, MiddleName, LastName, Email, Team_Id) " +
$"VALUES ('{employee.FirstName}'," +
$"'{employee.MiddleName}', " +
$"'{employee.LastName}', " +
$"'{employee.Email}', " +
$"'{employee.Team_Id}');";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
public ActionResult EditFee(Fee feeRec, string bill, string rollno)
{
//string result = EmployeesModel.CheckFeeEditied(feeRec, bill);
try
{
int datedFee = feeRec.Dated.Value.Month;
string result = EmployeesModel.UpdateFeeRec(datedFee, feeRec, rollno, bill);
if (result == "OK")
{
var getFeeRecordUpdatedCurrently = r.Fees.Where(s => s.Bill_No == bill).Select(s => s).FirstOrDefault();
ViewBag.Message = "Successfully Record Updated";
return(View(getFeeRecordUpdatedCurrently));
}
else
{
var getFeeRecordUpdatedCurrently = r.Fees.Where(s => s.Bill_No == bill).Select(s => s).FirstOrDefault();
ViewBag.Message = result;
return(View(getFeeRecordUpdatedCurrently));
}
}
catch (Exception)
{
var getFeeRecordUpdatedCurrently = r.Fees.Where(s => s.Bill_No == bill).Select(s => s).FirstOrDefault();
ViewBag.Message = "Unable to Update Record!";
return(View(getFeeRecordUpdatedCurrently));
}
}
