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