public string GetDesignationCode(JGConstant.DesignationType objDesignationType)
{
try
{
SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase();
{
DbCommand command = database.GetStoredProcCommand("UDP_GetDesignationCode");
database.AddInParameter(command, "@DesignationID", DbType.Int32, objDesignationType);
command.CommandType = CommandType.StoredProcedure;
string returnValue = string.Empty;
returnValue = Convert.ToString(database.ExecuteScalar(command));
return(returnValue);
}
}
catch (Exception ex)
{
return(null);
}
}
public static string GetDesignationCode(JGConstant.DesignationType objDesignationType)
{
string strCode = string.Empty;
switch (objDesignationType)
{
case JGConstant.DesignationType.Admin:
strCode = "ADM";
break;
case JGConstant.DesignationType.Jr_Sales:
strCode = "JSL";
break;
case JGConstant.DesignationType.Jr_Project_Manager:
strCode = "JPM";
break;
case JGConstant.DesignationType.Office_Manager:
strCode = "OFM";
break;
case JGConstant.DesignationType.Recruiter:
strCode = "REC";
break;
case JGConstant.DesignationType.Sales_Manager:
strCode = "SLM";
break;
case JGConstant.DesignationType.Sr_Sales:
strCode = "SSL";
break;
case JGConstant.DesignationType.IT_Network_Admin:
strCode = "ITNA";
break;
case JGConstant.DesignationType.IT_Jr_Net_Developer:
strCode = "ITJN";
break;
case JGConstant.DesignationType.IT_Sr_Net_Developer:
strCode = "ITSN";
break;
case JGConstant.DesignationType.IT_Android_Developer:
strCode = "ITAD";
break;
case JGConstant.DesignationType.IT_PHP_Developer:
strCode = "ITPH";
break;
case JGConstant.DesignationType.IT_SEO_OR_BackLinking:
strCode = "ITSB";
break;
case JGConstant.DesignationType.Installer_Helper:
strCode = "INH";
break;
case JGConstant.DesignationType.Installer_Journeyman:
strCode = "INJ";
break;
case JGConstant.DesignationType.Installer_Mechanic:
strCode = "INM";
break;
case JGConstant.DesignationType.Installer_Lead_Mechanic:
strCode = "INLM";
break;
case JGConstant.DesignationType.Installer_Foreman:
strCode = "INF";
break;
case JGConstant.DesignationType.Commercial_Only:
strCode = "COM";
break;
case JGConstant.DesignationType.SubContractor:
strCode = "SBC";
break;
case JGConstant.DesignationType.IT_Lead:
strCode = "ITL";
break;
case JGConstant.DesignationType.Admin_Sales:
strCode = "ASL";
break;
case JGConstant.DesignationType.Admin_Recruiter:
strCode = "AREC";
break;
default:
strCode = "OUID";
break;
}
return(strCode);
}
public string GetDesignationCode(JGConstant.DesignationType objDesignationType)
{
return(DesignationDAL.Instance.GetDesignationCode(objDesignationType));
}