public static string GetUserPassword(string vTenantID)
{
string strRet = string.Empty;
WFMDBDataContext db = new WFMDBDataContext();
List <uspWFMGetTenantNameResult> lstUsers = db.uspWFMGetTenantName(vTenantID).ToList();
if (lstUsers.Count > 0)
{
strRet = lstUsers[0].vPassword;
}
return(strRet);
}
//private static CodeDescription[] codes = new CodeDescription[]
//{
// new CodeDescription("M","Male","Gender"),
// new CodeDescription("F","Female","Gender"),
// new CodeDescription("S","Single","MaritalStatus"),
// new CodeDescription("M","Married","MaritalStatus"),
// new CodeDescription("CN","China","Country"),
// new CodeDescription("US","Unite States","Country"),
// new CodeDescription("UK","Britain","Country"),
// new CodeDescription("SG","Singapore","Country")
//};
public static Collection <CodeDescription> GetCodes(string category, string vTenantID, string vTenantFlag)
{
Collection <CodeDescription> codeCollection = new Collection <CodeDescription>();
WFMDBDataContext db = new WFMDBDataContext();
List <uspWFMGetShiftResult> lstShift = db.uspWFMGetShift(vTenantID, vTenantFlag).ToList();
foreach (var item in lstShift)
{
codeCollection.Add(new CodeDescription(item.iShiftID.ToString(), item.vShiftName, "Shift"));
}
//foreach(var code in codes.Where(code=>code.Category == category))
//{
// codeCollection.Add(code);
//}
return(codeCollection);
}
