public DataSet ComEvalUpdate(DataBankManager M) { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); SqlParameter OP1 = new SqlParameter("@ComitteeID", M.CMID); Da.parameters.Add(OP1); SqlParameter OP2 = new SqlParameter("@EmpId", M.IEmpId); Da.parameters.Add(OP2); SqlParameter OP3 = new SqlParameter("@Members", M.HEmployeeName); Da.parameters.Add(OP3); SqlParameter OP4 = new SqlParameter("@Department", M.IDepName); Da.parameters.Add(OP4); SqlParameter OP5 = new SqlParameter("@ODepartment", M.ODepName); Da.parameters.Add(OP5); SqlParameter OP6 = new SqlParameter("@Remark1", M.Remark1); Da.parameters.Add(OP6); foreach (SqlParameter p in Da.parameters) { p.Direction = ParameterDirection.Input; } Ds = Da.ExecuteDataset("SP_CommitteeDetail_Update"); return(Ds); }
public DataSet BeneficiaryResponse(Manager M) { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); SqlParameter OP1 = new SqlParameter("@CmEmailID", M.ComInboxID); Da.parameters.Add(OP1); SqlParameter OP2 = new SqlParameter("@Type", M.Status); Da.parameters.Add(OP2); SqlParameter OP3 = new SqlParameter("@Days", M.Days); Da.parameters.Add(OP3); SqlParameter OP4 = new SqlParameter("@Rating", M.Rating); Da.parameters.Add(OP4); foreach (SqlParameter p in Da.parameters) { p.Direction = ParameterDirection.Input; } Ds = Da.ExecuteDataset("SP_BeneficiaryEInbox_Update_Response"); return(Ds); }
public DataSet benselectchange(Manager M) { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); SqlParameter OP1 = new SqlParameter("@CmEmailID", M.ComInboxID); Da.parameters.Add(OP1); SqlParameter OP2 = new SqlParameter("@Grade", M.BENGRADE); Da.parameters.Add(OP2); SqlParameter OP3 = new SqlParameter("@Rating", M.BENRATING); Da.parameters.Add(OP3); SqlParameter OP4 = new SqlParameter("@ideaid", M.IdeaId); Da.parameters.Add(OP4); foreach (SqlParameter p in Da.parameters) { p.Direction = ParameterDirection.Input; } Ds = Da.ExecuteDataset("benselectchange"); return(Ds); }
public DataSet ComiteeResponse(DataBankManager M) { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); SqlParameter OP1 = new SqlParameter("@CmEmailID", M.ComInboxID); Da.parameters.Add(OP1); SqlParameter OP2 = new SqlParameter("@Type", M.Status); Da.parameters.Add(OP2); SqlParameter OP3 = new SqlParameter("@Dep", M.Suggestion); Da.parameters.Add(OP3); SqlParameter OP4 = new SqlParameter("@Des", M.Reason); Da.parameters.Add(OP4); foreach (SqlParameter p in Da.parameters) { p.Direction = ParameterDirection.Input; } Ds = Da.ExecuteDataset("SP_CommitteeEvalInbox_Update_Response"); return(Ds); }
public DataSet CompanySelectAll() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("[sp_Company_Select_All]"); return(Ds); }
public DataSet DepartmentSelectAll() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_Department_Select_All"); return(Ds); }
public DataSet EmployeeDetailAll() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("SP_Employee_Select"); return(Ds); }
public DataSet SuggestionIdAuto_DBM() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_EmployeeSuggestion_AutoGen_IdeaID_DBM"); return(Ds); }
public DataSet FinanceEvaluvationSendGridViewFinanceDetail() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("[SP_FinanceEvalSend_SelectGridView_MailSendID_FinanceDetail]"); return(Ds); }
public DataSet CommitteeEvaluvationGridView() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_CommitteeEvaluvation_Select_All"); return(Ds); }
public DataSet CommitteeEvaluvationSendGridView() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("SP_CommitteeEvalSend_SelectGridView_MailSendID"); return(Ds); }
public DataSet ManagerInboxIDAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_ManagerEInbox_AutoGen_EmailID"); return(Ds); }
public DataSet DepartmentSelectOthersAllComEvaPopUp() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_Department_Select_All_Others_CommitteeEvaluvation_PopUP"); return(Ds); }
public DataSet IMPLTeamEvalInboxIDAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_TeamEvalEInbox_AutoGen_ComitteeID"); return(Ds); }
public DataSet ComEvalIDAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_ComitteeDetail_AutoGen_ComitteeID"); return(Ds); }
public DataSet ComEvalSendBoxAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_ComitteeEvalSend_AutoGen_ComitteeID"); return(Ds); }
public DataSet DesignationSelectAll() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_Designation_Select_All"); return(Ds); }
public DataSet HODDetailGridView() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_HeadOffcer_Select_All"); return(Ds); }
public DataSet EmployeeSelectAll() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("SP_Employee_Select_ID_Name"); return(Ds); }
public DataSet Rolescomment() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("RolesComment"); return(Ds); }
public DataSet EmpSelectAllDisable() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("[SP_Employee_Select_Disable]"); return(Ds); }
public DataSet CompanyIdAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_Company_AutoGen_DepID"); return(Ds); }
public DataSet IdeaHistoryTracking() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("IdeaTrackingHistory"); return(Ds); }
public DataSet ComtEvalRepViewSendreject() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("SP_CommitteeEvalInbox_Select_Send_RepeaterView_reject"); return(Ds); }
public DataSet DepartmentIdAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_Department_AutoGen_DepID"); return(Ds); }
public DataSet TeamIdAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_TeamDetail_AutoGen_TeamID"); return(Ds); }
public DataSet DesignationIdAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_Designation_AutoGen_DesID"); return(Ds); }
public DataSet TeamNameAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_TeamDetail_TeamName_Select_All"); return(Ds); }
public DataSet ComEvalSendIDAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_IMPLTeam_SendMailID_AutoGeneration"); return(Ds); }
public DataSet ProjectIDAuto() { DataTO Da = new DataTO(); DataSet Ds = new DataSet(); Ds = Da.ExecuteDataset("sp_TeamExecution_AutoGen_ProjectID"); return(Ds); }