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;
}
}
