private void SaveToRepository() { Project projModel; if (_newMode == true) { //SaveData(); projModel = FillProjectModel(); _pc = new ProjectController(projModel); _pc.Save(); Application.DoEvents(); //------------------ DataRow NewRow = _dtProjects.NewRow(); NewRow[0] = decimal.Parse(txtProjectCode.Text); NewRow[1] = txtProjectName.Text; NewRow[2] = txtProjectCustomerName.Text; NewRow[3] = txtProjectEndUser.Text; _dtProjects.Rows.Add(NewRow); dataGridViewProjects.DataSource = _dtProjects; //dataGridViewProjects.DataBindings(); _newMode = false; } else { //UpdateData(); projModel = FillProjectModel(); _pc = new ProjectController(projModel); _pc.UpdateModel(projModel); } List <BOM> LstObjBom; LstObjBom = FillBOMModel1(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 1); //--- LstObjBom = FillBOMModel2(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 2); //--- LstObjBom = FillBOMModel3(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 3); Project proj = _LstProjects.Where(book => book.ProjectCode == projModel.ProjectCode).FirstOrDefault(); if (proj == null) { _LstProjects.Add(projModel); } else { _LstProjects.Remove(proj); _LstProjects.Add(projModel); } }
public override void SaveModel() { try { BOMController controller = new BOMController(); Collection <BOM> collection = new Collection <BOM>(); if (Count > 0) { foreach (var model in Items) { BOM entity = new BOM(); CopyToModel(entity, model); entity.Id = Guid.NewGuid(); var executeResult = controller.GetProcessingAtlasId(model.ProcessingAtlas); if (!executeResult.HasError) { entity.ProcessingAtlasId = executeResult.Result; } entity.CreateTime = DateTime.Now; var createuser = controller.GetCurrentLoginUser().Result; if (createuser != null) { entity.CreateUserId = (createuser.UserId); } else { entity.CreateUserId = Guid.Empty; } collection.Add(entity); } var executeResult2 = controller.Imports(collection); if (executeResult2.HasError) { Errors = executeResult2.Errors; HasError = executeResult2.HasError; } } } catch (Exception ex) { setErrortoModel(this, ex); } }
private void btnSave_Click(object sender, EventArgs e) { Project projModel = FillProjectModel(); ProjectController pc = new ProjectController(projModel); pc.Save(); //------------------ BOMController bc; List <BOM> LstObjBom; LstObjBom = FillBOMModel1(projModel.ProjectCode); bc = new BOMController(LstObjBom); bc.SaveList(); //--- LstObjBom = FillBOMModel2(projModel.ProjectCode); bc = new BOMController(LstObjBom); bc.SaveList(); //--- LstObjBom = FillBOMModel3(projModel.ProjectCode); bc = new BOMController(LstObjBom); bc.SaveList(); }
private void btnSave_Click(object sender, EventArgs e) { this.Enabled = false; Project projModel; ProjectEmployeeDetail ped; if (_newMode == true) { //SaveData(); projModel = FillProjectModel(); projModel.CreatedBy = LoginInfo.LoginEmployee.EmployeeCode; projModel.CreatedDate = DateTime.Now; _pc = new ProjectController(projModel); _pc.Save(); //------------------ DataRow NewRow = _dtProjects.NewRow(); NewRow[0] = projModel.ProjectCode; //decimal.Parse(txtProjectCode.Text); NewRow[1] = projModel.ProjectName; //txtProjectName.Text; NewRow[2] = projModel.Customer; //txtProjectCustomerName.Text; NewRow[3] = projModel.EndUser; //txtProjectEndUser.Text; _dtProjects.Rows.Add(NewRow); DataView dv = _dtProjects.DefaultView; dv.Sort = "ProjectCode desc"; _dtProjects = dv.ToTable(); dataGridViewProjects.DataSource = _dtProjects; _LstProjects.Add(projModel); //------------------ ped = new ProjectEmployeeDetail(); ped.EmployeeCode = LoginInfo.LoginEmployee.EmployeeCode; //_EmployeeCode; ped.ProjectCode = projModel.ProjectCode; //(decimal)row1["ProjectCode"]; _pedc = new ProjectEmployeeDetailController(ped); _pedc.Save(); //------------------- _newMode = false; } else { //UpdateData(); projModel = FillProjectModel(); projModel.CreatedBy = _currentLoadedProject.CreatedBy; projModel.CreatedDate = _currentLoadedProject.CreatedDate; projModel.UpdatedBy = LoginInfo.LoginEmployee.EmployeeCode; projModel.UpdateDate = DateTime.Now; _pc = new ProjectController(projModel); _pc.UpdateModel(projModel); Project proj = _LstProjects.Where(x => x.ProjectCode == projModel.ProjectCode).FirstOrDefault(); _LstProjects.Remove(proj); _LstProjects.Add(projModel); } List <BOM> LstObjBom; LstObjBom = FillBOMModel1(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 1); //--- LstObjBom = FillBOMModel2(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 2); //--- LstObjBom = FillBOMModel3(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 3); //Project proj = _LstProjects.Where(x => x.ProjectCode == projModel.ProjectCode).FirstOrDefault(); //if (proj == null) //{ // _LstProjects.Add(projModel); //} //else //{ // _LstProjects.Remove(proj); // _LstProjects.Add(projModel); //} //_LstProjects this.Enabled = true; }
private void btnSave_Click(object sender, EventArgs e) { this.Enabled = false; Project projModel; if (_newMode == true) { //SaveData(); projModel = FillProjectModel(); _pc = new ProjectController(projModel); _pc.Save(); //------------------ DataRow NewRow = _dtProjects.NewRow(); NewRow[0] = decimal.Parse(txtProjectCode.Text); NewRow[1] = txtProjectName.Text; NewRow[2] = txtProjectCustomerName.Text; NewRow[3] = txtProjectEndUser.Text; _dtProjects.Rows.Add(NewRow); dataGridViewProjects.DataSource = _dtProjects; //dataGridViewProjects.DataBindings(); _newMode = false; } else { //UpdateData(); projModel = FillProjectModel(); _pc = new ProjectController(projModel); _pc.UpdateModel(projModel); } List <BOM> LstObjBom; LstObjBom = FillBOMModel1(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 1); //--- LstObjBom = FillBOMModel2(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 2); //--- LstObjBom = FillBOMModel3(ref projModel); _bc = new BOMController(LstObjBom); _bc.SaveList(projModel.ProjectCode, 3); Project proj = _LstProjects.Where(book => book.ProjectCode == projModel.ProjectCode).FirstOrDefault(); if (proj == null) { _LstProjects.Add(projModel); } else { _LstProjects.Remove(proj); _LstProjects.Add(projModel); } //_LstProjects this.Enabled = true; DataView dv = _dtProjects.DefaultView; dv.Sort = "ProjectCode desc"; _dtProjects = dv.ToTable(); }
private void dataGridViewProjects_SelectionChanged(object sender, EventArgs e) { if (dataGridViewProjects.SelectedCells.Count > 0) { int selectedrowindex = dataGridViewProjects.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dataGridViewProjects.Rows[selectedrowindex]; _projectCode = Convert.ToDecimal(selectedRow.Cells["ProjectCode"].Value); //MessageBox.Show(a); BOMController bc = new BOMController(); ProjectController pc = new ProjectController(); //List<BOM> LstObjBom; //LstObjBom = FillBOMModel1(projModel.ProjectCode); //bc = new BOMController(LstObjBom); //lObjBom.SORef = gvr.Cells[0].Value.ToString(); //lObjBom.SerialNo = gvr.Cells[1].Value.ToString(); //lObjBom.ProductCategory = gvr.Cells[2].Value.ToString(); //lObjBom.Product = gvr.Cells[3].Value.ToString(); //lObjBom.CostHead = gvr.Cells[4].Value.ToString(); //lObjBom.CostSubHead = gvr.Cells[5].Value.ToString(); //lObjBom.System = gvr.Cells[6].Value.ToString(); //lObjBom.Area = gvr.Cells[7].Value.ToString(); //lObjBom.Panel = gvr.Cells[8].Value.ToString(); //lObjBom.Category = gvr.Cells[9].Value.ToString(); //lObjBom.Manufacturer = gvr.Cells[10].Value.ToString(); //lObjBom.PartNo = gvr.Cells[11].Value.ToString(); //lObjBom.Description = gvr.Cells[12].Value.ToString(); //lObjBom.Qty = gvr.Cells[13].Value.ToString(); //lObjBom.UnitCost = gvr.Cells[14].Value.ToString(); //lObjBom.ExCost = gvr.Cells[15].Value.ToString(); //lObjBom.UnitPrice = gvr.Cells[16].Value.ToString(); //lObjBom.ExPrice = gvr.Cells[17].Value.ToString(); var source1 = new BindingSource(); //List<BOM> list = new List<BOM> { new MyStruct("fff", "b"), new MyStruct("c", "d") }; List <BOM> list = bc.GetModels().Where(x => x.ProjectCode == _projectCode).ToList(); //public DataTable ToDataTable<T>(List<T> items) DataTable UserDt = ToDataTable <BOM>(list); UserDt.Columns.Remove("ProjectCode"); UserDt.Columns.Remove("RowAuto"); UserDt.Columns.Remove("BomTypeCode"); UserDt.Columns.Remove("BOMType"); UserDt.Columns.Remove("Project"); //ToDataTable<BOM>(List<BOM> list); dataGridView1.DataSource = UserDt; //dataGridView1.DataBind(); //source1.DataSource = list.Where(x => x.BOMTypeCode == 1).Select(x => new //{ // x.SORef, // x.SerialNo, // x.ProductCategory, // x.Product, // x.CostHead, // x.CostSubHead, // x.System, // x.Area, // x.Panel, // x.Category, // x.Manufacturer, // x.PartNo, // x.Description, // x.Qty, // x.UnitCost, // x.ExCost, // x.UnitPrice, // x.ExPrice //}); //dataGridView1.DataSource = source1; //this.dataGridView1.AllowUserToAddRows = true; var source2 = new BindingSource(); source2.DataSource = list.Where(x => x.BOMTypeCode == 2).Select(x => new { x.SORef, x.SerialNo, x.ProductCategory, x.Product, x.CostHead, x.CostSubHead, x.System, x.Area, x.Panel, x.Category, x.Manufacturer, x.PartNo, x.Description, x.Qty, x.UnitCost, x.ExCost, x.UnitPrice, x.ExPrice }); dataGridView2.DataSource = source2; this.dataGridView2.AllowUserToAddRows = true; var source3 = new BindingSource(); source3.DataSource = list.Where(x => x.BOMTypeCode == 3).Select(x => new { x.SORef, x.SerialNo, x.ProductCategory, x.Product, x.CostHead, x.CostSubHead, x.System, x.Area, x.Panel, x.Category, x.Manufacturer, x.PartNo, x.Description, x.Qty, x.UnitCost, x.ExCost, x.UnitPrice, x.ExPrice }); dataGridView3.DataSource = source3; this.dataGridView3.AllowUserToAddRows = true; Project project = pc.GetModelByID(_projectCode); txtProjectCode.Text = project.ProjectCode.ToString(); txtProjectName.Text = project.ProjectName; txtProjectCustomerName.Text = project.Customer; txtProjectEndUser.Text = project.Customer; } }