public async Task <IActionResult> PutTestMaster(int id, TestMaster testMaster) { if (id != testMaster.TestId) { return(BadRequest()); } _context.Entry(testMaster).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TestMasterExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
void AddMaster(Session session) { for (var i = 1; i <= MaxRecordCount; ++i) { var tmpTestMaster = new TestMaster(session); tmpTestMaster.Val = $"Master# {i}"; for (var j = 1; j <= MaxRecordCount; ++j) { var tmpTestDetail = new TestDetail(session); tmpTestDetail.Val = $"Detail# [{i}.{j}]"; tmpTestDetail.Master = tmpTestMaster; tmpTestDetail.Save(); } tmpTestMaster.Save(); } XPBaseCollection dataSource; if ((dataSource = gridControlMaster.DataSource as XPBaseCollection) != null) { dataSource.Reload(); } if ((dataSource = gridControlDetail.DataSource as XPBaseCollection) != null) { dataSource.Reload(); } }
public ActionResult Add(TestMaster obj) { KeystoneProject.Buisness_Logic.MasterLaboratory.BL_TestMaster TestMasterobj = new KeystoneProject.Buisness_Logic.MasterLaboratory.BL_TestMaster(); string val = ""; if (TestMasterobj.CheckHeader(obj.HeaderName, Convert.ToInt32(obj.HeaderID))) { if (obj.HeaderName != "") { if (TestMasterobj.Save(obj)) { ModelState.Clear(); ViewData["flag"] = "Done"; val = "Header Saved Successfully !"; } } } else { try { val = "Header Already Exists !"; ViewData["flag"] = "Error"; } catch (Exception) { throw; } } return(Json(val)); }
public async Task <ActionResult <TestMaster> > PostTestMaster(TestMaster testMaster) { _context.TestMaster.Add(testMaster); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTestMaster", new { id = testMaster.TestId }, testMaster)); }
void ITestMasterService.CreateTestMaster(TestMaster testMaster) { var validator = validatorFactory.GetValidator <TestMaster>(); validator.ValidateAndThrow(testMaster); testMasterRepository.Add(testMaster); }
public JsonResult BindParameterGrid(string search, string chk) { List <TestMaster> ser = new List <TestMaster>(); BL_TestMaster BL_obj = new BL_TestMaster(); TestMaster obj = new TestMaster(); HospitalLocation(); obj.dsAllTestMaster = BL_obj.GetParameterForTestMaster(HospitalID, LocationID, search); if (chk == "Parameter") { int count = 0; foreach (DataRow dr in obj.dsAllTestMaster.Tables[0].Rows) { TestMaster obj1 = new TestMaster(); obj1.ParameterID = dr["ParameterID"].ToString(); obj1.ParameterName = dr["ParameterName"].ToString(); ser.Add(obj1); } } else { int count1 = 0; foreach (DataRow dr in obj.dsAllTestMaster.Tables[1].Rows) { TestMaster obj12 = new TestMaster(); obj12.HeaderID = dr["HeaderID"].ToString(); obj12.HeaderName = dr["HeaderName"].ToString(); ser.Add(obj12); } } return(Json(ser, JsonRequestBehavior.AllowGet)); }
public void UpdateTestMaster(TestMaster testMaster) { var validator = validatorFactory.GetValidator <TestMaster>(); validator.ValidateAndThrow(testMaster); testMasterRepository.Update(testMaster); }
private TestMaster CreateTestMaster(int i, int detailsCount) { var master = new TestMaster(unitOfWork); master.Val = i.ToString(); master.Details.AddRange(CreateTestDetailCollection(master, detailsCount)); return(master); }
public ActionResult DeleteConfirmed(int id) { TestMaster testMaster = db.TestMasters.Find(id); db.TestMasters.Remove(testMaster); db.SaveChanges(); return(RedirectToAction("Index")); }
private TestDetail CreateTestDetail(TestMaster master, int val) { var detail = new TestDetail(unitOfWork); detail.Master = master; detail.Val = val.ToString(); return(detail); }
public JsonResult Edit(int TestID) { BL_TestMaster _TestMaster = new BL_TestMaster(); TestMaster obj = new TestMaster(); List <TestMaster> GetList = new List <TestMaster>(); DataSet ds = _TestMaster.GetTestMaster(TestID); foreach (DataRow dr in ds.Tables[0].Rows) { GetList.Add(new TestMaster { HospitalID = Convert.ToInt32(dr["HospitalID"]), LocationID = Convert.ToInt32(dr["LocationID"]), TestID = dr["TestID"].ToString(), TestName = dr["TestName"].ToString(), HSNCode = dr["HSNCode"].ToString(), PrintAs = dr["PrintAs"].ToString(), GeneralCharges = dr["GeneralCharges"].ToString(), EmergencyCharges = dr["EmergencyCharges"].ToString(), Client = dr["Client"].ToString(), Alias = dr["Alias"].ToString(), MyCost = dr["MyCost"].ToString(), CategoryID = dr["Category"].ToString(), Category = dr["CategoryName"].ToString(), TestType = dr["TestType"].ToString(), ReffCommission = dr["ReffCommission"].ToString(), ReffCommissionRs = dr["ReffCommissionRs"].ToString(), Commission = dr["Commission"].ToString(), CommissionRs = dr["CommissionRs"].ToString(), ForGender = dr["ForGender"].ToString(), Format = dr["Format"].ToString(), ProcessDay = dr["ProcessDay"].ToString(), PrintOrder = dr["PrintOrder"].ToString(), Methord = dr["Methord"].ToString(), OutsideLab = dr["OutSideLab"].ToString(), DisposalDay = dr["DisposalDay"].ToString(), Discount = dr["Discount"].ToString(), SampleType = dr["SampleType"].ToString(), PrintName = dr["PrintName"].ToString(), PrintTogether = dr["PrintTogether"].ToString(), WardView = dr["WardView"].ToString(), Interpretation = dr["Interpretation"].ToString(), HMSCode = dr["HMSCode"].ToString(), PatientInstr = dr["PatientInstr"].ToString(), Footer = dr["Footer"].ToString(), TechnicianIntr = dr["TechnicianIntr"].ToString(), MachineName = dr["MachinName"].ToString(), }); } return(new JsonResult { Data = GetList, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult Edit([Bind(Include = "TestMasterId,TestMasterName")] TestMaster testMaster) { if (ModelState.IsValid) { db.Entry(testMaster).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(testMaster)); }
// Use this for initialization void Awake () { get = this; master = new Master(); user = SaveDataJsonUtility.Load<User>("savedata"); master.LoadData(); foreach(var i in master.Characters.list) { Debug.Log(i.name); } }
public ActionResult Create([Bind(Include = "TestMasterId,TestMasterName")] TestMaster testMaster) { if (ModelState.IsValid) { db.TestMasters.Add(testMaster); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(testMaster)); }
private IEnumerable <TestDetail> CreateTestDetailCollection(TestMaster master, int count) { var list = new List <TestDetail>(); for (var i = 0; i < count; ++i) { list.Add(CreateTestDetail(master, i)); } return(list); }
bool ITestMasterService.CreateTestMaster(TestMaster testMaster, ref ValidationResult result) { var validator = validatorFactory.GetValidator <TestMaster>(); result = validator.Validate(testMaster); if (result.IsValid) { testMasterRepository.Add(testMaster); } return(result.IsValid); }
public ActionResult Delete(int CollectionID) { string val = ""; TestMaster obj = new TestMaster(); BL_CollectionCenter _CollectionCenter = new BL_CollectionCenter(); if (_CollectionCenter.DeleteCollectionCenter(CollectionID)) { val = "CollectionCenter Deleted Successfully"; } // Response.Redirect("TestMasterAdd.cshtml"); return(Json(val)); }
public ActionResult Delete(int TestID) { string val = ""; TestMaster obj = new TestMaster(); BL_TestMaster _TestMaster = new BL_TestMaster(); if (_TestMaster.DeleteTestMaster(HospitalID, TestID, LocationID)) { val = "TestMaster Deleted Successfully"; } // Response.Redirect("TestMasterAdd.cshtml"); return(Json(val)); }
// GET: TestMasters/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TestMaster testMaster = db.TestMasters.Find(id); if (testMaster == null) { return(HttpNotFound()); } return(View(testMaster)); }
public JsonResult GetMasterDetails(int TestID) { BL_TestMaster _TestMaster = new BL_TestMaster(); TestMaster obj = new TestMaster(); obj.dsGetAllWardName = _TestMaster.GetTestMasterDetailIPDCharge(TestID); List <TestMaster> GetWard = new List <TestMaster>(); foreach (DataRow dr in obj.dsGetAllWardName.Tables[0].Rows) { GetWard.Add(new TestMaster { WardID = dr["WardID"].ToString(), WardName = dr["WardName"].ToString(), GeneralCharges = dr["GeneralCharges"].ToString(), EmergencyCharges = dr["EmergencyCharges"].ToString(), TestMasterDetailIPDChargeID = dr["TestMasterDetailIPDChargeID"].ToString(), TestID = dr["TestID"].ToString(), Mode = dr["Mode"].ToString(), }); } List <TestMaster> GetTest = new List <TestMaster>(); DataSet dsGetTest = _TestMaster.GetTestMasterDetail(HospitalID, TestID, LocationID); obj.dsParameterSet = new DataSet(); obj.dsParameterSet.Tables.Add(new DataTable()); foreach (DataRow dr in dsGetTest.Tables[0].Rows) { GetTest.Add(new TestMaster { HospitalID = Convert.ToInt32(dr["HospitalID"]), LocationID = Convert.ToInt32(dr["LocationID"]), TestDetailsID = Convert.ToInt32(dr["TestDetailsID"]).ToString(), TestID = dr["TestID"].ToString(), ParameterName = dr["ParameterName"].ToString(), HeaderName = dr["HeaderName"].ToString(), HeaderParmater = dr["HeaderParmater"].ToString(), Type1 = dr["Type"].ToString(), Space1 = dr["Space"].ToString(), HeaderID = dr["HeaderID"].ToString(), PrintOrder = dr["Order"].ToString(), Mode = dr["Mode"].ToString(), }); } return(Json(new { GetTest = GetTest, GetWard = GetWard }, JsonRequestBehavior.AllowGet)); }
//[HttpPost] public ActionResult saveTestMaster(TestMasterViewModel testMasterModel) { try { TestMaster objTestMaster = null; objTestMaster = Mapper.Map <TestMasterViewModel, TestMaster>(testMasterModel); _testMasterService.CreateCategory(objTestMaster); _iUnitOfWork.Commit(); } catch (Exception e) { ErrorSignal.FromCurrentContext().Raise(e); } return(RedirectToAction("Index", "TestMaster")); }
public ActionResult CreateTestMaster(TestMasterViewModel testMasterModel) { TestMaster objTestMaster = null; objTestMaster = Mapper.Map <TestMasterViewModel, TestMaster>(testMasterModel); testMasterService.CreateTestMaster(objTestMaster); iUnitOfWork.Commit(); var Data = new { Success = true, SuccessCode = 200, SuccessMessage = "Test Master Created Successfuly" }; return(Json(Data, JsonRequestBehavior.AllowGet)); }
public override void OnInspectorGUI() { base.OnInspectorGUI(); TestMaster script = (TestMaster)target; if (GUILayout.Button("Apply in game")) { script.StartApplyingEnvChanges(); } if (GUILayout.Button("Redraw")) { script.RedrawSkybox(); } if (GUILayout.Button("Face to zero")) { script.FaceObj(); } }
public JsonResult UpdateTestMaster(TestMasterViewModel testMasterViewModel) { TestMaster testMaster = null; testMaster = Mapper.Map <TestMasterViewModel, TestMaster> (testMasterViewModel); testMasterService.UpdateTestMaster(testMaster); iUnitOfWork.Commit(); var Data = new { Success = true, testMasterId = testMasterViewModel.TestMasterID, testMasterName = testMasterViewModel.TestMasterName, testMasterDescription = testMasterViewModel.Description, msg = (testMasterViewModel.operation == "Delete")?"Test Master Removed": "Test Master Updated!" }; return(Json(Data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllParameter(string prefix) { List <TestMaster> ser = new List <TestMaster>(); BL_TestMaster BL_obj = new BL_TestMaster(); TestMaster obj = new TestMaster(); obj.dsAllTestMaster = BL_obj.GetAllParameter(); foreach (DataRow dr in obj.dsAllTestMaster.Tables[0].Rows) { TestMaster obj1 = new TestMaster(); obj1.ParameterID = dr["ParameterID"].ToString(); obj1.ParameterName = dr["ParameterName"].ToString().Replace(",", ";"); ser.Add(obj1); } return(Json(ser, JsonRequestBehavior.AllowGet)); }
public JsonResult ColorHeader(string prefix) { List <TestMaster> ser = new List <TestMaster>(); BL_TestMaster BL_obj = new BL_TestMaster(); TestMaster obj = new TestMaster(); obj.dsAllTestMaster = BL_obj.GetAllWard(); foreach (DataRow dr in obj.dsAllTestMaster.Tables[0].Rows) { TestMaster obj1 = new TestMaster(); obj1.WardID = dr["WardID"].ToString(); obj1.WardName = dr["WardName"].ToString(); obj1.GeneralCharges = dr["GeneralCharges"].ToString(); obj1.EmergencyCharges = dr["EmergencyCharges"].ToString(); ser.Add(obj1); } return(Json(ser, JsonRequestBehavior.AllowGet)); }
public JsonResult imageuplod(TestMaster model) { //var file = model.ImageFile; //string path1 = Server.MapPath("~/") + "LaboratoryFiles/" + file.FileName; //System.IO.File.Copy("" + ucTestMaster1.txtUploadFile.Text + "", path1 + "" + ucTestMaster1.txtName.Text + ".docx"); List <TestMaster> TestMasterImage = new List <TestMaster>(); var file = model.ImageFile; if (file != null) { //var path = ""; var filename = Path.GetFileName(file.FileName); var extention = Path.GetExtension(file.FileName); var filenamethoutextenction = Path.GetFileNameWithoutExtension(file.FileName); // file.SaveAs(Server.MapPath("~/MRDFiles/" + file.FileName)); // Session["Paper"] = "/MRDFiles/" + file.FileName; string path = Server.MapPath("~/") + "LaboratoryFiles/" + file.FileName; file.SaveAs(path); // Session["Paper"] = path; //TestMasterImage.Add(new TestMaster //{ // //PaperName = "/MRDFiles/" + file.FileName, // //Paper = path, //}); } return(new JsonResult { Data = file, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
static void Main(string[] args) { var master = new TestMaster(); var go = new SequentialExecutor(master); master.Events.Execute(TestEvents.MeFirst); master.Events.Execute(TestEvents.MeSecond); master.Events.Execute(TestEvents.MeThird); go.Execute(); master.Events.Execute(TestEvents.MeSecond); master.Events.Execute(TestEvents.MeFirst); master.Events.Execute(TestEvents.MeThird); go.Execute(); master.Events.Execute(TestEvents.MeThird); master.Events.Execute(TestEvents.MeSecond); master.Events.Execute(TestEvents.MeFirst); go.Execute(); }
public bool Save(TestMaster obj) { Connect(); SqlCommand cmd = new SqlCommand("IUHeader", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); // cmd.Parameters.AddWithValue("@QualifictionID", 0); if (obj.HeaderID == null) { cmd.Parameters.AddWithValue("@HeaderID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@HeaderID", obj.HeaderID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@ReferenceCode", 1); cmd.Parameters.AddWithValue("@HeaderName", obj.HeaderName); cmd.Parameters.AddWithValue("@CreationID", UserID); // cmd.Parameters.AddWithValue("@Mode", "Add"); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } }
static void Main(string[] args) { try { XpoDefault.DataLayer = new SimpleDataLayer(new InMemoryDataStore()); #if TEST_OWN_TABLE using (var unitOfWork = new UnitOfWork()) { #region Person var dataPerson = new[] { new { Id = 1, Name = "Person" } }; foreach (var rec in dataPerson) { var entity = InMemoryDataStoreHelper.CreateSimpleEntity(typeof(Person), rec, unitOfWork); if (entity == null) { continue; } unitOfWork.Save(entity); } unitOfWork.CommitChanges(); InMemoryDataStoreHelper.ShowExistingData(typeof(Person), o => o is Person item ? $"{{Id:{item.Id}, Name:\"{item.Name}\"}}" : string.Empty); #endregion #region Employee var dataEmployee = new[] { new { Id = 2, Name = "Employee" } }; foreach (var rec in dataEmployee) { var entity = InMemoryDataStoreHelper.CreateSimpleEntity(typeof(Employee), rec, unitOfWork); if (entity == null) { continue; } unitOfWork.Save(entity); } unitOfWork.CommitChanges(); InMemoryDataStoreHelper.ShowExistingData(typeof(Person), o => o is Person item ? $"{{Id:{item.Id}, Name:\"{item.Name}\"}}" : string.Empty); InMemoryDataStoreHelper.ShowExistingData(typeof(Employee), o => o is Employee item ? $"{{Id:{item.Id}, Name:\"{item.Name}\", Salary:{item.Salary}}}" : string.Empty); #endregion #region Executive var executive = new Executive(unitOfWork); executive.Id = 3; executive.Name = "Executive"; executive.Salary = 456; executive.Bonus = 789; var person = unitOfWork.GetObjectByKey <Person>(3); var employee = unitOfWork.GetObjectByKey <Employee>(3); var executive2 = unitOfWork.GetObjectByKey <Executive>(3); unitOfWork.Save(executive); unitOfWork.CommitChanges(); #endregion } #endif #if TEST_MAPINHERITANCETYPE_PARENTTABLE using (var unitOfWork = new UnitOfWork()) { var entity1 = new Entity1(unitOfWork); entity1.Id = 1; entity1.Value = "Entity1"; entity1.Entity3Derived1.AddRange(new[] { new Entity3Derived1(unitOfWork), new Entity3Derived1(unitOfWork) }); for (var i = 0; i < entity1.Entity3Derived1.Count; ++i) { ((Entity3Derived1)entity1.Entity3Derived1[i]).Value = $"Entity3Derived1 #{i + 1} (\"{entity1.Value}\")"; } var entity2 = new Entity2(unitOfWork); entity2.Id = 2; entity2.Value = "Entity2"; entity2.Entity3Derived2.AddRange(new[] { new Entity3Derived2(unitOfWork), new Entity3Derived2(unitOfWork) }); for (var i = 0; i < entity2.Entity3Derived2.Count; ++i) { ((Entity3Derived2)entity2.Entity3Derived2[i]).Value = $"Entity3Derived2 #{i + 1} (\"{entity2.Value}\")"; } unitOfWork.CommitChanges(); foreach (var entity in new XPCollection <Entity3Base>(unitOfWork).OrderBy(item => item.Id)) { var entity3Derived1 = entity as Entity3Derived1; var entity3Derived2 = entity as Entity3Derived2; var elementId = entity3Derived1?.Element.Id ?? entity3Derived2?.Element.Id; var elementValue = entity3Derived1?.Element.Value ?? entity3Derived2?.Element.Value; Debug.WriteLine($"Id:{entity.Id}, Value:{entity.Value}, Element.Id:{elementId?.ToString() ?? "NULL"}, Element.Value:{elementValue ?? "NULL"}"); } } #endif Session session = new Session(), sessionII = new Session(), sessionIII = new Session(); XPClassInfo classInfoTestMaster = session.GetClassInfo(typeof(TestMaster)), classInfoTestDetail = session.GetClassInfo(typeof(TestDetail)); TestMaster testMaster; testMaster = new TestMaster(sessionII); testMaster.Val = "testMaster (sessionII)"; sessionII.Save(testMaster); testMaster = new TestMaster(sessionIII); testMaster.Val = "testMaster (sessionIII)"; sessionIII.Save(testMaster); var criteria = new BinaryOperator(new OperandProperty("Name"), new OperandValue("testMaster (sessionII)"), BinaryOperatorType.Equal); if ((testMaster = session.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = sessionII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = sessionIII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } criteria = new BinaryOperator(new OperandProperty("Name"), new OperandValue("testMaster (sessionIII)"), BinaryOperatorType.Equal); if ((testMaster = session.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = sessionII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = sessionIII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } UnitOfWork uow = new UnitOfWork(), uowII = new UnitOfWork(), uowIII = new UnitOfWork(); testMaster = new TestMaster(uowII); testMaster.Val = "testMaster (uowII)"; uowII.Save(testMaster); testMaster = new TestMaster(uowIII); testMaster.Val = "testMaster (uowIII)"; uowIII.Save(testMaster); var objToSave = uow.GetObjectsToSave(); // Count = 0 var objToSaveII = uowII.GetObjectsToSave(); // Count = 1 var objToSaveIII = uowIII.GetObjectsToSave(); // Count = 1 criteria = new BinaryOperator(new OperandProperty("Name"), new OperandValue("testMaster (uowII)"), BinaryOperatorType.Equal); if ((testMaster = uow.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // null } if ((testMaster = uowII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // null } if ((testMaster = uowIII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // null } criteria = new BinaryOperator(new OperandProperty("Name"), new OperandValue("testMaster (uowIII)"), BinaryOperatorType.Equal); if ((testMaster = uow.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // null } if ((testMaster = uowII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // null } if ((testMaster = uowIII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // nul } // https://documentation.devexpress.com/#CoreLibraries/CustomDocument2111 var collection = new XPCollection <TestMaster>(uow); Console.WriteLine(collection.Count); collection = new XPCollection <TestMaster>(uowII); Console.WriteLine(collection.Count); collection = new XPCollection <TestMaster>(uowIII); Console.WriteLine(collection.Count); collection = new XPCollection <TestMaster>(PersistentCriteriaEvaluationBehavior.InTransaction, uow, null); Console.WriteLine(collection.Count); collection = new XPCollection <TestMaster>(PersistentCriteriaEvaluationBehavior.InTransaction, uowII, null); Console.WriteLine(collection.Count); collection = new XPCollection <TestMaster>(PersistentCriteriaEvaluationBehavior.InTransaction, uowIII, null); Console.WriteLine(collection.Count); uowII.CommitChanges(); criteria = new BinaryOperator(new OperandProperty("Name"), new OperandValue("testMaster (uowII)"), BinaryOperatorType.Equal); if ((testMaster = uow.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = uowII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = uowIII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } uowIII.CommitChanges(); criteria = new BinaryOperator(new OperandProperty("Name"), new OperandValue("testMaster (uowII)"), BinaryOperatorType.Equal); if ((testMaster = uow.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = uowII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } if ((testMaster = uowIII.FindObject <TestMaster>(criteria)) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); // oB! } objToSave = uow.GetObjectsToSave(); // Count = 0 objToSaveII = uowII.GetObjectsToSave(); // Count = 0 objToSaveIII = uowIII.GetObjectsToSave(); // Count = 0 uow.Dispose(); uowII.Dispose(); uowIII.Dispose(); for (var i = 0; i < 3; ++i) { testMaster = new TestMaster(session); testMaster.Val = i.ToString(); for (var j = 0; j < 3; ++j) { testMaster.Details.Add(new TestDetail(session)); testMaster.Details[j].Val = string.Format("{0}.{1}", i, j); } session.Save(testMaster); } if ( (testMaster = session.FindObject <TestMaster>(new BinaryOperator(new OperandProperty("Name"), new OperandValue("1"), BinaryOperatorType.Equal))) != null) { Console.WriteLine("TestMaster: {{Id:{0}, Name:\"{1}\"}}", testMaster.Id, testMaster.Val); foreach (var detail in testMaster.Details) { Console.WriteLine("TestDetail: {{Id:{0}, Master.Id:{1}, Name:\"{2}\"}}", detail.Id, detail.Master.Id, detail.Val); } } var resultOfSelectData = session.SelectData( classInfoTestMaster, new CriteriaOperatorCollection { new OperandProperty("Id") }, CriteriaOperator.Or( new BinaryOperator(new OperandProperty("Name"), new OperandValue("1"), BinaryOperatorType.Equal), new BinaryOperator(new OperandProperty("Name"), new OperandValue("2"), BinaryOperatorType.Equal) ), false, 0, null).ToArray(); var resultOfGetObjects = session.GetObjects( classInfoTestMaster, CriteriaOperator.Or( new BinaryOperator(new OperandProperty("Name"), new OperandValue("1"), BinaryOperatorType.Equal), new BinaryOperator(new OperandProperty("Name"), new OperandValue("2"), BinaryOperatorType.Equal) ), null, 0, false, true).OfType <TestMaster>().ToArray(); using (uow = new UnitOfWork()) { for (var i = 3; i < 6; ++i) { testMaster = new TestMaster(uow); testMaster.Val = i.ToString(); for (var j = 0; j < 3; ++j) { testMaster.Details.Add(new TestDetail(uow)); testMaster.Details[j].Val = string.Format("{0}.{1}", i, j); } uow.CommitChanges(); } } resultOfSelectData = session.SelectData( classInfoTestMaster, new CriteriaOperatorCollection { new OperandProperty("Id") }, CriteriaOperator.Or( new BinaryOperator(new OperandProperty("Name"), new OperandValue("4"), BinaryOperatorType.Equal), new BinaryOperator(new OperandProperty("Name"), new OperandValue("5"), BinaryOperatorType.Equal) ), false, 0, null).ToArray(); var res = (from _testMaster_ in new XPQuery <TestMaster>(session) join _testDetail_ in new XPQuery <TestDetail>(session) on _testMaster_.Id equals _testDetail_.Master.Id where _testDetail_.Val == "1.1" /*&& _testDetail_.PhysicalPerson.id == processedUser.id*/ && _testDetail_.Master.Id == 6 select new { TestMasterId = _testMaster_.Id, TestDetailId = _testDetail_.Id }).ToList(); } catch (Exception eException) { Console.WriteLine(eException.GetType().FullName + Environment.NewLine + "Message: " + eException.Message + Environment.NewLine + (eException.InnerException != null && !string.IsNullOrEmpty(eException.InnerException.Message) ? "InnerException.Message" + eException.InnerException.Message + Environment.NewLine : string.Empty) + "StackTrace:" + Environment.NewLine + eException.StackTrace); } }
static void Main(string[] args) { XpoDefault.ConnectionString = MSSqlConnectionProvider.GetConnectionString(".", "sa", "123", "testdb"); Session sessionI = new Session(), sessionII; UnitOfWork unitOfWorkI; XPMemberInfo memberInfo; XPCollection xpCollectionI, xpCollectionII; XPCollection <Staff> xpCollectionStaff; CriteriaOperator criteria; TestMaster tmpTestMaster, tmpTestMasterII; TestDetail tmpTestDetail, tmpTestDetailII; TestDE tmpTestDE = null, tmpTestDEII = null; int tmpInt; string tmpString; XPClassInfo testMasterClassInfo = sessionI.GetClassInfo <TestMaster>(), testDetailClassInfo = sessionI.GetClassInfo <TestDetail>(), staffClassInfo = sessionI.GetClassInfo <Staff>(); Victim tmpVictim; #if TEST_PREFETCH_COLLECTION if ((tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(2L)) != null) { foreach (var detail in tmpTestMaster.Details) { Debug.WriteLine($"Id: {detail.Id}"); } } if ((tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(1L)) != null && (memberInfo = testMasterClassInfo.GetMember(nameof(TestMaster.Details))).MemberType.IsSubclassOf(typeof(XPBaseCollection))) { if (memberInfo.GetValue(tmpTestMaster) is XPCollection <TestDetail> xpCollectionTestDetails) { if (((IXPPrefetchableAssociationList)xpCollectionTestDetails).NeedPrefetch()) { criteria = new BinaryOperator(new OperandProperty(nameof(TestDetail.Master)), new OperandValue(tmpTestMaster.Id), BinaryOperatorType.Equal); var details = sessionI.GetObjects(testDetailClassInfo, criteria, null, 0, true, false); ((IXPPrefetchableAssociationList)xpCollectionTestDetails).FinishPrefetch(details); if (!xpCollectionTestDetails.IsLoaded) { xpCollectionTestDetails.Load(); } } } foreach (var detail in tmpTestMaster.Details) { Debug.WriteLine($"Id: {detail.Id}"); } } #endif #if TEST_GENERICS xpCollectionI = new XPCollection(sessionI, typeof(Staff)); //xpCollectionStaff = xpCollectionI as XPCollection<Staff>; // Error CS0039 Cannot convert type 'DevExpress.Xpo.XPCollection' to 'DevExpress.Xpo.XPCollection<TestCollection.Db.Staff>' via a reference conversion, boxing conversion, unboxing conversion, wrapping conversion, or null type conversion Type genericXPCollectionStaff = typeof(XPCollection <>).MakeGenericType(staffClassInfo.ClassType); xpCollectionStaff = Activator.CreateInstance(genericXPCollectionStaff, sessionI) as XPCollection <Staff>; xpCollectionStaff = new XPCollection <Staff>(sessionI); genericXPCollectionStaff = xpCollectionStaff.GetType(); if (genericXPCollectionStaff.IsGenericType) { var genericTypeDefinition = genericXPCollectionStaff.GetGenericTypeDefinition(); if (genericTypeDefinition == typeof(XPCollection <>)) { Type type = genericXPCollectionStaff.GetGenericArguments()[0]; //type = genericXPCollectionStaff.GetProperty("Item").PropertyType; type = genericXPCollectionStaff.GetTypeInfo().GenericTypeArguments[0]; } var xpBaseCollection = (XPBaseCollection)xpCollectionStaff; } var customCollectionStaff = new CustomCollection <Staff>(sessionI); var customCollection = (XPBaseCollection)customCollectionStaff; Type type1 = xpCollectionI.GetType(); Type elementType = typeof(object); Type type2 = typeof(IEnumerable <>).MakeGenericType(elementType); Type type3 = typeof(IQueryable <>).MakeGenericType(elementType); bool flag = type2.IsAssignableFrom(type1); // IEnumerable<> false flag = type3.IsAssignableFrom(type1); // IQueryable<> false MethodInfo method1 = (flag ? queryableDistinctInfo : enumerableDistinctInfo).MakeGenericMethod(elementType); MethodInfo method2 = (flag ? queryableOfTypeInfo : enumerableOfTypeInfo).MakeGenericMethod(elementType); ParameterExpression parameterExpression = Expression.Parameter(typeof(object), "dataSource"); UnaryExpression unaryExpression = Expression.Convert((Expression)parameterExpression, flag ? type3 : type2); var expr = Expression.Lambda <Func <object, object> >((Expression)(true ? Expression.Call(method1, (Expression)unaryExpression) : Expression.Call(method1, (Expression)Expression.Call(method2, (Expression)unaryExpression))), new ParameterExpression[1] { parameterExpression }); var func = expr.Compile(); //var result = func(xpCollectionI); type1 = xpCollectionStaff.GetType(); flag = type2.IsAssignableFrom(type1); // IEnumerable<> true flag = type3.IsAssignableFrom(type1); // IQueryable<> false var result = func(xpCollectionStaff); #endif #if TEST_SORTING xpCollectionI = new XPCollection(sessionI, typeof(Staff), null, new SortProperty("Dep", SortingDirection.Ascending), new SortProperty("Name", SortingDirection.Ascending)); foreach (var item in xpCollectionI.OfType <Staff>()) { Debug.WriteLine($"{{Dep:{item.Dep}, Name:\"{item.Name}\"}}"); } xpCollectionII = new XPCollection(sessionI, typeof(Staff)); xpCollectionII.Sorting = new SortingCollection { new SortProperty("Dep", SortingDirection.Ascending), new SortProperty("Name", SortingDirection.Ascending) }; foreach (var item in xpCollectionII.OfType <Staff>()) { Debug.WriteLine($"{{Dep:{item.Dep}, Name:\"{item.Name}\"}}"); } #endif #if TEST_COLLECTION_FROM_COLLECTION var baseCollection = new XPCollection <Victim>(sessionI); foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } var falseCollection = new XPCollection(baseCollection, new BinaryOperator(new OperandProperty("FBit"), new OperandValue(false), BinaryOperatorType.Equal)); foreach (Victim item in falseCollection) { Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } var trueCollection = new XPCollection(baseCollection, new BinaryOperator(new OperandProperty("FBit"), new OperandValue(true), BinaryOperatorType.Equal)); foreach (Victim item in trueCollection) { Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } if ((tmpVictim = ((IBindingList)falseCollection).AddNew() as Victim) != null) { foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in falseCollection) { Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.FBit = false; foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in falseCollection) { Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.Save(); baseCollection.Reload(); foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in falseCollection) { Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } } if ((tmpVictim = ((IBindingList)falseCollection).AddNew() as Victim) != null) { foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in falseCollection) { Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.FBit = true; foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in falseCollection) { Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.Save(); foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in falseCollection) { Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } } if ((tmpVictim = ((IBindingList)trueCollection).AddNew() as Victim) != null) { foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in trueCollection) { Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.FBit = true; foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in trueCollection) { Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.Save(); foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in trueCollection) { Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } } if ((tmpVictim = ((IBindingList)trueCollection).AddNew() as Victim) != null) { foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in trueCollection) { Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.FBit = false; foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in trueCollection) { Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } tmpVictim.Save(); foreach (var item in baseCollection) { Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } foreach (Victim item in trueCollection) { Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}"); } } #endif #if TEST_LIFECYCLE using (unitOfWorkI = new UnitOfWork()) { xpCollectionI = new XPCollection(typeof(TestMaster)); AddEventsListeners(xpCollectionI); if ((tmpTestMaster = ((IBindingList)xpCollectionI).AddNew() as TestMaster) != null) { tmpTestMaster.Name = "Name"; tmpTestMaster.Save(); } foreach (TestMaster item in xpCollectionI) { System.Diagnostics.Debug.WriteLine(item.Id); } RemoveEventsListeners(xpCollectionI); } #endif #if TEST_ADD using (unitOfWorkI = new UnitOfWork()) { xpCollectionI = new XPCollection(unitOfWorkI, typeof(TestDE)); #if TEST_LIFECYCLE AddEventsListeners(xpCollectionI); #endif if ((tmpTestDE = ((IBindingList)xpCollectionI).AddNew() as TestDE) != null) { tmpTestDE.f1 = 1; } #if TEST_LIFECYCLE RemoveEventsListeners(xpCollectionI); #endif tmpTestMaster = new TestMaster(unitOfWorkI); #if TEST_LIFECYCLE AddEventsListeners(tmpTestMaster); AddEventsListeners(tmpTestMaster.Details); #endif if ((tmpTestDetail = ((IBindingList)tmpTestMaster.Details).AddNew() as TestDetail) != null) { tmpTestDetail.Name = "blah-blah-blah"; } #if TEST_LIFECYCLE RemoveEventsListeners(tmpTestMaster.Details); RemoveEventsListeners(tmpTestMaster); #endif } #endif #if TEST_MODIFY using (unitOfWorkI = new UnitOfWork()) { xpCollectionI = new XPCollection(unitOfWorkI, typeof(TestDE)); xpCollectionII = new XPCollection(unitOfWorkI, typeof(TestDE)); criteria = new BinaryOperator(new OperandProperty("id"), new OperandValue(1L), BinaryOperatorType.Equal); xpCollectionI.Filter = criteria; xpCollectionII.Filter = criteria; if (xpCollectionI.Count != 0) { tmpTestDE = xpCollectionI[0] as TestDE; } if (xpCollectionII.Count != 0) { tmpTestDEII = xpCollectionI[0] as TestDE; } if (tmpTestDE != null) { tmpTestDE.f1 = tmpTestDE.f1.HasValue ? tmpTestDE.f1.Value + 1 : 1; tmpTestDE.Save(); } if (tmpTestDEII != null) { tmpTestDEII.f1 = tmpTestDEII.f1.HasValue ? tmpTestDEII.f1.Value + 1 : 1; tmpTestDEII.Save(); } unitOfWorkI.CommitChanges(); } #endif #if TEST_LOAD xpCollectionI = new XPCollection(sessionI, testMasterClassInfo); xpCollectionI.Load(); xpCollectionI.Reload(); var listOfTestMaster = sessionI.GetObjects(testMasterClassInfo, new BinaryOperator("Name", "TEST An item with the same key has already been added 1:1", BinaryOperatorType.Equal), null, 0, 0, true, true).OfType <TestMaster>().ToList(); if (listOfTestMaster.Count > 0) { tmpTestMaster = listOfTestMaster[0]; if (tmpTestMaster.Details.Count > 0) { tmpString = tmpTestMaster.Details[0].Val; } } #endif #if TEST_An_item_with_the_same_key_has_already_been_added var listOfTestMaster = sessionI.GetObjects(testMasterClassInfo, new BinaryOperator("Name", "TEST An item with the same key has already been added 1:N", BinaryOperatorType.Equal), null, 0, 0, true, true).OfType <TestMaster>().ToList(); if (listOfTestMaster.Count > 0) { tmpTestMaster = listOfTestMaster[0]; tmpString = tmpTestMaster.DetailVal; } #endif #if TEST_CREATE if ((tmpTestMaster = testMasterClassInfo.CreateNewObject(sessionI) as TestMaster) != null) { tmpTestMaster.Name = DateTime.Now.Ticks.ToString(); tmpTestMaster.Details.AddRange(new[] { testDetailClassInfo.CreateNewObject(sessionI) as TestDetail, testDetailClassInfo.CreateNewObject(sessionI) as TestDetail, testDetailClassInfo.CreateNewObject(sessionI) as TestDetail }); tmpTestMaster.Details.ToList().ForEach(item => item.Name = DateTime.Now.Ticks.ToString()); sessionI.Save(tmpTestMaster); } #endif #if TEST_SET tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(1L); tmpInt = tmpTestMaster.Details.Count; sessionII = new Session(); tmpTestMasterII = sessionII.GetObjectByKey <TestMaster>(2L); tmpTestDetailII = sessionII.GetObjectByKey <TestDetail>(2L); tmpTestDetailII.Master = tmpTestMasterII; sessionII.Save(tmpTestDetailII); tmpInt = tmpTestMaster.Details.Count; #endif #if TEST_REMOVE tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(1L); tmpInt = tmpTestMaster.Details.Count; sessionII = new Session(); tmpTestMasterII = sessionII.GetObjectByKey <TestMaster>(1L); tmpTestDetailII = sessionII.GetObjectByKey <TestDetail>(2L); tmpTestMasterII.Details.Remove(tmpTestDetailII); sessionII.Save(new XPCustomObject[] { tmpTestMasterII, tmpTestDetailII }); tmpInt = tmpTestMaster.Details.Count; #endif }