public IList <CatagoryMaster> GetCatagories()
{
List <CatagoryMaster> listCatagory = new List <CatagoryMaster>();
try
{
using (var dbCtx = new ECashDbEntities())
{
listCatagory = dbCtx.Database.SqlQuery <CatagoryMaster>(
"EXEC sp_GetCatagories"
)
.ToList();
return(listCatagory);
}
}
catch (Exception e)
{
throw e;
}
}
public int RegisterUser(RegisterRequest registerRequest)
{
try
{
using (var dbCtx = new ECashDbEntities())
{
var register = dbCtx.Database.SqlQuery <int>(
"EXEC sp_Register @Username, @Emailid,@MobileNo,@password",
new SqlParameter("Username", registerRequest.UserName),
new SqlParameter("Emailid", registerRequest.Password),
new SqlParameter("MobileNo", registerRequest.MobileNo),
new SqlParameter("password", registerRequest.Password)
).FirstOrDefault();
return(register);
}
}
catch (Exception)
{
throw;
}
}
public LoginResponse GetLogin(LoginRequest loginrequest)
{
try
{
using (var dbCtx = new ECashDbEntities())
{
var autheticate = dbCtx.Database.SqlQuery <LoginResponse>(
"EXEC sp_login @mobileNo, @password",
new SqlParameter("mobileNo", loginrequest.UserName),
new SqlParameter("password", loginrequest.Password)
)
.FirstOrDefault();
return(autheticate);
}
}
catch (Exception e)
{
throw e;
}
}
public IList <VideoResponse> GetVideoList(int catagoryId)
{
List <VideoResponse> listVideo = new List <VideoResponse>();
try
{
using (var dbCtx = new ECashDbEntities())
{
listVideo = dbCtx.Database.SqlQuery <VideoResponse>(
"EXEC sp_GetVideoContent @CatagoryId",
new SqlParameter("CatagoryId", catagoryId)
)
.ToList();
return(listVideo);
}
}
catch (Exception e)
{
throw e;
}
}
