//public static DataTable UpdateCompanyInfo() //{ // DataTable dt = new DataTable(); // SqlDataAdapter da = new SqlDataAdapter("SP_UpdateWorkExperience '" + request.Username + "','" + request.FatherLName + "','" + request.FatherFName + "','" + request.MotherLName + "','" + request.MotherFName + "','" + request.FatherContactNum + "','" + request.MotherContactNum + "','" + request.SiblingLName + "','" + request.SiblingFName + "','" + request.SiblingContactNum + "'", cs); // da.Fill(dt); // return dt; //} //public static void UpdatePassword(RequestUpdatePassword request) //{ // DataTable dt = new DataTable(); // SqlDataAdapter da = new SqlDataAdapter("SP_UpdatePassword " + request.UserID + ", " + request.Password, cs); // da.Fill(dt); //} #endregion #region AuditTrail public static DataTable AuditTrail(RequestAuditTrail request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_AuditTrail '" + request.Username + "','" + request.Action + "'", cs); da.Fill(dt); return(dt); }
public static void AddEducInfo(RequestAddEducInfo request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_AddEducInfo '" + request.Username + "','" + request.School + "','" + request.Degree + "','" + request.Course + "','" + request.YearGraduated + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Added School"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static void UpdateSiblingInfo(RequestUpdateSiblingInfo request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_UpdateSiblingInfo '" + request.SiblingID + "','" + request.Username + "','" + request.SiblingLName + "','" + request.SiblingFName + "','" + request.SiblingContactNum + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Updated Sibling Information"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static void UpdateTimeChangeRequest(RequestUpdateTimeChangeRequest request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_UpdateTimeChangeRequest '" + request.RequestID + "','" + request.Username + "','" + request.DateApplied + "','" + request.AttendanceDateChange + "','" + request.TimeChangeIn + "','" + request.TimeChangeOut + "','" + request.Reason + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Updated Time Change Request"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static void UpdateLeaveRequest(RequestUpdateLeaveRequest request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_UpdateLeaveRequest '" + request.RequestID + "','" + request.Username + "','" + request.DateApplied + "','" + request.StartDate + "','" + request.EndDate + "','" + request.LeaveType + "','" + request.Reason + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Updated Leave Request"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static void UpdateFamilyInfo(RequestUpdateFamilyInfo request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_UpdateFamilyInfo '" + request.FamilyInfoID + "','" + request.Username + "','" + request.FatherLName + "','" + request.FatherFName + "','" + request.MotherLName + "','" + request.MotherFName + "','" + request.FatherContactNum + "','" + request.MotherContactNum + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Updated Family Information"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static void UpdateEducInfo(RequestUpdateEducationalInfo request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_UpdateEducInfo '" + request.EducInfoID + "','" + request.Username + "','" + request.School + "','" + request.Degree + "','" + request.Course + "','" + request.YearGraduated + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Updated Educational Information"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static void UpdateContactInfo(RequestUpdateContactInfo request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_UpdateContactInfo '" + request.Username + "','" + request.HomeNum + "','" + request.CellphoneNum + "','" + request.HomeAddress + "','" + request.Email + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Updated Contact Information"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static DataTable ActivateAccount(RequestActivateAccount request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_ActivateAccount '" + request.UserID + "'", cs); RequestAuditTrail RequestAudit = new RequestAuditTrail(request.Username, "Activated an Account"); DAT.AuditTrail(RequestAudit); da.Fill(dt); return(dt); }
public static DataTable ViewTimeChangeRequest(RequestViewTimeChangeRequest request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_ViewTimeChangeRequest '" + request.Username + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Viewed Time Change Request"); DAT.AuditTrail(requestaudit); da.Fill(dt); return(dt); }
public static void VerifyRequest(RequestVerifyRequests request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_VerifyRequests '" + request.RequestID + "','" + request.UserID + "','" + request.Status + "','" + request.Remarks + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Verified Request"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static DataTable UpdateWorkExperience(RequestUpdateWorkExperience request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_UpdateWorkExperience '" + request.WorkExperienceID + "','" + request.Username + "','" + request.YearStarted + "','" + request.YearEnded + "','" + request.Company + "','" + request.ExpPosition + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Updated Work Experience"); DAT.AuditTrail(requestaudit); da.Fill(dt); return(dt); }
public static DataTable ViewWorkExperience(RequestViewWorkExperience request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_ViewWorkExperience '" + request.Username + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Viewed Work Experience"); DAT.AuditTrail(requestaudit); da.Fill(dt); return(dt); }
public static DataTable ViewCompanyInfo(RequestViewCompanyInfo request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_ViewCompanyInfo '" + request.Username + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Viewed Company Information"); DAT.AuditTrail(requestaudit); da.Fill(dt); return(dt); }
public static void AddWorkExperience(RequestAddWorkExperience request) { string cs = "SERVER =localhost; DATABASE=EmployeePortal; Integrated Security=true;"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_AddWorkExperience '" + request.Username + "','" + request.YearStarted + "','" + request.YearEnded + "','" + request.Company + "','" + request.ExpPosition + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Added Work Experience"); DAT.AuditTrail(requestaudit); da.Fill(dt); }
public static DataTable AddUser(RequestAddUser request) { string password = ComputeHash(request.Password); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_AddEmployee '" + request.UsertypeID + "','" + request.LName + "','" + request.FName + "','" + request.MName + "','" + request.Nickname + "','" + request.DOB + "','" + request.CivilStatus + "','" + request.Gender + "','" + request.Username + "','" + password + "','" + request.DateTimeAdded + "','" + request.AccountStatus + "','" + request.UserStatus + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Added User"); DAT.AuditTrail(requestaudit); da.Fill(dt); return(dt); }
public static DataTable SearchEmployees(RequestSearchEmployees request) { DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_SearchEmployees '" + request.Username + "%" + request.LName + "%" + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "Searched Employee"); DAT.AuditTrail(requestaudit); da.Fill(dt); return(dt); }
public static DataTable Login(RequestLogin request) { DataTable d2 = new DataTable(); string password = ComputeHash(request.Password); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("SP_LoginUser '" + request.Username + "', '" + password + "'", cs); RequestAuditTrail requestaudit = new RequestAuditTrail(request.Username, "LoggedIn"); DAT.AuditTrail(requestaudit); da.Fill(dt); return(dt); }