public void CreateForm1(AddForm1Details addForm1Details)
{
using (var context = new EIA_DEVEntities())
{
context.Database.ExecuteStoredProcedure(addForm1Details);
}
}
public IEnumerable <GetCourierCompanyName_Result> courierlist(string TerminalCode)
{
IEnumerable <GetCourierCompanyName_Result> result = null;
using (var context = new EIA_DEVEntities())
{
result = context.Database.ExecProcedure <GetCourierCompanyName_Result>("GetCourierCompanyName", new
{
TerminalCode = TerminalCode
}).ToList();
}
return(result);
}
public GetFlightDetails_Result flightDetail(string FlightNumber, string TerminalCode)
{
GetFlightDetails_Result result = null;
using (var context = new EIA_DEVEntities())
{
result = context.Database.ExecProcedure <GetFlightDetails_Result>("GetFlightDetails", new
{
FlightNumber = FlightNumber,
TerminalCode = TerminalCode
}).FirstOrDefault();
}
return(result);
}
public GetForm1CheckStatus_Result GetForm1CheckStatus(string IGMNumber, string MAWBNumber, string TerminalCode)
{
GetForm1CheckStatus_Result result = null;
using (var context = new EIA_DEVEntities())
{
result = context.Database.ExecProcedure <GetForm1CheckStatus_Result>("GetForm1CheckStatus", new
{
IGMNumber = IGMNumber,
MAWBNumber = MAWBNumber,
TerminalCode = TerminalCode
}).FirstOrDefault();
}
return(result);
}
public IEnumerable <GetFlightNumber_Result> flightList(string TerminalCode, string AirlineCode, string FlightType)
{
IEnumerable <GetFlightNumber_Result> result = null;
using (var context = new EIA_DEVEntities())
{
result = context.Database.ExecProcedure <GetFlightNumber_Result>("GetFlightNumber", new
{
TerminalCode = TerminalCode,
AirlineCode = DBNull.Value,
FlightType = FlightType
}).ToList();
}
return(result);
}
public LoginRepository(EIA_DEVEntities objcontext)
{
_db = objcontext;
}
public VW_UserDetailRepository(EIA_DEVEntities objcontext)
{
_db = objcontext;
}
public VSEC_ROLE_MST_Repository(EIA_DEVEntities objcontext)
{
_db = objcontext;
}
public Menu(EIA_DEVEntities objcontext)
{
_db = objcontext;
}
public M_CommonMaster_MST_Repository(EIA_DEVEntities objcontext)
{
_db = objcontext;
}
public GenericRepository(EIA_DEVEntities context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}