public static DataTable DdlDsByEmployee(string pUsername, EFormType pEFormType)
{
DataTable tblReturn = new DataTable();
string strCommandText = "";
switch (pEFormType)
{
case EFormType.Leave:
strCommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode=(SELECT TOP 1 deptcode FROM HR.Employees WHERE username='******') AND leave='1') ORDER BY firname";
break;
case EFormType.OfficialBussiness:
strCommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode=(SELECT TOP 1 deptcode FROM HR.Employees WHERE username='******') AND ob='1') ORDER BY firname";
break;
case EFormType.Overtime:
strCommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode=(SELECT TOP 1 deptcode FROM HR.Employees WHERE username='******') AND ot='1') ORDER BY firname";
break;
case EFormType.Undertime:
strCommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode=(SELECT TOP 1 deptcode FROM HR.Employees WHERE username='******') AND ut='1') ORDER BY firname";
break;
}
using (SqlConnection cn = new SqlConnection(HRMSCore.HrmsConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = strCommandText;
SqlDataAdapter da = new SqlDataAdapter(cmd);
cn.Open();
da.Fill(tblReturn);
}
return(tblReturn);
}
public static bool IsApprover(string pUsername, EFormType pEFormType)
{
bool blnReturn = false;
string strCommandText = "";
switch (pEFormType)
{
case EFormType.Leave:
strCommandText = "SELECT username FROM HR.DepartmentApprover WHERE username='******' AND leave='1'";
break;
case EFormType.Overtime:
strCommandText = "SELECT username FROM HR.DepartmentApprover WHERE username='******' AND ot='1'";
break;
case EFormType.OfficialBussiness:
strCommandText = "SELECT username FROM HR.DepartmentApprover WHERE username='******' AND ob='1'";
break;
case EFormType.Undertime:
strCommandText = "SELECT username FROM HR.DepartmentApprover WHERE username='******' AND ut='1'";
break;
}
using (SqlConnection cn = new SqlConnection(HRMSCore.HrmsConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = strCommandText;
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
blnReturn = dr.Read();
dr.Close();
}
return(blnReturn);
}
public static DataTable DSLApproverDepartment(string pDepartmentCode, EFormType pEFormType)
{
DataTable tblReturn = new DataTable();
using (SqlConnection cn = new SqlConnection(clsHrms.HrmsConnectionString))
{
SqlCommand cmd = cn.CreateCommand();
switch (pEFormType)
{
case EFormType.Leave:
cmd.CommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode='" + pDepartmentCode + "' AND leave='1') ORDER BY firname";
break;
case EFormType.OfficialBussiness:
cmd.CommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode='" + pDepartmentCode + "' AND ob='1') ORDER BY firname";
break;
case EFormType.Overtime:
cmd.CommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode='" + pDepartmentCode + "' AND ot='1') ORDER BY firname";
break;
case EFormType.Undertime:
cmd.CommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode='" + pDepartmentCode + "' AND ut='1') ORDER BY firname";
break;
case EFormType.RFI:
cmd.CommandText = "SELECT username AS pvalue,firname + ' ' + lastname AS ptext FROM Users.Users WHERE username IN (SELECT username FROM HR.DepartmentApprover WHERE deptcode='" + pDepartmentCode + "' AND rfiflag='1') ORDER BY firname";
break;
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
cn.Open();
da.Fill(tblReturn);
}
return(tblReturn);
}
//-------------------------------------------------------------------------------
//
public FrmDispStatuses(FrmMain parent, ImageListWrapper imageListWrapper, EFormType formtype)
{
InitializeComponent();
ReplyStartTwitdata = null;
FormType = formtype;
uctlDispTwit.ImageListWrapper = imageListWrapper;
parent.RegisterUctlDispTwitEvent(uctlDispTwit);
}
//-------------------------------------------------------------------------------
//
public FrmDispUsers(FrmMain mainForm, ImageListWrapper imgListWrapper, EFormType formtype)
{
InitializeComponent();
_mainForm = mainForm;
_imageListWrapper = imgListWrapper;
lstvList.SmallImageList = imgListWrapper.ImageList;
FormType = formtype;
UserScreenName = ListID = null;
RetweetStatusID = -1;
_loadingimg = (Bitmap)StarlitTwit.Properties.Resources.NowLoadingS.Clone();
_imageAnimation = new ImageAnimation(_loadingimg);
_imageAnimation.FrameUpdated += Image_Animate;
}
public static void OpenForm(EFormType type)
{
switch (type)
{
case EFormType.Process:
var formProcess = new FormProcessos();
formProcess.ShowDialog();
break;
case EFormType.ProductProcess:
var formProductProcess = new FormProdutoProcessos();
formProductProcess.ShowDialog();
break;
}
}
//-------------------------------------------------------------------------------
public FrmDispLists(FrmMain mainForm, ImageListWrapper imgListWrapper, EFormType formtype)
{
InitializeComponent();
_mainForm = mainForm;
_imageListWrapper = imgListWrapper;
lstvList.SmallImageList = imgListWrapper.ImageList;
FormType = formtype;
UserScreenName = null;
_loadingimg = (Bitmap)StarlitTwit.Properties.Resources.NowLoadingS.Clone();
_imageAnimation = new ImageAnimation(_loadingimg);
_imageAnimation.FrameUpdated += Image_Animate;
btnAddNewList.Visible = (formtype == EFormType.MyList);
}
public static void OpenForm(EFormType type)
{
switch (type)
{
case EFormType.Process:
var formProcess = new FormProcessos(GetData());
formProcess.Show();
break;
case EFormType.ProductProcess:
var formProductProcess = new FormProdutoProcessos(GetData(), GetIgdData());
formProductProcess.Show();
break;
case EFormType.ProcessMonitor:
var formProcessMonitor = new FormManagerRequisitions(GetData(), GetIgdData());
formProcessMonitor.Show();
break;
case EFormType.OrdersMonitor:
var formOrdersMonitor = new FormManagerOrders(GetData(), GetIgdData());
formOrdersMonitor.Show();
break;
case EFormType.Analisys:
var formAnalisys = new FormAnalises(GetData());
formAnalisys.Show();
break;
case EFormType.ProductAnalisys:
var formProductAnalisys = new FormProdutoAnalises(GetData(), GetIgdData());
formProductAnalisys.Show();
break;
case EFormType.ProductSeriesData:
var formProductSeriesData = new FormProdutoCertificado(GetData(), GetIgdData());
formProductSeriesData.Show();
break;
case EFormType.CertifiedResult:
var formCertifiedResult = new FormCertificadoImpressao(GetData(), GetIgdData());
formCertifiedResult.Show();
break;
}
}
