public override string[] GetRolesForUser(string username)
{
// throw new NotImplementedException();
CobinDBCon con = new CobinDBCon();
int i = 0;
//List<sPlsUserRole_Result> rslt = con.sPlsUserRole("s", username, null, null, null, null, null).ToList();
//if (rslt.Count > 0)
//{
// string[] Role = new string[rslt.Count];
// foreach (sPlsUserRole_Result row in rslt)
// {
// Role[i] = row.Name.ToString();
// i = i + 1;
// }
// return Role;
//}
//else
//{
// return new string[] { };
//}
return(new string[] { });
}
public MembershipUser GetUser(string username)
{
CobinDBCon con = new CobinDBCon();
//SpUserList_Result rslt = con.SpUserList(null, username, null, null, null, null, null).FirstOrDefault();
MembershipUser membershipUser = null;
//if (rslt.UserName != null)
//{
// membershipUser = new MembershipUser(rslt.UserName, rslt.ContactPerson, null, rslt.EmailAddress,
// null, null, true, false, rslt.CreatedDate, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now);
//}
return(membershipUser);
}
public override bool ValidateUser(string username, string password)
{
//ClsStatic.ResponseDetail response = new ClsStatic.ResponseDetail();
CobinDBCon con = new CobinDBCon();
PlsUserAuthentication_Result rslt = con.PlsUserAuthentication(username, password).FirstOrDefault();
if (rslt.Code == "000")
{
return(true);
}
//response.Code = rslt.Code;
//response.Status = rslt.Status;
//response.Message = rslt.Message;
return(false);
}
public static List <SelectListItem> GetQuestionOptions(int?Id_Option_Groups)
{
CobinDBCon con = new CobinDBCon();
List <SelectListItem> OptionList = new List <SelectListItem>();
List <sPlsOptionChoices_Result> alloption = con.sPlsOptionChoices("s", Id_Option_Groups, null).ToList();
//if (BlankLabel == null)
// BlankLabel = "--Select--";
OptionList.Add(new SelectListItem()
{
Text = "--Select--", Value = "", Selected = true
});
foreach (sPlsOptionChoices_Result row in alloption)
{
OptionList.Add(new SelectListItem()
{
Text = row.Option_Choice_Name, Value = row.Id_Option_Groups_Choices.ToString(), Selected = false
});
}
return(OptionList);
}
public static List <SelectListItem> GetProjectList(int?InstitutionId)
{
CobinDBCon con = new CobinDBCon();
List <SelectListItem> ProjectList = new List <SelectListItem>();
List <sPlsStaticData_Result> allProjectList = con.sPlsStaticData(null, "projectlist").ToList();
//if (BlankLabel == null)
// BlankLabel = "--Select--";
ProjectList.Add(new SelectListItem()
{
Text = "--Select--", Value = "", Selected = true
});
foreach (sPlsStaticData_Result row in allProjectList)
{
ProjectList.Add(new SelectListItem()
{
Text = row.Label, Value = row.Value.ToString(), Selected = false
});
}
return(ProjectList);
}
