//secur#6
protected override void CreateDefaultObjectSpaceProvider(CreateCustomObjectSpaceProviderEventArgs args)
{
IObjectSpaceProvider provider;
if (dxTestSolution.Module.dxTestSolutionModule.UseInMemoryStore)
{
provider = new XPObjectSpaceProvider(InMemoryDataStoreProvider.ConnectionString, null, false);
}
else
{
provider = new XPObjectSpaceProvider(XPObjectSpaceProvider.GetDataStoreProvider(args.ConnectionString, args.Connection, true), false);
}
//secur#9
args.ObjectSpaceProviders.Add(provider);
args.ObjectSpaceProviders.Add(new NonPersistentObjectSpaceProvider(TypesInfo, null));
}
private void Initialize(IEnumerable <ModuleBase> modules, IEnumerable <Type> domainComponents)
{
ModuleList moduleList = new ModuleList();
foreach (ModuleBase module in modules)
{
moduleList.Add(module);
}
objectSpaceProvider = new XPObjectSpaceProvider(new MemoryDataStoreProvider(), true);
ExpressApplicationSetupParameters parameters = new ExpressApplicationSetupParameters("test app",
objectSpaceProvider,
new ControllersManager(),
moduleList);
parameters.DomainComponents = domainComponents != null ? domainComponents : Type.EmptyTypes;
Setup(parameters);
}
public static void WczytajKursy(List <Notowanie> res)
{
if (res != null)
{
using (XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(AppSettings.ConnectionString, null))
{
using (IObjectSpace directObjectSpace = directProvider.CreateObjectSpace())
{
XafTypesInfo.Instance.RegisterEntity(typeof(KursWaluty));
XafTypesInfo.Instance.RegisterEntity(typeof(Waluta));
WczytajKursy(directObjectSpace, res);
directObjectSpace.CommitChanges();
}
}
}
}
public HttpResponseMessage Activity_Sup()
{
try
{
string ObjectTypeOid = "a29d77a9-4bcb-4774-9744-ff97a373353e";
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(Activity));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <activitySub_Model> list = new List <activitySub_Model>();
List <activityDetails_Model> detail = new List <activityDetails_Model>();
IList <Activity> collection = ObjectSpace.GetObjects <Activity>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and MasterActivity = '" + ObjectTypeOid + "' ", null));
{
if (collection.Count > 0)
{
foreach (Activity row in collection)
{
activitySub_Model Item = new activitySub_Model();
Item.SubActivityLevelOid = row.Oid.ToString();
Item.SubActivityLevelName = row.ActivityName;
list.Add(Item);
}
}
else
{ //invalid
UserError err = new UserError();
err.status = "false";
err.code = "0";
err.message = "กรุณาใส่ข้อมูลให้เรียบร้อย";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public byte[] PrintReports(string ReportName, string CompanyId)
{
using (XPObjectSpaceProvider objectSpaceProvider = CreateObjectSpaceProvider(CompanyId))
{
IObjectSpace objectSpace = objectSpaceProvider.CreateObjectSpace();
//ReportData reportData = objectSpace.FindObject<ReportData>(new BinaryOperator("Name", "Invoice"));
//ReportData reportData = objectSpace.FindObject<ReportData>(new BinaryOperator("DisplayName", ReportName));
ReportDataV2 reportData = objectSpace.FindObject <ReportDataV2>(new BinaryOperator("DisplayName", ReportName));
//ReportDataV2 reportData = objectSpace.GetObjectByKey<ReportDataV2>(Guid.Parse("9D1BD93A-5E61-4193-A8FF-190916AFF298"));
return(ExportReport(reportData, objectSpaceProvider, string.Empty, objectSpace));
}
}
public IHttpActionResult insertsdemo_Webapi()
{
string UserName = "";
XPObjectSpaceProvider osProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace objectSpace = osProvider.CreateObjectSpace();
UserInfo ObjInUser;
XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo));
ObjInUser = objectSpace.CreateObject <UserInfo>();
ObjInUser.UserName = UserName;
objectSpace.CommitChanges();
return(Ok(ObjInUser));
}
void application_CreateCustomObjectSpaceProvider(object sender, CreateCustomObjectSpaceProviderEventArgs e)
{
XafApplication application = (XafApplication)sender;
if (objectSpaceProvider2 == null)
{
XpoTypeInfoSource typeInfoSource2 = new XpoTypeInfoSource((TypesInfo)application.TypesInfo,
typeof(PersistentClass2), typeof(ModuleInfo2)
);
objectSpaceProvider2 = new XPObjectSpaceProvider(
new ConnectionStringDataStoreProvider(ConfigurationManager.ConnectionStrings["ConnectionStringDatabase2"].ConnectionString),
application.TypesInfo,
typeInfoSource2, true
);
}
e.ObjectSpaceProviders.Add(objectSpaceProvider2);
}
public IHttpActionResult SupplierProduct()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(SupplierProduct));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <SupplierProduct_Model> list = new List <SupplierProduct_Model>();
IList <SupplierProduct> collection = ObjectSpace.GetObjects <SupplierProduct>(CriteriaOperator.Parse("GCRecord is null "));
if (collection.Count > 0)
{
foreach (SupplierProduct row in collection)
{
SupplierProduct_Model supplier = new SupplierProduct_Model();
supplier.LotNumber = row.LotNumber;
supplier.FinanceYearOid = row.FinanceYearOid.YearName;
supplier.BudgetSourceOid = row.BudgetSourceOid.BudgetName;
supplier.AnimalSeedOid = row.AnimalSeedOid.SeedName;
supplier.AnimalSeedLevelOid = row.AnimalSeedLevelOid.SeedLevelName;
supplier.PlotHeaderOid = row.PlotInfoOidOid.PlotName;
supplier.Weight = Convert.ToDouble(row.Weight);
supplier.UnitOid = row.UnitOid.UnitName;
supplier.LastCleansingDate = row.LastCleansingDate;
supplier.Status = row.Status.ToString();
supplier.Used = row.Used;
supplier.ReferanceUsed = row.ReferanceUsed;
supplier.PlotInfoOidOid = row.PlotInfoOidOid.PlotName;
supplier.FormType = row.FormType.ToString();
supplier.SeedTypeOid = row.SeedTypeOid.SeedTypeName;
list.Add(supplier);
}
return(Ok(list));
}
else
{
return(BadRequest("NoData"));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public HttpResponseMessage AnimalSupplieType_list()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(AnimalSupplieType));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
IList <AnimalSupplieType> collection = ObjectSpace.GetObjects <AnimalSupplieType>(CriteriaOperator.Parse(" GCRecord is null and IsActive = 1", null));
if (collection.Count > 0)
{
List <AnimalSupplieType_Model> list = new List <AnimalSupplieType_Model>();
foreach (AnimalSupplieType row in collection)
{
AnimalSupplieType_Model item = new AnimalSupplieType_Model();
item.AnimalSupplieTypeOid = row.Oid.ToString();
item.SupplietypeName = row.SupplietypeName;
item.AnimalSupplieName = row.AnimalSupplie.AnimalSupplieName;
item.SalePrice = row.SalePrice;
list.Add(item);
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
else
{
UserError err = new UserError();
err.code = "-1"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "ไม่พบข้อมูล";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public void SetUp()
{
XPObjectSpaceProvider objectSpaceProvider =
new XPObjectSpaceProvider(new MemoryDataStoreProvider());
TestApplication application = new TestApplication();
ModuleBase testModule = new ModuleBase();
testModule.AdditionalExportedTypes.Add(typeof(MyPerson));
application.Modules.Add(testModule);
application.Modules.Add(new ConditionalAppearanceModule());
application.Setup("TestApplication", objectSpaceProvider);
IObjectSpace objectSpace = objectSpaceProvider.CreateObjectSpace();
person = objectSpace.CreateObject <MyPerson>();
target = new FakeAppearanceTarget();
controller = new AppearanceController();
detailView = application.CreateDetailView(objectSpace, person);
controller.SetView(detailView);
}
public void OneTimeSetUp()
{
XpoDefault.Session = null;
connectionString = InMemoryDataStoreProvider.ConnectionString;
directProvider = new XPObjectSpaceProvider(connectionString, null);
objectSpace = directProvider.CreateObjectSpace();
XafTypesInfo.Instance.RegisterEntity(typeof(Produkt));
XafTypesInfo.Instance.RegisterEntity(typeof(PozycjaFaktury));
XafTypesInfo.Instance.RegisterEntity(typeof(StawkaVAT));
var gacie = objectSpace.CreateObject <Produkt>();
gacie.Cena = 100;
gacie.Nazwa = "Gacie";
var stawka23 = objectSpace.CreateObject <StawkaVAT>();
stawka23.Symbol = "23%";
stawka23.Stawka = 23;
gacie.StawkaVAT = stawka23;
var skarpetki = objectSpace.CreateObject <Produkt>();
skarpetki.Cena = 33.33m;
skarpetki.Nazwa = "Skarpetki";
var stawka7 = objectSpace.CreateObject <StawkaVAT>();
stawka7.Symbol = "7%";
stawka7.Stawka = 7;
skarpetki.StawkaVAT = stawka7;
var skarpety = objectSpace.CreateObject <Produkt>();
skarpety.Cena = 27.77m;
skarpety.Nazwa = "Skarpety";
skarpety.StawkaVAT = stawka7;
objectSpace.CommitChanges();
}
public HttpResponseMessage Count_NumberAccepet()
{
try
{
string OrganizationOid = HttpContext.Current.Request.Form["OrganizationOid"].ToString();
SqlConnection objConn = new SqlConnection(scc);
if (objConn.State != ConnectionState.Open)
{
objConn.Open();
}
DataSet ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "SP_CountNumber_Approve", new SqlParameter("@OrganizationOid", OrganizationOid));
if (ds.Tables[0].Rows.Count > 0)
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(Organization));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
Organization Organization = ObjectSpace.FindObject <Organization>(CriteriaOperator.Parse("GCRecord is null and Oid =?", OrganizationOid));
Count_Number number = new Count_Number();
number.OrganizationName = Organization.OrganizeNameTH;
number.CountNumber = (int)ds.Tables[0].Rows[0]["Count_Total"];
directProvider.Dispose();
ObjectSpace.Dispose();
return(Request.CreateResponse(HttpStatusCode.OK, number));
}
else
{
UserError err = new UserError();
err.code = "-1"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "ไม่พบข้อมูลรายการ";
return(Request.CreateResponse(HttpStatusCode.NotFound, err));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
private IXpoDataStoreProvider GetDataStoreProvider(string connectionString, System.Data.IDbConnection connection)
{
System.Web.HttpApplicationState application = (System.Web.HttpContext.Current != null) ? System.Web.HttpContext.Current.Application : null;
IXpoDataStoreProvider dataStoreProvider = null;
if (application != null && application["DataStoreProvider"] != null)
{
dataStoreProvider = application["DataStoreProvider"] as IXpoDataStoreProvider;
}
else
{
dataStoreProvider = XPObjectSpaceProvider.GetDataStoreProvider(connectionString, connection, true);
if (application != null)
{
application["DataStoreProvider"] = dataStoreProvider;
}
}
return(dataStoreProvider);
}
public HttpResponseMessage GetBudget_Info()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(BudgetSource));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
IList <BudgetSource> collection = ObjectSpace.GetObjects <BudgetSource>(CriteriaOperator.Parse(" GCRecord is null and IsActive = 1", null));
if (collection.Count > 0)
{
List <BudgetSourceModel> list = new List <BudgetSourceModel>();
foreach (BudgetSource row in collection)
{
BudgetSourceModel budget_type = new BudgetSourceModel();
budget_type.BudgetSourceOid = row.Oid;
budget_type.BudgetName = row.BudgetName;
list.Add(budget_type);
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
else
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "No data";
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
finally
{
}
}
private IXpoDataStoreProvider GetDataStoreProvider(string connectionString, IDbConnection connection)
{
var application = HttpContext.Current != null ? HttpContext.Current.Application : null;
IXpoDataStoreProvider dataStoreProvider;
if (application?["DataStoreProvider"] != null)
{
dataStoreProvider = application["DataStoreProvider"] as IXpoDataStoreProvider;
}
else
{
dataStoreProvider = XPObjectSpaceProvider.GetDataStoreProvider(connectionString, connection, true);
if (application != null)
{
application["DataStoreProvider"] = dataStoreProvider;
}
}
return(dataStoreProvider);
}
public static XafReport LoadXafReport(ReportData report, object obj)
{
var connectionString = GeneratorHelper.GetConnectionString();
//using (var connection = new SqlConnection(connectionString))
//{
var objectSpaceProvider = new XPObjectSpaceProvider(connectionString, XpoDefault.DataLayer.Connection);
var objectSpace = objectSpaceProvider.CreateObjectSpace() as XPObjectSpace;
var type = GeneratorHelper.GetMyObjectType(report.DataTypeName);
var classInfo = objectSpace?.Session.GetClassInfo(type);
var key = classInfo?.KeyProperty;
XafTypesInfo.Instance.RegisterEntity(type);
var xafReport = report.LoadReport(objectSpace) as XafReport;
xafReport.Filtering.Filter = string.Format("{0}={1}", key.Name, key.GetValue(obj));
xafReport.ApplyFiltering();
return(xafReport);
//}
}
public HttpResponseMessage GetBudget_Year()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(FinanceYear));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
IList <FinanceYear> collection = ObjectSpace.GetObjects <FinanceYear>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1", null));
var Qurey = (from Q in collection orderby Q.YearName descending select Q);
if (collection.Count > 0)
{
List <FinanceYearModel> list = new List <FinanceYearModel>();
foreach (FinanceYear row in Qurey)
{
FinanceYearModel Finance = new FinanceYearModel();
Finance.FinanceYearOid = row.Oid.ToString();
Finance.FinanceYear = row.YearName;
list.Add(Finance);
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
else
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "No data";
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public IHttpActionResult xafclass()
{
// Farmerinfo.Profile_Farmer farmerinfo = new Farmerinfo.Profile_Farmer();
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(Farmer));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <Farmerinfo.Profile_Farmer> ilist = new List <Farmerinfo.Profile_Farmer>();
IList <Farmer> collection = ObjectSpace.GetObjects <Farmer>(CriteriaOperator.Parse(" GCRecord is null and IsActive = true", null));
if (collection != null)
{
foreach (Farmer row in collection)
{
Farmerinfo.Profile_Farmer _farmerinfo = new Farmerinfo.Profile_Farmer();
_farmerinfo.Oid = row.Oid;
_farmerinfo.CitizenID = row.CitizenID;
_farmerinfo.Title = row.TitleOid.TitleName;
_farmerinfo.FirstNameTH = row.FirstNameTH;
_farmerinfo.LastNameTH = row.LastNameTH;
ilist.Add(_farmerinfo);
}
}
else
{
return(BadRequest("Any object"));
}
return(Ok(ilist));
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
// Return resual
// return BadRequest(ex.Message);
return(null);
}
}
public HttpResponseMessage FarmerProduction_XAF()
{
try
{
XpoTypesInfoHelper.GetTypesInfo();
XafTypesInfo.Instance.RegisterEntity(typeof(FarmerProduction));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
IList <FarmerProduction> collection = ObjectSpace.GetObjects <FarmerProduction>(CriteriaOperator.Parse(" GCRecord is null and IsActive = 1", null));
if (collection != null)
{
List <user.FarmerProductionModel> list = new List <user.FarmerProductionModel>();
foreach (FarmerProduction row in collection)
{
user.FarmerProductionModel productionModel = new user.FarmerProductionModel();
productionModel.Oid = row.Oid;
productionModel.Production = row.AnimalSeedOid.SeedName;
list.Add(productionModel);
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
else
{
UserError err = new UserError();
err.code = ""; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "No data";
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{ //Error case เกิดข้อผิดพลาด
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
// Return resual
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public static IXpoDataStoreProvider GetDataStoreProvider(string connectionString, IDbConnection connection, bool enablePoolingInConnectionString = true)
{
IXpoDataStoreProvider xpoDataStoreProvider = null;
if (UseSQLAlternativeInfoSingleton.Instance.UseAlternative || (connectionString == InMemoryDataStoreProvider.ConnectionString))
{
xpoDataStoreProvider = DemoXPODatabaseHelper.GetInMemoryDataStoreProvider(enablePoolingInConnectionString);
}
else
{
if ((connection != null) || DemoDbEngineDetectorHelper.IsSqlServerAccessible(connectionString))
{
xpoDataStoreProvider = XPObjectSpaceProvider.GetDataStoreProvider(connectionString, connection, enablePoolingInConnectionString);
}
else
{
UseSQLAlternativeInfoSingleton.Instance.FillFields(DemoDbEngineDetectorHelper.DBServerIsNotAccessibleMessage, DemoXPODatabaseHelper.AlternativeName, DemoXPODatabaseHelper.InMemoryDatabaseUsageMessage);
xpoDataStoreProvider = DemoXPODatabaseHelper.GetInMemoryDataStoreProvider(enablePoolingInConnectionString);
}
}
return(xpoDataStoreProvider);
}
static void Main()
{
try {
Console.WriteLine("Starting...");
ValueManager.ValueManagerType = typeof(MultiThreadValueManager <>).GetGenericTypeDefinition();
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(Employee));
XafTypesInfo.Instance.RegisterEntity(typeof(PermissionPolicyUser));
XafTypesInfo.Instance.RegisterEntity(typeof(PermissionPolicyRole));
string connectionString = @"Integrated Security=SSPI;Pooling=false;Data Source=(localdb)\mssqllocaldb;Initial Catalog=ClientServer";
Console.WriteLine("Creating default objects...");
XPObjectSpaceProvider objectSpaceProvider = new XPObjectSpaceProvider(connectionString);
objectSpaceProvider.CheckCompatibilityType = CheckCompatibilityType.DatabaseSchema;
objectSpaceProvider.SchemaUpdateMode = SchemaUpdateMode.DatabaseAndSchema;
IObjectSpace objectSpace = objectSpaceProvider.CreateUpdatingObjectSpace(true);
CreateUsers(objectSpace);
CreateObjects(objectSpace);
objectSpace.CommitChanges();
Console.WriteLine("Starting server...");
Func <IDataServerSecurity> securityProviderHandler = () => new SecurityStrategyComplex(typeof(PermissionPolicyUser), typeof(PermissionPolicyRole), new AuthenticationStandard());
ServiceHost serviceHost = new WcfXafServiceHost(connectionString, securityProviderHandler);
serviceHost.AddServiceEndpoint(typeof(IWcfXafDataServer), WcfDataServerHelper.CreateNetTcpBinding(), "net.tcp://localhost:1424/DataServer");
serviceHost.Open();
Console.WriteLine("Server is started. Press Enter to stop.");
Console.ReadLine();
Console.WriteLine("Stopping...");
serviceHost.Close();
Console.WriteLine("Server is stopped.");
}
catch (Exception e) {
Console.WriteLine("Exception occurs: " + e.Message);
Console.WriteLine("Press Enter to close.");
Console.ReadLine();
}
}
void application_CreateCustomObjectSpaceProvider(object sender, CreateCustomObjectSpaceProviderEventArgs e)
{
XafApplication application = (XafApplication)sender;
if (typeInfoSource1 == null)
{
lock (lockObj) {
if (typeInfoSource1 == null)
{
typeInfoSource1 = new XpoTypeInfoSource((TypesInfo)application.TypesInfo,
typeof(PersistentClass1), typeof(ModuleInfo1)
);
}
}
}
XPObjectSpaceProvider objectSpaceProvider1 = new XPObjectSpaceProvider(
new ConnectionStringDataStoreProvider(ConfigurationManager.ConnectionStrings["ConnectionStringDatabase1"].ConnectionString),
application.TypesInfo,
typeInfoSource1, true
);
e.ObjectSpaceProviders.Add(objectSpaceProvider1);
}
public virtual void SetUp()
{
XPObjectSpaceProvider objectSpaceProvider =
new XPObjectSpaceProvider(new MemoryDataStoreProvider());
TestApplication application = new TestApplication();
var testModule = new FirstXafProjectModule();
application.Modules.Add(testModule);
//application.Modules.Add(new ConditionalAppearanceModule());
application.Setup("TestApplication", objectSpaceProvider);
IObjectSpace objectSpace = objectSpaceProvider.CreateObjectSpace();
var Customer = objectSpace.CreateObject <XafCustomer>();
controller = new InvoiceController();
detailView = application.CreateDetailView(objectSpace, Customer);
controller.SetView(detailView);
}
public IHttpActionResult OrderseedDetail(string SendOrderSeed)
{
OrderSeedDetail OrderSeedDetail = new OrderSeedDetail();
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(SendOrderSeedDetail));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
SendOrderSeedDetail OrderSeed;
OrderSeed = ObjectSpace.FindObject <SendOrderSeedDetail>(new BinaryOperator("SendOrderSeed", SendOrderSeed));
if (SendOrderSeed != null)
{
OrderSeedDetail.LotNumber = OrderSeed.LotNumber.LotNumber;
OrderSeedDetail.WeightUnit = OrderSeed.WeightUnitOid.UnitName;
OrderSeedDetail.AnimalSeedCode = OrderSeed.AnimalSeedCode;
OrderSeedDetail.AnimalSeeName = OrderSeed.AnimalSeeName;
OrderSeedDetail.AnimalSeedLevel = OrderSeed.AnimalSeedLevel;
OrderSeedDetail.BudgetSource = OrderSeed.BudgetSourceOid.BudgetName;
OrderSeedDetail.Weight = OrderSeed.Weight;
OrderSeedDetail.Used = OrderSeed.Used;
OrderSeedDetail.SendOrderSeed = OrderSeed.SendOrderSeed.SendNo;
return(Ok(OrderSeedDetail));
}
{
return(BadRequest("NoData"));
}
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult SupplierSend()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(SupplierSend));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <SupplierSend_Model> list = new List <SupplierSend_Model>();
IList <SupplierSend> collection = ObjectSpace.GetObjects <SupplierSend>(CriteriaOperator.Parse("GCRecord is null "));
if (collection.Count > 0)
{
foreach (SupplierSend row in collection)
{
SupplierSend_Model Model = new SupplierSend_Model();
Model.SendNo = row.SendNo;
Model.CreateDate = row.CreateDate;
Model.FinanceYearOid = row.FinanceYearOid.YearName;
Model.OrganizationSendOid = row.OrganizationSendOid.OrganizeNameTH;
Model.OrganizationReceiveOid = row.OrganizationReceiveOid.OrganizeNameTH;
Model.Remark = row.Remark;
Model.SendStatusOid = row.SendStatusOid;
list.Add(Model);
}
}
else
{
return(BadRequest("NoData"));
}
return(Ok(list));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public HttpResponseMessage UpdateRodBreedUseEject()
{
// object objStockAnimalInfo = null;
HistoryWork ObjHistory = null;
IList <StockSeedInfo> objStockSeedInfo = null;
string Username = "******";
try
{
//string RefNo = HttpContext.Current.Request.Form["RefNo"].ToString(); //ข้อมูลเลขที่อ้างอิง
//string Status = HttpContext.Current.Request.Form["Status"].ToString(); //สถานะ
//string CancelMsg = HttpContext.Current.Request.Form["Remark"].ToString(); //หมายเหตุ
//Username = HttpContext.Current.Request.Form["Username"].ToString();
string RefNo = HttpContext.Current.Request.Form["RefNo"].ToString(); //ข้อมูลเลขที่อ้างอิง
// string Status = HttpContext.Current.Request.Form["Status"].ToString(); //สถานะ
string CancelMsg = HttpContext.Current.Request.Form["Remark"].ToString(); //หมายเหตุ
Username = HttpContext.Current.Request.Form["Username"].ToString();
if (RefNo != "")
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierRodBreedUseProduct));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockRodBreedInfo));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockRodBreedInfo_Report));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.HistoryWork));
XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo));
XafTypesInfo.Instance.RegisterEntity(typeof(ReceiveLotNumber));
List <SupplierRodBreedUseProduct> list = new List <SupplierRodBreedUseProduct>();
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
UserInfo objUserInfo = ObjectSpace.FindObject <UserInfo>(CriteriaOperator.Parse("[UserName]=?", Username));
SupplierRodBreedUseProduct ObjMaster = ObjectSpace.FindObject <SupplierRodBreedUseProduct>(CriteriaOperator.Parse("UseNo=?", RefNo));
foreach (SupplierRodBreedUseProductDetail row in ObjMaster.SupplierRodBreedUseProductDetails)
{
if (ObjMaster.Status == EnumRodBreedProductSeedStatus.Approve || ObjMaster.Status == EnumRodBreedProductSeedStatus.Accepet)
{
var objCheckStockRodBreedInfo = ObjectSpace.GetObjects <StockRodBreedInfo>(CriteriaOperator.Parse("RodBreedProductNumber=? and FinanceYearOid=? and AnimalSeedOid=? and OrganizationOid=? and [SeedTypeOid]=?", row.SupplierRodBreedUseProductOid.UseNo, row.SupplierRodBreedUseProductOid.FinanceYearOid, row.AnimalSeedOid, row.SupplierRodBreedUseProductOid.OrganizationOid, row.SeedTypeOid));
var objStockRodBreedInfo_Detail = ObjectSpace.GetObjects <StockRodBreedInfo_Report>(CriteriaOperator.Parse("[FinanceYearOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", ObjMaster.FinanceYearOid, ObjMaster.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid));
if (objCheckStockRodBreedInfo.Count > 0)
{
// 'Update สถานะ IsApprove ให้เป็น True
var objStockRodBreedInfoEdit = ObjectSpace.FindObject <StockRodBreedInfo>(CriteriaOperator.Parse("[RodBreedProductNumber]=? and [FinanceYearOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierRodBreedUseProductOid.UseNo, row.SupplierRodBreedUseProductOid.FinanceYearOid, row.SupplierRodBreedUseProductOid.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid));
if (objStockRodBreedInfoEdit != null)
{
objStockRodBreedInfoEdit.IsApprove = true;
}
//SqlParameter[] prm = new SqlParameter[10];
//prm[0] = new SqlParameter("@RodBreedProductNumber", row.SupplierRodBreedUseProductOid.UseNo.ToString());
//prm[1] = new SqlParameter("@FinanceYearOid", row.SupplierRodBreedUseProductOid.FinanceYearOid.Oid);
//prm[2] = new SqlParameter("@BudgetSourceOid", null);
//prm[3] = new SqlParameter("@AnimalSeedOid", row.AnimalSeedOid.Oid);
//prm[4] = new SqlParameter("@OrganizationOid", row.SupplierRodBreedUseProductOid.OrganizationOid.Oid);
//prm[5] = new SqlParameter("@Weight", row.Weight);
//prm[6] = new SqlParameter("@Remark", "คืนสต๊อกเนื่องจากไม่อนุมัติการใช้ท่อนพันธุ์ (Mobile Application)");
//prm[7] = new SqlParameter("@SeedTypeOid", row.SeedTypeOid.Oid);
//prm[8] = new SqlParameter("@IsApprove", true);
//prm[9] = new SqlParameter("@Description", null);
//SqlHelper.ExecuteNonQuery(scc, CommandType.StoredProcedure, "SP_StockRodBreedInfo", prm);
var objStockRodBreedInfo = ObjectSpace.CreateObject <StockRodBreedInfo>();
{
objStockRodBreedInfo.TransactionDate = DateTime.Now;
objStockRodBreedInfo.RodBreedProductNumber = row.SupplierRodBreedUseProductOid.UseNo;
objStockRodBreedInfo.FinanceYearOid = row.SupplierRodBreedUseProductOid.FinanceYearOid;
// '.BudgetSourceOid = objCheckStockRodBreedInfo(0).BudgetSourceOid
objStockRodBreedInfo.AnimalSeedOid = row.AnimalSeedOid;
objStockRodBreedInfo.OrganizationOid = row.SupplierRodBreedUseProductOid.OrganizationOid;
objStockRodBreedInfo.Weight = row.Weight;
objStockRodBreedInfo.Remark = "คืนสต๊อกเนื่องจากไม่อนุมัติการใช้ท่อนพันธุ์ (Mobile Application)";
objStockRodBreedInfo.SeedTypeOid = row.SeedTypeOid;
objStockRodBreedInfo.IsApprove = true;
}
}
// ''Stock สำหรับ กปศ4ว
//if (ObjMaster.Status == EnumRodBreedProductSeedStatus.Approve || ObjMaster.Status == EnumRodBreedProductSeedStatus.Accepet)
//{
objStockRodBreedInfo_Detail = ObjectSpace.GetObjects <StockRodBreedInfo_Report>(CriteriaOperator.Parse("[FinanceYearOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", ObjMaster.FinanceYearOid, ObjMaster.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid));
if (objStockRodBreedInfo_Detail.Count > 0)
{
var objStockRodBreedInfo_DetailNew = ObjectSpace.CreateObject <StockRodBreedInfo_Report>();
//'Update สถานะ IsApprove ให้เป็น True
var objStockRodBreedInfoEdit = ObjectSpace.FindObject <StockRodBreedInfo_Report>(CriteriaOperator.Parse("[RodBreedProductNumber]=? and [FinanceYearOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierRodBreedUseProductOid.UseNo, row.SupplierRodBreedUseProductOid.FinanceYearOid, row.SupplierRodBreedUseProductOid.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid));
if (objStockRodBreedInfoEdit != null)
{
objStockRodBreedInfoEdit.IsApprove = true;
}
var ObjStockRodBreedInfo_DetailSource = (from Item in objStockRodBreedInfo_Detail
orderby Item.TransactionDate descending
select Item).First();
objStockRodBreedInfo_DetailNew.TransactionDate = DateTime.Now;
objStockRodBreedInfo_DetailNew.RodBreedProductNumber = ObjMaster.UseNo;
objStockRodBreedInfo_DetailNew.FinanceYearOid = ObjMaster.FinanceYearOid;
// .BudgetSourceOid = objStockRodBreedInfo_Detail(0).BudgetSourceOid
objStockRodBreedInfo_DetailNew.OrganizationOid = ObjMaster.OrganizationOid;
objStockRodBreedInfo_DetailNew.AnimalSeedOid = row.AnimalSeedOid;
objStockRodBreedInfo_DetailNew.TotalForward = ObjStockRodBreedInfo_DetailSource.TotalWeight;
objStockRodBreedInfo_DetailNew.TotalChange = row.Weight;
objStockRodBreedInfo_DetailNew.SeedTypeOid = row.SeedTypeOid;
objStockRodBreedInfo_DetailNew.Description = "คืนสต๊อกเนื่องจากไม่อนุมัติการใช้ท่อนพันธุ์ : " + ObjMaster.OrganizationOid.SubOrganizeName + "(Mobile Application)";
objStockRodBreedInfo_DetailNew.IsApprove = true;
}
}
//}
}
// SupplierSproutUseProduct TmpObjMaster ;
ObjMaster.CancelMsg = CancelMsg;
ObjMaster.Status = EnumRodBreedProductSeedStatus.Eject;
ObjMaster.CancelBy = objUserInfo.DisplayName;
ObjMaster.ActionType = EnumAction.Eject;
ObjMaster.CancelDate = DateTime.Now;
ObjHistory = ObjectSpace.CreateObject <HistoryWork>();
// ประวัติ
ObjHistory.RefOid = ObjMaster.Oid.ToString();
ObjHistory.FormName = "ท่อนพันธุ์";
ObjHistory.Message = "ไม่อนุมัติ (ขอใช้ท่อนพันธุ์ (Mobile Application)) ลำดับที่ : " + ObjMaster.UseNo;
ObjHistory.CreateBy = objUserInfo.UserName;
ObjHistory.CreateDate = DateTime.Now;
ObjectSpace.CommitChanges();
UpdateResult ret = new UpdateResult();
ret.status = "true";
ret.message = "บันทึกข้อมูลไม่อนุมัติเรียบร้อยแล้ว";
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
else
{
UpdateResult ret = new UpdateResult();
ret.status = "False";
ret.message = "กรุณากรอก RefNo";
return(Request.CreateResponse(HttpStatusCode.NotFound, ret));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
finally
{
SqlConnection.ClearAllPools();
}
}
public HttpResponseMessage RodBreedList()
{
try
{
string Org = HttpContext.Current.Request.Form["organizationOid"].ToString();
// string type = HttpContext.Current.Request.Form["type"].ToString();
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(SupplierRodBreedUseProduct));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <Rodbreed_model> Detail = new List <Rodbreed_model>();
IList <SupplierRodBreedUseProduct> collection = ObjectSpace.GetObjects <SupplierRodBreedUseProduct>(CriteriaOperator.Parse(" GCRecord is null and Status = 1 and OrganizationOid = ? ", Org));
var query = from Q in collection orderby Q.UseNo select Q;
if (collection.Count > 0)
{
foreach (SupplierRodBreedUseProduct row in query)
{
Rodbreed_model item = new Rodbreed_model();
item.SupplierRodBreedUseProductOid = row.Oid.ToString();
item.FinanceYearOid = row.FinanceYearOid.Oid.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
item.ActivityNameOid = row.ActivityOid.Oid.ToString();
item.ActivityName = row.ActivityOid.ActivityName;
if (row.SubActivityLevelOid != null)
{
item.SubActivityLevelOid = row.SubActivityLevelOid.Oid.ToString();
item.SubActivityLevelName = row.SubActivityLevelOid.ActivityName;
}
item.FinanceYearOid = row.FinanceYearOid.Oid.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
item.UseNo = row.UseNo;
item.UseDate = row.UseDate.ToString("dd/MM/yy");
item.OrganizationOid = row.OrganizationOid.Oid.ToString();
item.OrganizationName = row.OrganizationOid.SubOrganizeName;
if (row.EmployeeOid != null)
{
item.EmployeeOid = row.EmployeeOid.Oid.ToString();
item.EmployeeName = row.EmployeeOid.FullName;
}
if (row.RegisCusServiceOid != null)
{
item.RegisCusServiceOid = row.RegisCusServiceOid.Oid.ToString();
item.FullName = row.RegisCusServiceOid.DisPlayName;
item.FullAddress = row.RegisCusServiceOid.FullAddress;
}
if (row.OrgeServiceOid != null)
{
item.OrgeServiceOid = row.OrgeServiceOid.Oid.ToString();
item.FullName = row.OrgeServiceOid.OrgeServiceName;
item.FullAddress = row.OrgeServiceOid.FullAddress;
}
item.ServiceCount = row.ServiceCount;
item.TotalWeight = row.SupplierRodBreedUseProductDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม";
Detail.Add(item);
}
directProvider.Dispose();
ObjectSpace.Dispose();
//lists.Receive = ReceiveItems;
return(Request.CreateResponse(HttpStatusCode.OK, Detail));
}
else
{
UserError err2 = new UserError();
err2.status = "false";
err2.code = "-9";
err2.message = "ไม่มีข้อมูลรายการ การใช้ท่อนพันธุ์";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err2));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.status = "false";
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.ToString();
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage RodBreedUseApprove()
{
// object objStockAnimalInfo = null;
HistoryWork ObjHistory = null;
IList <StockSeedInfo> objStockSeedInfo = null;
string Username = "******";
object objDetailService = null;
try
{
string RefNo = HttpContext.Current.Request.Form["RefNo"].ToString(); //ข้อมูลเลขที่อ้างอิง
// string Status = HttpContext.Current.Request.Form["Status"].ToString(); //สถานะ
string CancelMsg = HttpContext.Current.Request.Form["Remark"].ToString(); //หมายเหตุ
Username = HttpContext.Current.Request.Form["Username"].ToString();
if (RefNo != "")
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierRodBreedUseProduct));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockRodBreedInfo));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockRodBreedInfo_Report));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.HistoryWork));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModifyDetail));
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModify));
XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo));
XafTypesInfo.Instance.RegisterEntity(typeof(ReceiveLotNumber));
XafTypesInfo.Instance.RegisterEntity(typeof(RegisterCusServiceDetail));
XafTypesInfo.Instance.RegisterEntity(typeof(OrgeServiceDetail));
XafTypesInfo.Instance.RegisterEntity(typeof(ServiceType));
List <SupplierRodBreedUseProduct> list = new List <SupplierRodBreedUseProduct>();
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
UserInfo objUserInfo = ObjectSpace.FindObject <UserInfo>(CriteriaOperator.Parse("[UserName]=?", Username));
SupplierRodBreedUseProduct ObjMaster = ObjectSpace.FindObject <SupplierRodBreedUseProduct>(CriteriaOperator.Parse("UseNo=?", RefNo));
if (ObjMaster.SupplierRodBreedUseProductDetails != null)
{
foreach (SupplierRodBreedUseProductDetail row in ObjMaster.SupplierRodBreedUseProductDetails)
{
if (ObjMaster.Status == EnumRodBreedProductSeedStatus.Accepet)
{
//'Update สถานะ IsApprove ให้เป็น True
var objStockRodBreedInfoEdit = ObjectSpace.FindObject <StockRodBreedInfo>(CriteriaOperator.Parse("[RodBreedProductNumber]=? and [FinanceYearOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierRodBreedUseProductOid.UseNo, row.SupplierRodBreedUseProductOid.FinanceYearOid, row.SupplierRodBreedUseProductOid.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid));
if (objStockRodBreedInfoEdit != null)
{
objStockRodBreedInfoEdit.IsApprove = true;
}
// ''Stock สำหรับ กปศ4ว
// '=======================================================================
// 'Update สถานะ IsApprove ให้เป็น True
var objStockRodBreedInfoReportEdit = ObjectSpace.FindObject <StockRodBreedInfo_Report>(CriteriaOperator.Parse("[RodBreedProductNumber]=? and [FinanceYearOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierRodBreedUseProductOid.UseNo, row.SupplierRodBreedUseProductOid.FinanceYearOid, row.SupplierRodBreedUseProductOid.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid));
if (objStockRodBreedInfoReportEdit != null)
{
objStockRodBreedInfoReportEdit.IsApprove = true;
}
}
}
if (ObjMaster.ActivityOid.ActivityName.Contains("จำหน่าย") == true)
{
if (ObjMaster.ChkOneService == true)
{
objDetailService = ObjectSpace.FindObject <RegisterCusServiceDetail>(CriteriaOperator.Parse("[RegisterCusServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%จำหน่าย%' and [SubServiceTypeOid.ServiceTypeName]='ท่อนพันธุ์' and [ReceiveDate]=?", ObjMaster.RegisCusServiceOid, ObjMaster.UseDate));
if (objDetailService == null)
{
RegisterCusServiceDetail objDetailService_new = ObjectSpace.CreateObject <RegisterCusServiceDetail>();
objDetailService_new.RegisterCusServiceOid = ObjMaster.RegisCusServiceOid;
ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%จำหน่าย%'"));
objDetailService_new.ServiceTypeOid = objServiceType;
ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='ท่อนพันธุ์'", objServiceType.Oid));
objDetailService_new.SubServiceTypeOid = objSubServiceType;
objDetailService_new.ReceiveDate = ObjMaster.UseDate;
objDetailService_new.RefOid = ObjMaster.Oid.ToString();
}
}
else if (ObjMaster.ChkGroupService == true)
{
objDetailService = ObjectSpace.FindObject <OrgeServiceDetail>(CriteriaOperator.Parse("[OrgeServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%จำหน่าย%' and [SubServiceTypeOid.ServiceTypeName]='ท่อนพันธุ์' and [ReceiveDate]=?", ObjMaster.OrgeServiceOid, ObjMaster.UseDate));
if (objDetailService == null) //'ถ้ายังไม่มีข้อมูลการขอรับบบริการให้ Insert ลงในส่วนของรายละเอียดการขอรับบริการด้วย
{
OrgeServiceDetail objDetailService_new = ObjectSpace.CreateObject <OrgeServiceDetail>();
objDetailService_new.OrgeServiceOid = ObjMaster.OrgeServiceOid;
ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%จำหน่าย%'"));
objDetailService_new.ServiceTypeOid = objServiceType;
ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='ท่อนพันธุ์'", objServiceType.Oid));
objDetailService_new.SubServiceTypeOid = objSubServiceType;
objDetailService_new.ReceiveDate = ObjMaster.UseDate;
objDetailService_new.RefOid = ObjMaster.Oid.ToString();
}
}
}
else if (ObjMaster.ActivityOid.ActivityName.Contains("แจกจ่าย") == true)
{
if (ObjMaster.ChkOneService == true) //'รายเดี่ยว
{
objDetailService = ObjectSpace.FindObject <RegisterCusServiceDetail>(CriteriaOperator.Parse("[RegisterCusServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%แจกจ่าย%' and [SubServiceTypeOid.ServiceTypeName]='ท่อนพันธุ์' and [ReceiveDate]=?", ObjMaster.RegisCusServiceOid, ObjMaster.UseDate));
if (objDetailService == null)// 'ถ้ายังไม่มีข้อมูลการขอรับบบริการให้ Insert ลงในส่วนของรายละเอียดการขอรับบริการด้วย
{
RegisterCusServiceDetail objDetailService_new = ObjectSpace.CreateObject <RegisterCusServiceDetail>();
objDetailService_new.RegisterCusServiceOid = ObjMaster.RegisCusServiceOid;
ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%แจกจ่าย%'"));
objDetailService_new.ServiceTypeOid = objServiceType;
ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='ท่อนพันธุ์'", objServiceType.Oid));
objDetailService_new.SubServiceTypeOid = objSubServiceType;
objDetailService_new.ReceiveDate = ObjMaster.UseDate;
objDetailService_new.RefOid = ObjMaster.Oid.ToString();
}
}
else if (ObjMaster.ChkGroupService == true)
{
objDetailService = ObjectSpace.FindObject <OrgeServiceDetail>(CriteriaOperator.Parse("[OrgeServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%แจกจ่าย%' and [SubServiceTypeOid.ServiceTypeName]='ท่อนพันธุ์' and [ReceiveDate]=?", ObjMaster.OrgeServiceOid, ObjMaster.UseDate));
if (objDetailService == null) //'ถ้ายังไม่มีข้อมูลการขอรับบบริการให้ Insert ลงในส่วนของรายละเอียดการขอรับบริการด้วย
{
OrgeServiceDetail objDetailService_new = ObjectSpace.CreateObject <OrgeServiceDetail>();
objDetailService_new.OrgeServiceOid = ObjMaster.OrgeServiceOid;
ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%แจกจ่าย%'"));
objDetailService_new.ServiceTypeOid = objServiceType;
ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='ท่อนพันธุ์'", objServiceType.Oid));
objDetailService_new.SubServiceTypeOid = objSubServiceType;
objDetailService_new.ReceiveDate = ObjMaster.UseDate;
objDetailService_new.RefOid = ObjMaster.Oid.ToString();
}
}
}
ObjMaster.Status = EnumRodBreedProductSeedStatus.Approve;
ObjMaster.ApproveDate = DateTime.Now;
// ObjectSpace.CommitChanges();
ObjHistory = ObjectSpace.CreateObject <HistoryWork>();
// ประวัติ
ObjHistory.RefOid = ObjMaster.Oid.ToString();
ObjHistory.FormName = "ท่อนพันธุ์";
ObjHistory.Message = "อนุมัติ (ขอใช้ท่อนพันธุ์ (Mobile Application) ) ลำดับที่ : " + ObjMaster.UseNo;
ObjHistory.CreateBy = objUserInfo.UserName;
ObjHistory.CreateDate = DateTime.Now;
ObjectSpace.CommitChanges();
UpdateResult ret = new UpdateResult();
ret.status = "true";
ret.message = "บันทึกข้อมูลอนุมัติเรียบร้อยแล้ว";
return(Request.CreateResponse(HttpStatusCode.OK, ret));
}
else
{
UpdateResult ret = new UpdateResult();
ret.status = "False";
ret.message = "กรุณากรอก RefNo";
return(Request.CreateResponse(HttpStatusCode.NotFound, ret));
}
}
else
{
UpdateResult ret = new UpdateResult();
ret.status = "False";
ret.message = "ไม่มีข้อมูลรายการข้อมูลท่อนพันธุ์";
return(Request.CreateResponse(HttpStatusCode.NoContent, ret));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage RodBreedListdetail()
{
try
{
string UseNo = HttpContext.Current.Request.Form["useNo"].ToString();
if (UseNo != "")
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierRodBreedUseProduct));
Rodbreed_model_Detail item = null;
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
IList <SupplierRodBreedUseProduct> collection = ObjectSpace.GetObjects <SupplierRodBreedUseProduct>(CriteriaOperator.Parse("GCRecord is null and UseNo='" + UseNo + "'", null));
foreach (SupplierRodBreedUseProduct row in collection)
{
item = new Rodbreed_model_Detail();
item.SupplierRodBreedUseProductOid = row.Oid.ToString();
item.FinanceYearOid = row.FinanceYearOid.Oid.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
item.UseNo = row.UseNo;
item.UseDate = row.UseDate.ToString("dd/MM/yyyy");
item.OrganizationOid = row.OrganizationOid.Oid.ToString();
item.OrganizationName = row.OrganizationOid.SubOrganizeName;
item.ActivityOid = row.ActivityOid.Oid.ToString();
item.Remark = row.Remark;
item.ActivityName = row.ActivityOid.ActivityName;
item.FinanceYearOid = row.FinanceYearOid.Oid.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
if (row.OrgeServiceOid != null)
{
item.OrgeServiceOid = row.OrgeServiceOid.Oid.ToString();
item.FullName = row.OrgeServiceOid.OrgeServiceName;
item.FullAddress = row.OrgeServiceOid.FullAddress;
}
if (row.RegisCusServiceOid != null)
{
item.RegisCusServiceOid = row.RegisCusServiceOid.Oid.ToString();
item.FullName = row.RegisCusServiceOid.DisPlayName;
item.FullAddress = row.RegisCusServiceOid.FullAddress;
}
if (row.SubActivityOid != null)
{
item.SubActivityOid = row.SubActivityOid.Oid.ToString();
item.SubActivityName = row.SubActivityOid.ActivityName;
}
if (row.SubActivityLevelOid != null)
{
item.SubActivityLevelOid = row.SubActivityLevelOid.Oid.ToString();
item.SubActivityLevelName = row.SubActivityLevelOid.ActivityName;
}
item.Status = row.Status.ToString();
item.ServiceCount = row.ServiceCount;
item.TotalWeight = row.SupplierRodBreedUseProductDetails.Sum((c => c.Weight)).ToString() + "" + "กิโลกรัม";
item.TotalPrice = row.SupplierRodBreedUseProductDetails.Sum((c => c.Price)).ToString() + "" + "บาท";
item.CancelMsg = row.CancelMsg;
if (row.ActivityOid.ActivityName == "เพื่อการจำหน่าย")
{
item.ReceiptNo = row.ReceiptNo;
}
List <SupplierRodBreedUseProductDetail_Model> details = new List <SupplierRodBreedUseProductDetail_Model>();
SupplierRodBreedUseProductDetail_Model _dt = null;
foreach (SupplierRodBreedUseProductDetail rw in row.SupplierRodBreedUseProductDetails)
{
_dt = new SupplierRodBreedUseProductDetail_Model();
_dt.AnimalSeedOid = rw.AnimalSeedOid.Oid.ToString();
_dt.SupplierRodBreedUseProductDetailOid = rw.Oid.ToString();
_dt.StockLimit = rw.StockLimit;
_dt.Weight = rw.Weight;
_dt.WeightUnitOid = rw.WeightUnitOid.Oid.ToString();
_dt.WeightUnitName = rw.WeightUnitOid.UnitName;
_dt.SeedTypeOid = rw.SeedTypeOid.Oid.ToString();
_dt.SeedTypeName = rw.SeedTypeOid.SeedTypeName;
_dt.AnimalSeedName = rw.AnimalSeedOid.SeedName;
_dt.Price = rw.Price;
_dt.PerPrice = rw.PerPrice;
_dt.SupplierRodBreedUseProductOid = rw.SupplierRodBreedUseProductOid.Oid.ToString();
details.Add(_dt);
}
item.Details = details;
}
return(Request.CreateResponse(HttpStatusCode.OK, item));
}
else
{
UserError err = new UserError();
err.status = "false";
err.code = "0";
err.message = "กรุณาใส่ข้อมูล RefNo ให้เรียบร้อยก่อน";
return(Request.CreateResponse(HttpStatusCode.NotFound, err));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
finally
{
SqlConnection.ClearAllPools();
}
}
protected override void CreateDefaultObjectSpaceProvider(CreateCustomObjectSpaceProviderEventArgs args)
{
args.ObjectSpaceProviders.Add(new SecuredObjectSpaceProvider((SecurityStrategyComplex)Security, XPObjectSpaceProvider.GetDataStoreProvider(args.ConnectionString, args.Connection, true), false));
args.ObjectSpaceProviders.Add(new NonPersistentObjectSpaceProvider(TypesInfo, null));
}
public SchemaProvider ReadApplication(string ApplicationName, string ApplicationFolder, string exeName, string XPOConnectionString, string DBConnectionString)
{
IList<string> moduleList = new List<string>(){
"Para.Core.Modules.SystemModule.Win.dll",
"Para.Model.Definition.dll",
"Para.Modules.WorkflowLight.dll",
"Para.Core.Modules.SpellCheckerModule.dll",
"Para.Modules.App.dll",
"Para.Modules.App.Win.dll",
"Para.Modules.ABF.dll",
"Para.Modules.BH.dll",
"Para.Modules.RA.dll",
"Para.Modules.FV.dll",
"Para.Modules.Workflow.dll",
"Para.Modules.Document.Activities.dll",
"Para.Modules.Intern.Win.dll",
"Para.Modules.MV.dll"
};
IList<Assembly> assemblies = new List<Assembly>();
foreach (var file in moduleList)
assemblies.Add(Assembly.LoadFile(ApplicationFolder + file));
ControllersManager controllerManager = new ControllersManager();
ApplicationModulesManager man = new ApplicationModulesManager(controllerManager, ApplicationFolder);
man.AddModuleFromAssemblies(assemblies.Select(ass => ass.FullName).ToArray());
var sec = new SecurityDummy();
SAConnection conn = new SAConnection(DBConnectionString);
conn.Open();
XpoDefault.DataLayer = XpoDefault.GetDataLayer("XpoProvider=Asa;DataSourceName='paradat'", new ReflectionDictionary(), AutoCreateOption.None);
XPObjectSpaceProvider provider = new XPObjectSpaceProvider(new ConnectionStringDataStoreProvider(XPOConnectionString));
DesignerModelFactory dmf = new DesignerModelFactory();
string ApplicationFileName = ApplicationFolder + exeName;
string ApplicationConfigFileName = String.Format("{0}{1}.config", ApplicationFolder, exeName);
var app = dmf.CreateApplicationByConfigFile(ApplicationConfigFileName, ApplicationFileName, ref ApplicationFolder);
app.DatabaseVersionMismatch += app_DatabaseVersionMismatch;
app.Setup("paraOffice", provider, man, sec);
var dict = (app.CreateObjectSpace() as XPObjectSpace).Session.Dictionary;
SchemaProvider schemaProvider = new SchemaProvider();
foreach (var classinfo in dict.Classes.Cast<XPClassInfo>().Where(c => c.IsPersistent))
{
if (classinfo.Table.IsView)
{
schemaProvider.Views.Add(new FastSchemaProvider.View() { Name = classinfo.Table.Name });
continue;
}
var table = new Table();
table.ActualName = classinfo.Table.Name;
foreach (var column in classinfo.Table.Columns)
table.Columns.Add(new Column() { ActualName = column.Name, DataType = column.ColumnType.ToSchemaDbType(), MaxLength = column.Size, IsPrimaryKeyColumn = column.IsKey, IsIdentity = column.IsIdentity });
table.BuildPrimaryKey();
foreach (var index in classinfo.Table.Indexes)
{
var schemaIndex = new Index() { IndexName = index.Name, IndexType = index.IsUnique ? IndexTypes.Unqiue : IndexTypes.NonUnqiue };
int i = 1;
foreach (var col in index.Columns)
{
var indexCol = new IndexColumn();
indexCol.ColumnName = col;
indexCol.Sequence = i;
indexCol.Order = Ordering.Ascending;
i++;
schemaIndex.Columns.Add(indexCol);
}
table.Indizes.Add(schemaIndex);
}
foreach (var fk in classinfo.Table.ForeignKeys)
{
var foreignKey = new ForeignKey();
foreignKey.Name = fk.Name;
foreignKey.Columns.AddRange(fk.Columns.Cast<string>());
foreignKey.DetailTable = classinfo.TableName;
foreignKey.MasterTable = fk.PrimaryKeyTable;
foreignKey.UniqueColumns.AddRange(fk.PrimaryKeyTableKeyColumns.Cast<string>());
table.ForeignKeys.Add(foreignKey);
}
schemaProvider.Tables.Add(table);
}
return schemaProvider;
}
