public IEnumerable <CompanyModel> ListOfCompany()
{
List <CompanyModel> CompanyModel = new List <CompanyModel>();
CompanyModel = SpHelper <CompanyModel> .GetListWithRawSql("usp_CompanyList").ToList();
return(CompanyModel);
}
public IEnumerable <University_CollegeModel> ListOfUniversity_college()
{
List <University_CollegeModel> University_CollegeModel = new List <University_CollegeModel>();
University_CollegeModel = SpHelper <University_CollegeModel> .GetListWithRawSql("usp_University_CollegeList").ToList();
return(University_CollegeModel);
}
public IEnumerable <DesignationModel> ListOfDesigation()
{
List <DesignationModel> DesignationModel = new List <DesignationModel>();
DesignationModel = SpHelper <DesignationModel> .GetListWithRawSql("usp_DesignationList").ToList();
return(DesignationModel);
}
public IEnumerable <CityModel> ListofCity(int State)
{
List <CityModel> cityModel = new List <CityModel>();
cityModel = SpHelper <CityModel> .GetListWithRawSql("usp_CityList").ToList();
return(cityModel);
}
public IEnumerable <StateModel> ListOfState(int CountryId)
{
List <StateModel> stateModel = new List <StateModel>();
stateModel = SpHelper <StateModel> .GetListWithRawSql("usp_StateList").ToList();
return(stateModel);
}
public IEnumerable <CountryModel> ListOfCountry()
{
List <CountryModel> countryModels = new List <CountryModel>();
countryModels = SpHelper <CountryModel> .GetListWithRawSql("usp_CountryList").ToList();
return(countryModels);
}
public IEnumerable <OtherMasterModel> ListOfOtherMaster()
{
List <OtherMasterModel> otherMasterModel = new List <OtherMasterModel>();
otherMasterModel = SpHelper <OtherMasterModel> .GetListWithRawSql("usp_otherMasterList").ToList();
return(otherMasterModel);
}
public AccountModel UserLogin(string EmailID, string Password)
{
try
{
string DecrPassword = Common.Common.Encryptdata(Password);
var objUserRes = SpHelper <AccountModel> .GetListWithRawSql("Sp_LoginCheck @Emaild,@passWord",
new SqlParameter { ParameterName = "@Emaild", DbType = DbType.String, Value = EmailID },
new SqlParameter { ParameterName = "@passWord", DbType = DbType.String, Value = DecrPassword }).FirstOrDefault();
return(objUserRes);
}
catch (Exception ex)
{
}
return(null);
}
