//Nabih get Translated text by Abbreviation
public static IList <LookUpDetails> GetLkupByAb(string keyword = null, int?lang = 1, string connection = "")
{
IList <LookUpDetails> lkps = new List <LookUpDetails>();
using (SqlConnection con = new SqlConnection(connection))
{
SqlCommand cmd = new SqlCommand("sp_ManageLookup", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@Mode", Value = "GetLookupDetailsbyAbbreviation"
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@Abbreviation", Value = keyword
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@LanguageId", Value = lang
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
LookUpDetails lkp = new LookUpDetails();
lkp.Id = Convert.ToInt32(rdr["LookupId"]);
lkp.LookupDetailsId = Convert.ToInt32(rdr["ID"]);
lkp.LanguageId = Convert.ToInt32(lang);
lkp.LookupDetailsDescription = rdr["Description"].ToString();
lkp.Keyword = rdr["Keyword"].ToString();
lkps.Add(lkp);
}
}
return(lkps);
}
public static IList <LookUpDetails> FillTutorQuestionDropDown(int LookupId = 0, int LanguageId = 1, string connection = "")
{
IList <LookUpDetails> lud = new List <LookUpDetails>();
using (SqlConnection con = new SqlConnection(connection))
{
//Getting Categories
SqlCommand cmd = new SqlCommand("sp_ManageLookup", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@Mode", Value = "GetLookupDetails"
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@LanguageId", Value = LanguageId
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@LookupId", Value = LookupId
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
LookUpDetails l = new LookUpDetails();
l.Id = Convert.ToInt32(rdr["ID"]);
l.LookupDetailsDescription = rdr["Description"].ToString();
l.DataType = rdr["DataType"].ToString();
l.Context = rdr["Context"].ToString();
l.LanguageId = LanguageId;
lud.Add(l);
}
return(lud);
}
}
public static IList <LookUpDetails> GetAppContent(string LookupIds = "", int LangId = 0, string connection = "")
{
IList <LookUpDetails> lupDetails = new List <LookUpDetails>();
using (SqlConnection con = new SqlConnection(connection))
{
//Getting AppContent
SqlCommand cmd = new SqlCommand("sp_GetLookUp", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@LangId", Value = LangId
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@LookupIds", Value = LookupIds
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
LookUpDetails l = new LookUpDetails();
l.Id = Convert.ToInt32(rdr["ID"]);
l.LookupDetailsDescription = rdr["Description"].ToString();
lupDetails.Add(l);
}
return(lupDetails);
}
}
public static IList <LookUpDetails> GetAllTutorServices(string connection = "")
{
List <LookUpDetails> Services = new List <LookUpDetails>();
using (SqlConnection con = new SqlConnection(connection))
{
SqlCommand cmd = new SqlCommand("sp_ManageFindTutorFilter", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@Mode", Value = "TutorServices"
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
LookUpDetails services = new LookUpDetails();
services.LookupDetailsId = Convert.ToInt32(rdr["ID"]);
services.Keyword = rdr["Keyword"].ToString();
services.LookupDetailsDescription = rdr["Description"].ToString();
services.Context = rdr["Context"].ToString();
Services.Add(services);
}
}
return(Services);
}
public static IList <LookUpDetails> GetAllCurriculum(string connection = "")
{
List <LookUpDetails> Curriculum = new List <LookUpDetails>();
using (SqlConnection con = new SqlConnection(connection))
{
SqlCommand cmd = new SqlCommand("sp_ManageFindTutorFilter", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@Mode", Value = "Curriculum"
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
LookUpDetails curriculum = new LookUpDetails();
curriculum.LookupDetailsId = Convert.ToInt32(rdr["ID"]);
curriculum.LookupDetailsDescription = rdr["Keyword"].ToString();
Curriculum.Add(curriculum);
}
}
return(Curriculum);
}
