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);
}