public DataSet1 getMaterials() { MaterialDataAccessor DA = new MaterialDataAccessor(); PositionDataAccessor DApos = new PositionDataAccessor(); DataSet1 dataSet1 = new DataSet1(); AbstractConnection absConnection = null; AbstractTransaction absTransaction = null; try { absConnection = DBFactory.createConnection(); absConnection.open(); absTransaction = absConnection.beginTransaction(); DA.Read(absConnection, absTransaction, dataSet1); DApos.Read(absConnection, absTransaction, dataSet1); absTransaction.commit(); } catch (Exception e) { absTransaction.rollback(); } finally { absConnection.close(); } return(dataSet1); }
public void updateMaterials(DataSet1 dataSet1) { MaterialDataAccessor DA = new MaterialDataAccessor(); PositionDataAccessor DApos = new PositionDataAccessor(); AbstractConnection absConnection = null; AbstractTransaction absTransaction = null; try { absConnection = DBFactory.createConnection(); absConnection.open(); absTransaction = absConnection.beginTransaction(); DA.Update(absConnection, absTransaction, dataSet1); DApos.Update(absConnection, absTransaction, dataSet1); absTransaction.commit(); } catch (Exception e) { absTransaction.rollback(); } finally { absConnection.close(); } }
public ActionResult GetTreeItems(string organizationId, string materialType) { string jsonTree = string.Empty; try { var organizationList = HttpRuntime.Cache.GetOrInsert <List <Models.Shared.Organization> >("Organizations", () => OrganizationDataAccessor.GetAllOrganizations()); RequestResult result = MaterialDataAccessor.GetTreeItems(organizationList, new Guid(organizationId), materialType, Session["Account"] as Account); if (result.IsSuccess) { jsonTree = JsonConvert.SerializeObject((List <TreeItem>)result.Data); } else { jsonTree = string.Empty; } } catch (Exception ex) { Logger.Log(MethodBase.GetCurrentMethod(), ex); jsonTree = string.Empty; } return(Content(jsonTree)); }
public void GetAll() { //Setup(); MaterialDataAccessor daMaterial = new MaterialDataAccessor(); DataSet1 dataSet1 = new DataSet1(); AbstractConnection connection = null; AbstractTransaction transaction = null; try { connection = DBFactory.createConnection(); connection.open(); transaction = connection.beginTransaction(); daMaterial.Read(connection, transaction, dataSet1); transaction.commit(); } catch (Exception e) { transaction.rollback(); } finally { connection.close(); } List <DataRow> list = dataSet1.material.Select().OfType <DataRow>().ToList(); list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); //сортируем по ид Assert.That(1, Is.EqualTo(1)); Assert.That(list.Count, Is.EqualTo(8)); Assert.That((int)(list[0]["id"]), Is.EqualTo(1)); Assert.That((string)(list[0]["name_material"]), Is.EqualTo("Бревна буковые")); Assert.That((string)(list[0]["code_material"]), Is.EqualTo("02.20.12.112")); }
public void materialByName() { MaterialDataAccessor daMaterial = new MaterialDataAccessor(); DataSet1 dataSet1 = new DataSet1(); AbstractConnection connection = null; AbstractTransaction transaction = null; try { connection = DBFactory.createConnection(); connection.open(); transaction = connection.beginTransaction(); daMaterial.Read(connection, transaction, dataSet1); transaction.commit(); } catch (Exception e) { transaction.rollback(); } finally { connection.close(); } List <DataRow> list = dataSet1.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList(); Assert.That(list.Count, Is.EqualTo(1)); Assert.That((int)(list[0]["id"]), Is.EqualTo(1)); Assert.That((string)(list[0]["name_material"]), Is.EqualTo("Бревна буковые")); Assert.That((string)(list[0]["code_material"]), Is.EqualTo("02.20.12.112")); }
public ActionResult Detail(string materialId) { RequestResult requestResult = MaterialDataAccessor.GetDetailViewModel(materialId, Session["Account"] as Account); if (requestResult.IsSuccess) { return(PartialView("_Detail", requestResult.Data)); } else { return(PartialView("_Error", requestResult.Error)); } }
public ActionResult Query(QueryParameters queryParameters) { RequestResult result = MaterialDataAccessor.Query(queryParameters, Session["Account"] as Account); if (result.IsSuccess) { return(PartialView("_List", result.Data)); } else { return(PartialView("_Error", result.Error)); } }
public ActionResult Copy(string materialId) { RequestResult requestResult = MaterialDataAccessor.GetCopyFormModel(new Guid(materialId)); if (requestResult.IsSuccess) { Session["MaterialFormAction"] = Define.EnumFormAction.Create; Session["MaterialCreateFormModel"] = requestResult.Data; return(PartialView("_Create", requestResult.Data)); } else { return(PartialView("_Error", requestResult.Error)); } }
public ActionResult Create(string organizationId, string materialType) { RequestResult requestResult = MaterialDataAccessor.GetCreateFormModel(organizationId, materialType); if (requestResult.IsSuccess) { Session["MaterialFormAction"] = Define.EnumFormAction.Create; Session["MaterialCreateFormModel"] = requestResult.Data; return(PartialView("_Create", requestResult.Data)); } else { return(PartialView("_Error", requestResult.Error)); } }
public ActionResult Delete(string selecteds) { RequestResult requestResult = new RequestResult(); try { var selectedList = JsonConvert.DeserializeObject <List <string> >(selecteds); requestResult = MaterialDataAccessor.Delete(selectedList); } catch (Exception e) { var error = new Error(MethodBase.GetCurrentMethod(), e); Logger.Log(error); requestResult.ReturnError(error); } return(Content(JsonConvert.SerializeObject(requestResult))); }
public ActionResult Edit(EditFormModel editFormModel, string pageStates) { RequestResult requestResult = new RequestResult(); try { var model = Session["MaterialEditFormModel"] as EditFormModel; var pageStateList = JsonConvert.DeserializeObject <List <string> >(pageStates); requestResult = MaterialDataAccessor.SavePageState(model.MaterialSpecificationModels, pageStateList); if (requestResult.IsSuccess) { model.MaterialSpecificationModels = requestResult.Data as List <MaterialSpecificationModel>; model.FormInput = editFormModel.FormInput; requestResult = MaterialDataAccessor.Edit(model); if (requestResult.IsSuccess) { Session.Remove("MaterialFormAction"); Session.Remove("MaterialEditFormModel"); } } } catch (Exception e) { var error = new Error(MethodBase.GetCurrentMethod(), e); Logger.Log(error); requestResult.ReturnError(error); } return(Content(JsonConvert.SerializeObject(requestResult))); }
public ActionResult InitTree() { try { var organizationList = HttpRuntime.Cache.GetOrInsert <List <Models.Shared.Organization> >("Organizations", () => OrganizationDataAccessor.GetAllOrganizations()); var account = Session["Account"] as Account; RequestResult result = new RequestResult(); if (account.RootOrganizationId == new Guid()) { result = MaterialDataAccessor.GetTreeItems(organizationList, account.RootOrganizationId, "", Session["Account"] as Account); } else { result = MaterialDataAccessor.GetRootTreeItem(organizationList, account.RootOrganizationId, Session["Account"] as Account); } if (result.IsSuccess) { return(PartialView("_Tree", JsonConvert.SerializeObject((List <TreeItem>)result.Data))); } else { return(PartialView("_Error", result.Error)); } } catch (Exception ex) { var err = new Error(MethodBase.GetCurrentMethod(), ex); Logger.Log(err); return(PartialView("_Error", err)); } }
public ActionResult UploadPhoto(string UniqueID) { RequestResult result = new RequestResult(); try { if (Request.Files != null && Request.Files.Count > 0 && Request.Files[0].ContentLength > 0) { var photoName = Request.Files[0].FileName.Substring(Request.Files[0].FileName.LastIndexOf('\\') + 1); var extension = photoName.Substring(photoName.LastIndexOf('.') + 1); result = MaterialDataAccessor.UploadPhoto(UniqueID, extension); if (result.IsSuccess) { Request.Files[0].SaveAs(Path.Combine(Config.MaintenancePhotoFolderPath, string.Format("{0}.{1}", UniqueID, extension))); } result.Success(); } else { result.ReturnFailedMessage(Resources.Resource.UploadFileRequired); } } catch (Exception ex) { Error err = new Error(MethodBase.GetCurrentMethod(), ex); Logger.Log(err); result.ReturnError(err); } return(Content(JsonConvert.SerializeObject(result))); }
public void materialDelete() { DataSet1 dataSetRead = new DataSet1(); MaterialDataAccessor daMaterial = new MaterialDataAccessor(); AbstractConnection absCon_Read = null; AbstractTransaction absTran_Read = null; int countRowBefore = 0; try { absCon_Read = DBFactory.createConnection(); absCon_Read.open(); absTran_Read = absCon_Read.beginTransaction(); daMaterial.Read(absCon_Read, absTran_Read, dataSetRead); List <DataRow> rows_list = dataSetRead.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList(); // Сортируем строки по id в порядке возрастания rows_list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); // Количество записей до удаления countRowBefore = rows_list.Count(); absTran_Read.commit(); } catch (Exception e) { absTran_Read.rollback(); } finally { absCon_Read.close(); } Assert.That(countRowBefore, Is.EqualTo(1)); // НОВОЕ СОЕДИНЕНИЕ, удаляем AbstractConnection absCon_Update = null; AbstractTransaction absTran_Update = null; List <DataRow> list_1 = dataSetRead.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList(); foreach (DataRow rowForDel in list_1) { dataSetRead.material.Rows.Remove(rowForDel); } try { absCon_Update = DBFactory.createConnection(); absCon_Update.open(); absTran_Update = absCon_Update.beginTransaction(); daMaterial.Update(absCon_Update, absTran_Update, dataSetRead); absTran_Update.commit(); } catch (Exception e) { absTran_Update.rollback(); } finally { absCon_Update.close(); } // Новый коннекшн, проверяем что теперь записей стало на одну больше AbstractConnection absCon_AfterInsert = null; AbstractTransaction absTran_AfterInsert = null; DataSet1 dataSet_AfterInsert = new DataSet1(); MaterialDataAccessor MaterialDA_AfterInsert = new MaterialDataAccessor(); try { absCon_AfterInsert = DBFactory.createConnection(); absCon_AfterInsert.open(); absTran_AfterInsert = absCon_AfterInsert.beginTransaction(); MaterialDA_AfterInsert.Read(absCon_AfterInsert, absTran_AfterInsert, dataSet_AfterInsert); absTran_AfterInsert.commit(); } catch (Exception e) { absTran_AfterInsert.commit(); } finally { absCon_AfterInsert.close(); } List <DataRow> rows_list_AfterInsert = dataSetRead.material.Select("name_material = 'Бревна буковые'").OfType <DataRow>().ToList(); Assert.That(rows_list_AfterInsert.Count, Is.EqualTo(0)); }
public void materialAdd() { DataSet1 dataSetRead = new DataSet1(); MaterialDataAccessor daMaterial = new MaterialDataAccessor(); AbstractConnection absCon_Read = null; AbstractTransaction absTran_Read = null; int countRowBefore = 0; try { absCon_Read = DBFactory.createConnection(); absCon_Read.open(); absTran_Read = absCon_Read.beginTransaction(); daMaterial.Read(absCon_Read, absTran_Read, dataSetRead); List <DataRow> rows_list = dataSetRead.material.Select("").OfType <DataRow>().ToList(); // Сортируем строки по id в порядке возрастания rows_list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); // Количество записей до внесения новой countRowBefore = rows_list.Count(); absTran_Read.commit(); } catch (Exception e) { absTran_Read.rollback(); } finally { absCon_Read.close(); } // НОВОЕ СОЕДИНЕНИЕ, Добавляем в базу новую запись AbstractConnection absCon_Update = null; AbstractTransaction absTran_Update = null; List <DataRow> list_1 = dataSetRead.material.Select("").OfType <DataRow>().ToList(); // Сортируем строки по айдишнику в порядке возрастания list_1.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); /// DataRow rowForAdded = dataSetRead.material.NewRow(); rowForAdded["name_material"] = "Бревна буковые"; rowForAdded["code_material"] = "02.20.12.112"; dataSetRead.material.Rows.Add(rowForAdded); List <DataRow> list_2 = dataSetRead.material.Select("").OfType <DataRow>().ToList(); // Сортируем строки по айдишнику в порядке возрастания list_2.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); try { absCon_Update = DBFactory.createConnection(); absCon_Update.open(); absTran_Update = absCon_Update.beginTransaction(); daMaterial.Update(absCon_Update, absTran_Update, dataSetRead); absTran_Update.commit(); } catch (Exception e) { absTran_Update.rollback(); } finally { absCon_Update.close(); } // Новый коннекшн, проверяем что теперь записей стало на одну больше AbstractConnection absCon_AfterInsert = null; AbstractTransaction absTran_AfterInsert = null; DataSet1 dataSet_AfterInsert = new DataSet1(); MaterialDataAccessor MaterialDA_AfterInsert = new MaterialDataAccessor(); int countRowAfter = 0; try { absCon_AfterInsert = DBFactory.createConnection(); absCon_AfterInsert.open(); absTran_AfterInsert = absCon_AfterInsert.beginTransaction(); MaterialDA_AfterInsert.Read(absCon_AfterInsert, absTran_AfterInsert, dataSet_AfterInsert); absTran_AfterInsert.commit(); } catch (Exception e) { absTran_AfterInsert.commit(); } finally { absCon_AfterInsert.close(); } List <DataRow> rows_list_AfterInsert = dataSet_AfterInsert.material.Select("").OfType <DataRow>().ToList(); // Сортируем строки по айдишнику в порядке возрастания rows_list_AfterInsert.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); countRowAfter = rows_list_AfterInsert.Count(); // Проверяем, что записей стало на одну больше Assert.That(countRowAfter - countRowBefore, Is.EqualTo(1)); // Берем последнюю добавленную запись( для этого сортируем ) DataRow rowAfterInsert = rows_list_AfterInsert[rows_list_AfterInsert.Count - 1]; // Проверяем что запись добавилась правильно Assert.That(rowForAdded["name_material"], Is.EqualTo(rowAfterInsert["name_material"])); Assert.That(rowForAdded["code_material"], Is.EqualTo(rowAfterInsert["code_material"])); }
public void materialUpdate() { MaterialDataAccessor daMaterial = new MaterialDataAccessor(); DataSet1 dataSet1 = new DataSet1(); AbstractConnection connection = null; AbstractTransaction transaction = null; try { connection = DBFactory.createConnection(); connection.open(); transaction = connection.beginTransaction(); daMaterial.Read(connection, transaction, dataSet1); transaction.commit(); } catch (Exception e) { transaction.rollback(); } finally { connection.close(); } List <DataRow> list = dataSet1.material.Select("").OfType <DataRow>().ToList(); // Сортируем строки по айдишнику в порядке возрастания list.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); // Assert.That(list.Count, Is.EqualTo(2)); // всего две строки // Обновляем первую запись //CarDTO oldCarDTO = null; DataSet1.materialRow oldM = null; AbstractConnection connectionN = null; AbstractTransaction transactionN = null; String oldName = ""; try { connectionN = DBFactory.createConnection(); connectionN.open(); transactionN = connectionN.beginTransaction(); oldM = dataSet1.material[0]; oldName = oldM.name_material; // oldCarDTO = new CarDTO(dataSet1.car[0]); dataSet1.material[0].name_material = oldM.name_material + "_changed"; daMaterial.Update(connectionN, transactionN, dataSet1); transactionN.commit(); } catch (Exception e) { transactionN.rollback(); } finally { connectionN.close(); } // Заново читаем из базы, проверяем, что поменялось MaterialDataAccessor daUpdated = new MaterialDataAccessor(); DataSet1 dataSetUpdated = new DataSet1(); AbstractConnection connectionUpdated = null; AbstractTransaction transactionUpdated = null; try { connectionUpdated = DBFactory.createConnection(); connectionUpdated.open(); transactionUpdated = connectionUpdated.beginTransaction(); daUpdated.Read(connectionUpdated, transactionUpdated, dataSetUpdated); transactionUpdated.commit(); } catch (Exception e) { transactionUpdated.rollback(); } finally { connectionUpdated.close(); } // достаем из датасета все записи таблицы List <DataRow> list_3 = dataSetUpdated.material.Select("").OfType <DataRow>().ToList(); // Сортируем по id list_3.Sort((x, y) => ((int)x["id"]).CompareTo((int)y["id"])); // Проверяем что записей столько же Assert.That(list_3.Count, Is.EqualTo(8)); // Достае ту же запись List <DataRow> rows_list = dataSet1.material.Select("id = " + oldM.id).OfType <DataRow>().ToList(); // Проверяем что по такому id одна запись Assert.That(rows_list.Count, Is.EqualTo(1)); DataSet1.materialRow updatedM = dataSetUpdated.material[0]; Assert.That(oldM.id, Is.EqualTo(updatedM.id)); Assert.That(oldName, !Is.EqualTo(updatedM.name_material)); Assert.That(oldName + "_changed", Is.EqualTo(updatedM.name_material)); }
public ActionResult DeletePhoto(string UniqueID) { return(Content(JsonConvert.SerializeObject(MaterialDataAccessor.DeletePhoto(UniqueID)))); }
public ActionResult DeleteSelected(string materialSpecificationId, string pageStates) { RequestResult result = new RequestResult(); try { List <string> pageStateList = JsonConvert.DeserializeObject <List <string> >(pageStates); if ((Define.EnumFormAction)Session["MaterialFormAction"] == Define.EnumFormAction.Create) { var model = Session["MaterialCreateFormModel"] as CreateFormModel; result = MaterialDataAccessor.SavePageState(model.MaterialSpecificationModels, pageStateList); if (result.IsSuccess) { model.MaterialSpecificationModels = result.Data as List <MaterialSpecificationModel>; model.MaterialSpecificationModels.Remove(model.MaterialSpecificationModels.First(x => x.MaterialSpecificationId == materialSpecificationId)); model.MaterialSpecificationModels = model.MaterialSpecificationModels.OrderBy(x => x.Seq).ToList(); int seq = 1; foreach (var spec in model.MaterialSpecificationModels) { spec.Seq = seq; seq++; } Session["MaterialCreateFormModel"] = model; result.Success(); } } else if ((Define.EnumFormAction)Session["MaterialFormAction"] == Define.EnumFormAction.Edit) { var model = Session["MaterialEditFormModel"] as EditFormModel; result = MaterialDataAccessor.SavePageState(model.MaterialSpecificationModels, pageStateList); if (result.IsSuccess) { model.MaterialSpecificationModels = result.Data as List <MaterialSpecificationModel>; model.MaterialSpecificationModels.Remove(model.MaterialSpecificationModels.First(x => x.MaterialSpecificationId == materialSpecificationId)); model.MaterialSpecificationModels = model.MaterialSpecificationModels.OrderBy(x => x.Seq).ToList(); int seq = 1; foreach (var spec in model.MaterialSpecificationModels) { spec.Seq = seq; seq++; } Session["MaterialEditFormModel"] = model; result.Success(); } } else { result.ReturnFailedMessage(Resources.Resource.UnKnownOperation); } } catch (Exception ex) { Error err = new Error(MethodBase.GetCurrentMethod(), ex); Logger.Log(err); result.ReturnError(err); } return(Content(JsonConvert.SerializeObject(result))); }
public ActionResult AddSelect(string selecteds, string pageStates, string refOrganizationId) { RequestResult result = new RequestResult(); try { List <string> selectedList = JsonConvert.DeserializeObject <List <string> >(selecteds); List <string> pageStateList = JsonConvert.DeserializeObject <List <string> >(pageStates); if ((Define.EnumFormAction)Session["MaterialFormAction"] == Define.EnumFormAction.Create) { var model = Session["MaterialCreateFormModel"] as CreateFormModel; result = MaterialDataAccessor.SavePageState(model.MaterialSpecificationModels, pageStateList); if (result.IsSuccess) { model.MaterialSpecificationModels = result.Data as List <MaterialSpecificationModel>; result = MaterialDataAccessor.AddMaterialSpecification(model.MaterialSpecificationModels, selectedList, refOrganizationId); if (result.IsSuccess) { model.MaterialSpecificationModels = result.Data as List <MaterialSpecificationModel>; Session["MaterialCreateFormModel"] = model; } } } else if ((Define.EnumFormAction)Session["MaterialFormAction"] == Define.EnumFormAction.Edit) { var model = Session["MaterialEditFormModel"] as EditFormModel; result = MaterialDataAccessor.SavePageState(model.MaterialSpecificationModels, pageStateList); if (result.IsSuccess) { model.MaterialSpecificationModels = result.Data as List <MaterialSpecificationModel>; result = MaterialDataAccessor.AddMaterialSpecification(model.MaterialSpecificationModels, selectedList, refOrganizationId); if (result.IsSuccess) { model.MaterialSpecificationModels = result.Data as List <MaterialSpecificationModel>; Session["MaterialEditFormModel"] = model; } } } else { result.ReturnFailedMessage(Resources.Resource.UnKnownOperation); } } catch (Exception ex) { Error err = new Error(MethodBase.GetCurrentMethod(), ex); Logger.Log(err); result.ReturnError(err); } return(Content(JsonConvert.SerializeObject(result))); }