public AgencyViewBLL()
{
AgencyRepository = new AgencyRepository();
AgencyContractRepository = new AgencyContractRepository();
ContractRepository = new ContractRepository();
QuotationRepository = new QuotationRepository();
}
private void Search()
{
_projectDataContext = new ProjectDataContext();
_agencyRepository = new AgencyRepository(_projectDataContext);
dgvDuLieu.DataSource = _agencyRepository.GetAll().OrderBy(_ => _.AgencyName);
Control();
}
public JsonResult SelectAgencyDetail()
{
AgencyRepository objRep = new AgencyRepository();
DataSet ds = objRep.select_tbl_Agency_detail(Session["Gov_User_id"].ToString());
List <AgencyDetail> _list = new List <AgencyDetail>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
AgencyDetail objBasic = new AgencyDetail();
objBasic.id = row["id"].ToString();
objBasic.agencyid = row["agencyid"].ToString();
objBasic.nameofentitlename = row["nameofentitlename"].ToString();
_list.Add(objBasic);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public ViewMeetingsBLL()
{
ActivityRepository = new ActivityRepository();
AgencyRepository = new AgencyRepository();
AgencyContactRepository = new AgencyContactRepository();
CruiseRepository = new CruiseRepository();
}
public JsonResult SelectAgencyDetail(string ID = "")
{
AgencyRepository objRep = new AgencyRepository();
DataSet ds = objRep.select_tbl_Agency_detail(TempData.Peek("agencyid").ToString());
TempData.Keep("agencyid");
List <AgencyDetail> _list = new List <AgencyDetail>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
AgencyDetail objBasic = new AgencyDetail();
objBasic.id = row["id"].ToString();
objBasic.agencyid = row["agencyid"].ToString();
objBasic.nameofentitlename = row["nameofentitlename"].ToString();
objBasic.fee_g1 = row["fee_g1"].ToString();
objBasic.fee_g2 = row["fee_g2"].ToString();
objBasic.fee_g3 = row["fee_g3"].ToString();
objBasic.fee_g4 = row["fee_g4"].ToString();
objBasic.countryid = row["countryid"].ToString();
objBasic.noofstudent = row["noofstudent"].ToString();
_list.Add(objBasic);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SelectAgencymaster(string ID = "")
{
AgencyRepository objRep = new AgencyRepository();
DataSet ds = objRep.select_Agency_master(TempData.Peek("agencyid").ToString());
TempData.Keep("agencyid");
List <Agencymaster> _list = new List <Agencymaster>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Agencymaster objBasic = new Agencymaster();
objBasic.agencyid = row["agencyid"].ToString();
objBasic.agency_uniq_id = row["agency_uniq_id"].ToString();
objBasic.nameofagency = row["nameofagency"].ToString();
objBasic.agencyaddress = row["agencyaddress"].ToString();
objBasic.email = row["email"].ToString();
objBasic.password = row["password"].ToString();
objBasic.countrycode = row["countrycode"].ToString();
objBasic.mobile = row["mobile"].ToString();
objBasic.typeofagency = row["typeofagency"].ToString();
_list.Add(objBasic);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SaveAgencyDetail(AgencyDetail _obj)
{
AgencyRepository objRepository = new AgencyRepository();
_obj.agencyid = TempData.Peek("agencyid").ToString();
TempData.Keep("agencyid");
DataSet _ds = objRepository.insert_update_agency_detail(_obj);
bool flag = false;
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["Counts"].ToString() == "1")
{
flag = true;
}
}
}
return(Json(new
{
flag = flag
},
JsonRequestBehavior.AllowGet
));
}
public void Dispose()
{
if (AgencyRepository != null)
{
AgencyRepository.Dispose();
AgencyRepository = null;
}
}
public Agency GetAgencyDetail(Guid AgencyId)
{
connectionFactory = ConnectionHelper.GetConnection();
var context = new DbContext(connectionFactory);
var agencyRepository = new AgencyRepository(context);
return(agencyRepository.GetAgencyDetail(AgencyId));
}
public void Dispose()
{
if (BookingRepository != null)
{
BookingRepository.Dispose();
BookingRepository = null;
}
if (TripRepository != null)
{
TripRepository.Dispose();
TripRepository = null;
}
if (CruiseRepository != null)
{
CruiseRepository.Dispose();
CruiseRepository = null;
}
if (AgencyRepository != null)
{
AgencyRepository.Dispose();
AgencyRepository = null;
}
if (BookingRoomRepository != null)
{
BookingRoomRepository.Dispose();
BookingRoomRepository = null;
}
if (BookingHistoryRepository != null)
{
BookingHistoryRepository.Dispose();
BookingHistoryRepository = null;
}
if (LockedRepository != null)
{
LockedRepository.Dispose();
LockedRepository = null;
}
if (CustomerRepository != null)
{
CustomerRepository.Dispose();
CustomerRepository = null;
}
if (UserBLL != null)
{
UserBLL.Dispose();
UserBLL = null;
}
if (SeriesRepository != null)
{
SeriesRepository.Dispose();
SeriesRepository = null;
}
if (BusTypeRepository != null)
{
BusTypeRepository.Dispose();
BusTypeRepository = null;
}
}
public ViewActivitiesBLL()
{
UserRepository = new UserRepository();
ActivityRepository = new ActivityRepository();
AgencyContactRepository = new AgencyContactRepository();
BookingRepository = new BookingRepository();
SeriesRepository = new SeriesRepository();
AgencyRepository = new AgencyRepository();
}
public MainForm()
{
InitializeComponent();
this.UnVisibleAllTextBoxes();
this.agency = new AgencyRepository();
this.client = new ClientRepository();
this.account = new AccountRepository();
this.campaign = new CampaignRepository();
}
public DashBoardManagerBLL()
{
StoreProcedureRepository = new StoreProcedureRepository();
CruiseRepository = new CruiseRepository();
BookingRepository = new BookingRepository();
AgencyRepository = new AgencyRepository();
AgencyContactRepository = new AgencyContactRepository();
ActivityRepository = new ActivityRepository();
UserRepository = new UserRepository();
}
public BookingViewingBLL()
{
MenuRepository = new MenuRepository();
RestaurantBookingRepository = new RestaurantBookingRepository();
AgencyRepository = new AgencyRepository();
CommissionRepository = new CommissionRepository();
ServiceOutsideRepository = new ServiceOutsideRepository();
GuideRepository = new GuideRepository();
AgencyContactRepository = new AgencyContactRepository();
ServiceOutsideDetailRepository = new ServiceOutsideDetailRepository();
}
public BookingViewBLL()
{
BookingRepository = new BookingRepository();
TripRepository = new TripRepository();
CruiseRepository = new CruiseRepository();
AgencyRepository = new AgencyRepository();
BookingRoomRepository = new BookingRoomRepository();
BookingHistoryRepository = new BookingHistoryRepository();
LockedRepository = new LockedRepository();
CustomerRepository = new CustomerRepository();
UserUtil = new UserUtil();
}
public JsonResult SaveAgencymaster(Agencymaster _obj)
{
AgencyRepository objRepository = new AgencyRepository();
SendEmail _objseedemail = new SendEmail();
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
_obj.createdip = localIP;
string password = Membership.GeneratePassword(8, 1);
_obj.password = password;
DataSet _ds = objRepository.insert_update_agency(_obj);
bool flag = false;
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["counts"].ToString() == "1")
{
TempData["agencyid"] = _ds.Tables[0].Rows[0]["id"].ToString();
TempData.Keep("agencyid");
flag = true;
if (_obj.email.ToString() != "")
{
string strform = System.Configuration.ConfigurationManager.AppSettings["Emailusername"];
string Subject = "Agency Registration";
StringBuilder MailBody = new StringBuilder();
MailBody.Append("<br/>Dear " + _obj.nameofagency + ",<br/>");
MailBody.Append("<br/>You have been registered with Study in India as a" + _obj.typeofagency);
MailBody.Append("<br/>Your login credentials are:");
MailBody.Append("<br/>Agency ID: " + _ds.Tables[0].Rows[0]["agency_uniq_id"].ToString());
MailBody.Append("<br/>Password: "******"(System Generated)");
MailBody.Append("<br/><br/><a target='_blank' href='" + FullyQualifiedApplicationPath(ControllerContext.RequestContext.HttpContext.Request) + "GovernmentSchemeAdmission/Login/index' style='color:blue;'>click here</a> to login for the first time and reset your password." + "<br/>");
MailBody.Append("<br/>After resetting the password, kindly login to<a target='_blank' href='https://www.studyinindia.gov.in/channel'>https://www.studyinindia.gov.in/channel</a>");
MailBody.Append("<br/>Please note: This is an auto generated mail.<br/>");
MailBody.Append("<br/>Regards,<br/>");
MailBody.Append("Study in India Cell<br/>");
string bcc = "";
string cc = "";
_objseedemail.SendEmailInBackgroundThread(strform, _obj.email, bcc, cc, Subject, MailBody.ToString(), "", true);
}
}
}
}
return(Json(new
{
flag = flag
},
JsonRequestBehavior.AllowGet
));
}
public virtual void SetUp()
{
ServiceLocatorInitializer.Init();
string[] mappingAssemblies = RepositoryTestsHelper.GetMappingAssemblies();
_configuration = NHibernateSession.Init(new SimpleSessionStorage(), mappingAssemblies,
"../../../../app/wrms.Web/NHibernate.config");
_agencyRepository = new AgencyRepository();
//_requestRepository = new RequestRepository();
//_wrmsSystemRepository = new WrmsSystemRepository();
}
public AdminController()
{
_doctorRepository = new DoctorRepository();
_hospitalRepository = new HospitalRepository();
_bankRepository = new BankRepository();
_agencyRepository = new AgencyRepository();
_specialityRepository = new SpecialityRepository();
_payRateRepository = new PayRateRepository();
_companionTypeRepository = new CompanionTypeRepository();
_companionHistoryRepository = new CompanionHistoryRepository();
_patientHistoryRepository = new PatientHistoryRepository();
}
public AgencyViewBLL()
{
AgencyRepository = new AgencyRepository();
AgencyContractRepository = new AgencyContractRepository();
ContractRepository = new ContractRepository();
QuotationRepository = new QuotationRepository();
AgencyContactRepository = new AgencyContactRepository();
CruiseRepository = new CruiseRepository();
ActivityRepository = new ActivityRepository();
AgencyNotesRepository = new AgencyNotesRepository();
RoleRepository = new RoleRepository();
}
private void frmAgencyAddEdit_Load(object sender, EventArgs e)
{
_agencyRepository = new AgencyRepository(_projectDataContext);
LanguageTranslate.ChangeLanguageForm(this);
if (String.IsNullOrEmpty(_id))
{
Clear();
}
else
{
GetData();
}
}
public AddSeriesBookingsBLL()
{
AgencyRepository = new AgencyRepository();
AgencyContactRepository = new AgencyContactRepository();
SeriesRepository = new SeriesRepository();
TripRepository = new TripRepository();
RoomClassRepository = new RoomClassRepository();
RoomTypeRepository = new RoomTypeRepository();
CruiseRepository = new CruiseRepository();
BookingRepository = new BookingRepository();
BookingRoomRepository = new BookingRoomRepository();
CustomerRepository = new CustomerRepository();
}
public void Dispose()
{
if (RestaurantBookingRepository != null)
{
RestaurantBookingRepository.Dispose();
RestaurantBookingRepository = null;
}
if (AgencyRepository != null)
{
AgencyRepository.Dispose();
AgencyRepository = null;
}
}
public DashBoardBLL()
{
BookingRepository = new BookingRepository();
CruiseRepository = new CruiseRepository();
RoomClassRepository = new RoomClassRepository();
RoomTypeRepository = new RoomTypeRepository();
SailsModule = SailsModule.GetInstance();
ActivityRepository = new ActivityRepository();
AgencyRepository = new AgencyRepository();
AgencyContactRepository = new AgencyContactRepository();
CustomerRepository = new CustomerRepository();
GoldenDayRepository = new GoldenDayRepository();
}
public BookingViewBLL()
{
BookingRepository = new BookingRepository();
TripRepository = new TripRepository();
CruiseRepository = new CruiseRepository();
AgencyRepository = new AgencyRepository();
BookingRoomRepository = new BookingRoomRepository();
BookingHistoryRepository = new BookingHistoryRepository();
LockedRepository = new LockedRepository();
CustomerRepository = new CustomerRepository();
UserBLL = new UserBLL();
SeriesRepository = new SeriesRepository();
BusTypeRepository = new BusTypeRepository();
}
public TransferRequestByDateBLL()
{
RouteRepository = new RouteRepository();
BusTypeRepository = new BusTypeRepository();
AgencyRepository = new AgencyRepository();
RoleRepository = new RoleRepository();
BookingRepository = new BookingRepository();
BusByDateRepository = new BusByDateRepository();
BookingBusByDateRepository = new BookingBusByDateRepository();
LockingTransferRepository = new LockingTransferRepository();
ExpenseRepository = new ExpenseRepository();
ExpenseServiceRepository = new ExpenseServiceRepository();
CostTypeRepository = new CostTypeRepository();
GuideRepository = new GuideRepository();
}
public void Setup()
{
var options = new DbContextOptionsBuilder <FieldAgentContext>()
.UseInMemoryDatabase("testDatabase")
.Options;
db = new FieldAgentContext(options);
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
db.SaveChanges();
agencyRepo = new AgencyRepository(db);
agencyagentRepo = new AgencyAgentRepository(db);
missionRepo = new MissionRepository(db);
}
public void Dispose()
{
if (BookingRepository != null)
{
BookingRepository.Dispose();
BookingRepository = null;
}
if (TripRepository != null)
{
TripRepository.Dispose();
TripRepository = null;
}
if (CruiseRepository != null)
{
CruiseRepository.Dispose();
CruiseRepository = null;
}
if (AgencyRepository != null)
{
AgencyRepository.Dispose();
AgencyRepository = null;
}
if (BookingRoomRepository != null)
{
BookingRoomRepository.Dispose();
BookingRoomRepository = null;
}
if (BookingHistoryRepository != null)
{
BookingHistoryRepository.Dispose();
BookingHistoryRepository = null;
}
if (LockedRepository != null)
{
LockedRepository.Dispose();
LockedRepository = null;
}
if (CustomerRepository != null)
{
CustomerRepository.Dispose();
CustomerRepository = null;
}
if (UserUtil != null)
{
UserUtil.Dispose();
UserUtil = null;
}
}
public void Dispose()
{
if (AgencyRepository != null)
{
AgencyRepository.Dispose();
AgencyRepository = null;
}
if (AgencyContractRepository != null)
{
AgencyContractRepository.Dispose();
AgencyContractRepository = null;
}
if (ContractRepository != null)
{
ContractRepository.Dispose();
ContractRepository = null;
}
if (QuotationRepository != null)
{
QuotationRepository.Dispose();
QuotationRepository = null;
}
if (AgencyContactRepository != null)
{
AgencyContactRepository.Dispose();
AgencyContactRepository = null;
}
if (CruiseRepository != null)
{
CruiseRepository.Dispose();
CruiseRepository = null;
}
if (ActivityRepository != null)
{
ActivityRepository.Dispose();
ActivityRepository = null;
}
if (AgencyNotesRepository != null)
{
AgencyNotesRepository.Dispose();
AgencyNotesRepository = null;
}
if (RoleRepository != null)
{
RoleRepository.Dispose();
RoleRepository = null;
}
}
public void Dispose()
{
if (BookingRepository != null)
{
BookingRepository.Dispose();
BookingRepository = null;
}
if (CruiseRepository != null)
{
CruiseRepository.Dispose();
CruiseRepository = null;
}
if (RoomClassRepository != null)
{
RoomClassRepository.Dispose();
RoomClassRepository = null;
}
if (RoomTypeRepository != null)
{
RoomTypeRepository.Dispose();
RoomTypeRepository = null;
}
if (ActivityRepository != null)
{
ActivityRepository.Dispose();
ActivityRepository = null;
}
if (AgencyRepository != null)
{
AgencyRepository.Dispose();
AgencyRepository = null;
}
if (AgencyContactRepository != null)
{
AgencyContactRepository.Dispose();
AgencyContactRepository = null;
}
if (CustomerRepository != null)
{
CustomerRepository.Dispose();
CustomerRepository = null;
}
if (GoldenDayRepository != null)
{
GoldenDayRepository.Dispose();
GoldenDayRepository = null;
}
}
public BookingReportBLL()
{
BookingRepository = new BookingRepository();
CruiseRepository = new CruiseRepository();
ExpenseRepository = new ExpenseRepository();
AgencyRepository = new AgencyRepository();
UserRepository = new UserRepository();
ExpenseHistoryRepository = new ExpenseHistoryRepository();
CostTypeRepository = new CostTypeRepository();
ExpenseServiceRepository = new ExpenseServiceRepository();
LockingExpenseRepository = new LockingExpenseRepository();
BookingHistoryRepository = new BookingHistoryRepository();
BookingRoomRepository = new BookingRoomRepository();
CustomerRepository = new CustomerRepository();
AgencyNotesRepository = new AgencyNotesRepository();
}
/// <summary>
/// When implemented in a derived class, executes the scheduled job asynchronously. Implementations that want to know whether
/// the scheduled job is being cancelled can get a <see cref="P:Microsoft.WindowsAzure.Mobile.Service.ScheduledJob.CancellationToken"/> from the <see cref="M:CancellationToken"/> property.
/// </summary>
/// <returns>
/// A <see cref="T:System.Threading.Tasks.Task"/> representing the asynchronous operation.
/// </returns>
public override async Task ExecuteAsync()
{
// Load Feed Message
var dbConnStr = ConfigurationManager.ConnectionStrings["MTA_DB"].ConnectionString;
var service = new StaticFileService(new StaticFileDownloader());
StringBuilder sb = new StringBuilder();
List<string> tableNames = new List<string>()
{
"agency",
"calendar",
"calendar_dates",
"shapes",
"stop_times",
"transfers",
"trips",
"routes",
"stops",
};
tableNames.ForEach(s => sb.AppendFormat("TRUNCATE TABLE {0};", s));
using (var conn = new SqlConnection(dbConnStr))
{
using (var cmd = new SqlCommand(sb.ToString(), conn))
{
conn.Open();
cmd.ExecuteNonQuery();
}
//Agency
using (var repository = new AgencyRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetAgencies());
}
// using (var repository = new CalendarDateRepository(dbConnStr))
// {
// // Load Tables
// repository.AddRange(service.GetCalendarDates());
// }
//Calendars
using (var repository = new CalendarRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetCalendars());
}
//Route
using (var repository = new RouteRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetRoutes());
}
//Shape
using (var repository = new ShapeRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetShapes());
}
//Stop
using (var repository = new StopRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetStops());
}
//Stop Time
using (var repository = new StopTimeRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetStopTimes());
}
//Transfer
using (var repository = new TransferRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetTransfers());
}
//Trip
using (var repository = new TripRepository() {Connection = conn})
{
// Load Tables
repository.AddRange(await service.GetTrips());
}
// Build Stations
using (var cmd = new SqlCommand("sp_BuildStations", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
// conn.Open();
cmd.ExecuteNonQuery();
}
using (var cmd = new SqlCommand("sp_CreateStaticSchedule", conn))
{
cmd.CommandTimeout = 120;
cmd.CommandType = CommandType.StoredProcedure;
// conn.Open();
TimeZoneInfo easternZone = TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time");
DateTime easternTimeNow = TimeZoneInfo.ConvertTime(DateTime.UtcNow, TimeZoneInfo.Utc,
easternZone);
cmd.Parameters.AddWithValue("@today", easternTimeNow);
cmd.ExecuteNonQuery();
}
}
}
