//End SingleTon private void FrmBOM_Load(object sender, EventArgs e) { dataGridViewProjects.AllowUserToDeleteRows = false; try { _mrvc = new MRVersionController(); _LstMRVs = _mrvc.GetModels(); _dtMRVs = ToDataTable <MRVersion>(_LstMRVs); _dtMRVs.Columns.Remove("Project"); _dtMRVs.Columns.Remove("MRs"); _dtMRVs.Columns.Remove("IsModified"); //_dtProjects.Columns.Remove("ProjectEmployeeDetails"); //_dtProjects.Columns.Remove("CreatedBy"); //_dtProjects.Columns.Remove("UpdatedBy"); DataView dv = _dtMRVs.DefaultView; dv.Sort = "DateCreated desc"; _dtMRVs = dv.ToTable(); dataGridViewProjects.DataSource = _dtMRVs; dataGridViewProjects.Columns["Id"].Visible = false; dataGridViewProjects.Columns["VersionNo"].HeaderText = "MIR Number"; if (_LstMRVs.Count == 0) { _newMode = true; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//End SingleTon private void FrmBOM_Load(object sender, EventArgs e) { try { if (LoginInfo.LoginEmployee.EmployeeTypeCode == Constants.EMPLOYEE) { } _currentLoadedProject = CurrentOpenProject.CurrentProject; _mrvc = new MRVersionController(); _LstMRVersion = _mrvc.GetModels(); //_mrc = new MRController(); //_mrc.GetModelByID() var bindingSource3 = new BindingSource(); //_LstMRVersion= _LstMRVersion.OrderByDescending(c => c.Version).ToList(); bindingSource3.DataSource = _LstMRVersion.OrderByDescending(c => c.VersionNo).ToList(); cmbMRList.DisplayMember = "VersionNo"; cmbMRList.ValueMember = "Id"; cmbMRList.SelectedIndex = -1; cmbMRList.DataSource = bindingSource3.DataSource; if (cmbMRList.Items.Count == 0) { MessageBox.Show("Please first create Material Request"); btnSave.Enabled = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void editToolStripMenuItem_Click(object sender, EventArgs e) { _mrvc = new MRVersionController(); //_currentLoadedProject = _mrc.GetModelByID(_projectCode); CurrentOpenProject.CurrentProject = _currentLoadedProject; //for (int i = Application.OpenForms.Count - 1; i >= 0; i--) //{ // if (Application.OpenForms[i].Name != "FrmMDI" && Application.OpenForms[i].Name != "FrmMRs") // Application.OpenForms[i].Close(); //} this.Close(); //////////////// FrmEditProject_Show(); }
private void btnSave_Click(object sender, EventArgs e) { //DialogResult dialogResult = MessageBox.Show("Do you want to save?", "Confirmation", MessageBoxButtons.YesNo); //if (dialogResult == DialogResult.No) return; SaveFileDialog savefile = new SaveFileDialog(); // set a default file name string datetime = DateTime.Now.ToString("yyyyMMddHHmmss"); datetime = datetime.Replace(":", ""); savefile.FileName = "Material Request " + datetime + ".xlsx"; // set filters - this can be done in properties as well savefile.Filter = "Excel Workbook (*.xlsx)|*.xlsx|All files (*.*)|*.*"; if (savefile.ShowDialog() == DialogResult.OK) { 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(); 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); } //fill MR Verion first _mrvc = new MRVersionController(); _maxMRVersionAutoRowId = _mrvc.GetMaxMRVersionAutoRowId(); MRVersion mrvModel = new MRVersion(); mrvModel.ProjectCode = _currentLoadedProject.ProjectCode; //mrvModel.Version = _maxMRVersion mrvModel.IsVersion = false; mrvModel.Reason = textBox1.Text; string strVerNo = string.Empty; if (_currentMRVersionDesc.Substring(_currentMRVersionDesc.IndexOf("-MR-")).Contains("-REV")) { strVerNo = _currentMRVersionDesc.Substring(0, _currentMRVersionDesc.IndexOf("-REV")); mrvModel.Revision = _mrvc.GetMaxMRVersionNo(mrvModel.IsVersion.Value, strVerNo).ToString("00"); mrvModel.VersionNo = strVerNo + "-REV" + mrvModel.Revision; } else { //decimal returnedValue = _mrvc.GetMaxMRVersionNo(mrvModel.IsVersion.Value, _currentMRVersionDesc)-1; //returnedValue -= 1; mrvModel.Revision = _mrvc.GetMaxMRVersionNo(mrvModel.IsVersion.Value, _currentMRVersionDesc).ToString("00"); mrvModel.VersionNo = _currentMRVersionDesc + "-REV" + mrvModel.Revision; } //mrvModel.VersionNo = _currentLoadedProject.ProjectCode.ToString() + "-MR-" + mrvModel.Revision; //mrvModel.VersionNo = _currentMRVerionDesc + "-REV01" + //string strVer =string.Empty; //int intVer = 0; //if (_currentMRVersionDesc.Substring(_currentMRVersionDesc.IndexOf("-MR-")).Contains("-REV")) //{ // strVer = _currentMRVersionDesc.Substring(_currentMRVersionDesc.IndexOf("-MR-")); // intVer = int.Parse( strVer.Substring(strVer.IndexOf("-REV") + 4)); // intVer += 1; // //"20200626120629-MR-05-REV1" // mrvModel.VersionNo = _currentMRVersionDesc.Replace("-REV1", "-REV" + intVer);// //+ "-REV" + intLastVer; //} //else //{ // mrvModel.VersionNo = _currentMRVersionDesc + "-REV1"; //} mrvModel.IsModified = true; mrvModel.DateCreated = DateTime.Now; _mrvc = new MRVersionController(mrvModel); _mrvc.Save(); // _LstObjBoms = new List <MR>(); FillBOMModel2(); _mrc = new MRController(_LstObjBoms); _mrc.SaveList(projModel.ProjectCode, _maxMRVersionAutoRowId); ///////////////export to excel///////////////// // Here is main process Microsoft.Office.Interop.Excel.Application objexcelapp = new Microsoft.Office.Interop.Excel.Application(); objexcelapp.Application.Workbooks.Add(Type.Missing); objexcelapp.Columns.AutoFit(); for (int i = _dtExportMRtoExcel.Columns.Count - 1; i >= 0; i--) { if (!(_dtExportMRtoExcel.Columns[i].ColumnName == "PartNo" || _dtExportMRtoExcel.Columns[i].ColumnName == "Qty")) { _dtExportMRtoExcel.Columns.RemoveAt(i); } } for (int i = 1; i < _dtExportMRtoExcel.Columns.Count + 1; i++) { if (_dtExportMRtoExcel.Columns[i - 1].ColumnName == "PartNo" || _dtExportMRtoExcel.Columns[i - 1].ColumnName == "Qty") { Microsoft.Office.Interop.Excel.Range xlRange = (Microsoft.Office.Interop.Excel.Range)objexcelapp.Cells[1, i]; xlRange.Font.Bold = -1; xlRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous; xlRange.Borders.Weight = 1d; xlRange.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter; objexcelapp.Cells[1, i] = _dtExportMRtoExcel.Columns[i - 1].ColumnName; } } /*For storing Each row and column value to excel sheet*/ for (int i = 0; i < _dtExportMRtoExcel.Rows.Count; i++) { for (int j = 0; j < _dtExportMRtoExcel.Columns.Count; j++) { if (_dtExportMRtoExcel.Columns[j].ColumnName == "PartNo" || _dtExportMRtoExcel.Columns[j].ColumnName == "Qty") { if (_dtExportMRtoExcel.Rows[i][j] != null) { Microsoft.Office.Interop.Excel.Range xlRange = (Microsoft.Office.Interop.Excel.Range)objexcelapp.Cells[i + 2, j + 1]; xlRange.Borders.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous; xlRange.Borders.Weight = 1d; objexcelapp.Cells[i + 2, j + 1] = _dtExportMRtoExcel.Rows[i][j].ToString(); } } } } objexcelapp.Columns.AutoFit(); // Auto fix the columns size System.Windows.Forms.Application.DoEvents(); MessageBox.Show("Save and exported successfully"); //if (Directory.Exists("C:\\CTR_Data\\")) // Folder dic //{ // objexcelapp.ActiveWorkbook.SaveCopyAs("C:\\CTR_Data\\" + "excelFilename" + ".xlsx"); //} //else //{ // Directory.CreateDirectory("C:\\CTR_Data\\"); // objexcelapp.ActiveWorkbook.SaveCopyAs("C:\\CTR_Data\\" + "excelFilename" + ".xlsx"); //} objexcelapp.ActiveWorkbook.SaveCopyAs(savefile.FileName); objexcelapp.ActiveWorkbook.Saved = true; System.Windows.Forms.Application.DoEvents(); //foreach (Process proc in System.Diagnostics.Process.GetProcessesByName("EXCEL")) //{ // proc.Kill(); //} /////// //System.Diagnostics.Process.Start(savefile.FileName); //////////////update shared object/////////////////// _pc = new ProjectController(); CurrentOpenProject.CurrentProject = _pc.GetModelByID(CurrentOpenProject.CurrentProject.ProjectCode); ////////////// this.Enabled = true; //this.Close(); } }