public IList GetByHQL(string hql, ArrayList lists)
{
try
{
ISession session = HibernateUtil.OpenSession();
IQuery query = session.CreateQuery(hql);
for (int i = 0; i < lists.Count; i++)
{
query.SetParameter(i, lists[i]);
}
return(query.List());
}
catch (Exception ex)
{
throw ex;
}
finally
{
HibernateUtil.CloseSession();
}
return(null);
}
public FirstSetupRepo()
{
this.session = HibernateUtil.OpenSession(false);
this.userRepo = new UserRepository(session);
this.projectRepo = new ProjectRepository(session);
this.certificateTypeRepo = new InspectorCertificateTypeRepository(session);
this.seemTypeRepo = new SeamTypeRepository(session);
this.permissionRepo = new PermissionRepository(session);
this.roleRepo = new RoleRepository(session);
this.categoryRepo = new CategoryRepository(session);
this.jointOperationRepo = new JointOperationRepository(session);
this.pipeTestsRepo = new PipeTestRepository(session);
this.sizeTypeRepo = new MillPipeSizeTypeRepository(session);
this.plateManRepo = new PlateManufacturerRepository(session);
this.heatRepo = new HeatRepository(session);
this.plateRepo = new PlateRepository(session);
this.purchaseRepo = new PurchaseOrderRepository(session);
this.railRepo = new RailcarRepository(session);
this.pipeRepo = new PipeRepository(session);
this.inspectorRepo = new InspectorRepository(session);
this.pipeTestResultRepo = new PipeTestResultRepository(session);
this.welderRepo = new WelderRepository(session);
componentTypeRepo = new ComponentTypeRepository(session);
componentRepo = new ComponentRepository(session);
releaseRepo = new ReleaseNoteRepository(session);
this.cannedMessageRepo = new CannedMessageRepository(session);
}
public ActionResult Index()
{
using (ISession session = HibernateUtil.OpenSession())
{
ViewData["employees"] = session.QueryOver <Employee>().List();
}
return(View("Home"));
}
public static void LogOptimize()
{
string connectionString = ConfigurationManager.ConnectionStrings["PrismDatabase"].ConnectionString;
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(connectionString);
string database = builder.InitialCatalog;
string logName = database + "_log";
string query = string.Format(@"checkpoint; DBCC SHRINKFILE ({0});", logName);
using (var session = HibernateUtil.OpenSession(false))
{
session.CreateSQLQuery(query).ExecuteUpdate();
}
}
public ActionResult AddEmployee([Bind()] Employee employee)
{
if (!ModelState.IsValid)
{
return(Json(new { Result = "fail", Errors = CollectErrors() }));
}
using (ISession session = HibernateUtil.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
session.SaveOrUpdate(employee);
transaction.Commit();
}
session.Close();
}
return(Json(new { Result = "ok", Id = employee.Id }));
}
public ActionResult RemoveEmployee()
{
string id = Request.Params["Id"];
try
{
using (var session = HibernateUtil.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
session.Delete(string.Format("from {0} where id = {1}", typeof(Employee), Convert.ToInt32(id)));
transaction.Commit();
}
session.Close();
}
return(Json(new { Result = "ok" }));
}
catch (FormatException e)
{
return(Json(new { Result = "fail" }));
}
}
public override void Load()
{
#region Repository
Bind <ISession>().ToMethod(_ => HibernateUtil.OpenSession(true));
Bind <IReleaseNoteRepository>().To <ReleaseNoteRepository>();
Bind <IRailcarRepository>().To <RailcarRepository>();
Bind <IPipeRepository>().To <PipeRepository>();
Bind <IHeatRepository>().To <HeatRepository>();
Bind <IPlateRepository>().To <PlateRepository>();
Bind <IAuditLogRepository>().To <AuditLogRepository>();
Bind <IPurchaseOrderRepository>().To <PurchaseOrderRepository>();
Bind <IWeldRepository>().To <WeldRepository>();
Bind <IWelderRepository>().To <WelderRepository>();
Bind <IPipeTestResultRepository>().To <PipeTestResultRepository>();
Bind <IMillPipeSizeTypeRepository>().To <MillPipeSizeTypeRepository>();
Bind <IPipeTestRepository>().To <PipeTestRepository>();
Bind <IMillRepository>().To <MillRepository>();
Bind <IJointOperationRepository>().To <JointOperationRepository>();
Bind <ISettingsRepositories>().To <SettingsRepositories>();
Bind <IReleaseNoteRepositories>().To <ReleaseNoteRepositories>();
Bind <IHeatRepositories>().To <HeatRepositories>();
Bind <IProjectRepository>().To <ProjectRepository>();
Bind <ICategoryRepository>().To <CategoryRepository>();
Bind <IMillReportsRepository>().To <MillReportsRepository>();
Bind <IUserRepository>().To <UserRepository>();
Bind <IRoleRepository>().To <RoleRepository>();
Bind <IPermissionRepository>().To <PermissionRepository>();
Bind <IConstructionRepository>().To <ConstructionRepository>();
Bind <IJointRepository>().To <JointRepository>();
Bind <IFirstSetupRepo>().To <FirstSetupRepo>();
Bind <IComponentRepositories>().To <ComponentRepositories>();
Bind <IComponentTypeRepository>().To <ComponentTypeRepository>();
Bind <IComponentRepository>().To <ComponentRepository>();
Bind <ISpoolRepository>().To <SpoolRepository>();
Bind <ISpoolRepositories>().To <SpoolRepositories>();
Bind <IJointTestResultRepository>().To <JointTestResultRepository>();
Bind <IJointWeldResultRepository>().To <JointWeldResultRepository>();
Bind <IInspectorRepository>().To <InspectorRepository>();
Bind <IFileRepository>().To <FileRepository>();
Bind <IInspectionTestResultRepository>().To <InspectionTestResultRepository>();
Bind <IPartInspectionRepository>().To <PartInspectionRepository>();
Bind <INotificationRepository>().To <NotificationRepository>();
Bind <IPortionRepository>().To <PortionRepository>();
Bind <IExportRepository>().To <ExportRepository>();
Bind <IImportRepository>().To <ImportRepository>();
Bind <IExternalFilesRepositories>().To <ExternalFilesRepositories>();
Bind <ICannedMessageRepository>().To <CannedMessageRepository>();
// TODO: remove TemporaryContext after binding to real context.
Bind <Prizm.Main.Security.ISecurityContext>().To <SecurityContext>().InSingletonScope();
#endregion
#region ViewModel
Bind <HeatViewModel>().ToSelf();
Bind <PurchaseOrderViewModel>().ToSelf();
Bind <ReleaseNoteViewModel>().ToSelf();
Bind <MillPipeSearchViewModel>().ToSelf();
Bind <MillPipeNewEditViewModel>().ToSelf();
Bind <ReleaseNoteSearchViewModel>().ToSelf();
Bind <SettingsViewModel>().ToSelf();
Bind <MillReportsViewModel>().ToSelf();
Bind <PrizmApplicationViewModel>().ToSelf();
Bind <JointNewEditViewModel>().ToSelf();
Bind <JointSearchViewModel>().ToSelf();
Bind <PartSearchViewModel>().ToSelf();
Bind <FirstSetupViewModel>().ToSelf();
Bind <SpoolViewModel>().ToSelf();
Bind <ExternalFilesViewModel>().ToSelf();
Bind <PipeConstractionReportViewModel>().ToSelf();
Bind <WeldDateReportViewModel>().ToSelf();
#endregion
#region Forms Binding
Bind <MillPipeNewEditXtraForm>().ToSelf();
Bind <ReleaseNoteNewEditXtraForm>().ToSelf();
Bind <MillPipeSearchXtraForm>().ToSelf();
Bind <MillReportsXtraForm>().ToSelf();
Bind <ComponentNewEditXtraForm>().ToSelf();
Bind <InspectionReportsXtraForm>().ToSelf();
Bind <JointNewEditXtraForm>().ToSelf();
Bind <JointSearchXtraForm>().ToSelf();
Bind <ConstructionReportsXtraForm>().ToSelf();
Bind <SettingsXtraForm>().ToSelf();
Bind <ReleaseNoteSearchXtraForm>().ToSelf();
Bind <SpoolsXtraForm>().ToSelf();
Bind <HeatXtraForm>().ToSelf();
Bind <PurchaseOrderXtraForm>().ToSelf();
Bind <AuditXtraForm>().ToSelf();
Bind <PartSearchXtraForm>().ToSelf();
Bind <FirstSetupXtraForm>().ToSelf();
Bind <ExternalFilesXtraForm>().ToSelf();
Bind <ExportForm>().ToSelf();
Bind <ImportForm>().ToSelf();
Bind <PipeConstractionReportXtraForm>().ToSelf();
Bind <WeldDateReportXtraForm>().ToSelf();
#endregion
#region Commands
Bind <JointSearchCommand>().ToSelf();
#endregion
Bind <IUserNotify>().To <PrizmApplicationXtraForm>().InSingletonScope();
Bind <AuditInterceptor>().ToSelf();
#region Synch
Bind <IEncryptor>().To <Encryptor>();
Bind <IHasher>().To <Hasher>();
#endregion
}
