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