public string TrackStatus(decimal AwbNo)
{
string res = "";
try
{
res = (from stat in context.Package select PackXprezDBContext.TrackStatus(AwbNo)).FirstOrDefault();
}
catch (Exception)
{
res = "Some Error Occured";
}
return(res);
}
public int ValidateUser(string emailId, string password)
{
int roleId;
try
{
roleId = (from role in context.Customer select PackXprezDBContext.LoginUser(emailId, password)).FirstOrDefault();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
roleId = -98;
}
return(roleId);
}
public int checkAvailability(decimal From_Pincode, decimal To_Pincode)
{
int value = 0;
try
{
value = (from v in context.Service select PackXprezDBContext.CheckService(From_Pincode, To_Pincode)).FirstOrDefault();
}
catch (Exception e)
{
value = -98;
}
return(value);
}
public PackXprezRepository()
{
Context = new PackXprezDBContext();
}
public PackXprezDAL()
{
context = new PackXprezDBContext();
}