private Boolean updateDashBoard(productmodels pm, int stat) { Boolean status = true; try { dashboardalarm dsb = new dashboardalarm(); DashboardDB ddsDB = new DashboardDB(); dsb.DocumentID = docID; //dsb.TemporaryNo = pm.TemporaryNo; //dsb.TemporaryDate = pm.TemporaryDate; //dsb.DocumentNo = pm.DocumentNo; //dsb.DocumentDate = pm.DocumentDate; dsb.FromUser = Login.userLoggedIn; if (stat == 1) { dsb.ActivityType = 2; dsb.ToUser = prevpmodel.ForwardUser; if (!ddsDB.insertDashboardAlarm(dsb)) { MessageBox.Show("DashBoard Fail to update"); status = false; } } else if (stat == 2) { dsb.ActivityType = 3; List <documentreceiver> docList = DocumentReceiverDB.getDocumentWiseReceiver(docID); foreach (documentreceiver docRec in docList) { dsb.ToUser = docRec.EmployeeID; //To store UserID Form DocumentReceiver for current Document dsb.DocumentDate = UpdateTable.getSQLDateTime(); if (!ddsDB.insertDashboardAlarm(dsb)) { MessageBox.Show("DashBoard Fail to update"); status = false; } } } } catch (Exception ex) { status = false; } return(status); }
public void clearData() { try { //----------clear temperory panels clearTabPageControls(); pnlForwarder.Visible = false; txtModelName.Text = ""; txtModelNo.Text = ""; txtStockItemID.Text = ""; txtRemarks.Text = ""; prevpmodel = new productmodels(); //removeControlsFromForwarderPanel(); //removeControlsFromForwarderPanelTV(); } catch (Exception ex) { } }
private void grdList_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.RowIndex < 0) { return; } string columnName = grdList.Columns[e.ColumnIndex].Name; if (columnName.Equals("Edit") || columnName.Equals("Approve") || columnName.Equals("LoadDocument") || columnName.Equals("View")) { clearData(); setButtonVisibility(columnName); // QIHeaderDB qidb = new QIHeaderDB(); int rowID = e.RowIndex; btnSave.Text = "Update"; DataGridViewRow row = grdList.Rows[rowID]; prevpmodel = new productmodels(); prevpmodel.rowID = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["RowID"].Value.ToString()); prevpmodel.StockItemID = grdList.Rows[e.RowIndex].Cells["StockItem"].Value.ToString(); prevpmodel.StockItemName = grdList.Rows[e.RowIndex].Cells["StockItemName"].Value.ToString(); prevpmodel.ModelNo = grdList.Rows[e.RowIndex].Cells["ModelNo"].Value.ToString(); prevpmodel.ModelName = grdList.Rows[e.RowIndex].Cells["ModelName"].Value.ToString(); prevpmodel.Remarks = grdList.Rows[e.RowIndex].Cells["Remarks"].Value.ToString(); //--------Load Documents if (columnName.Equals("LoadDocument")) { string hdrString = "Model No:" + prevpmodel.ModelNo + "\n" + "Model Detail:" + prevpmodel.ModelName + "\n" + "Product ID:" + prevpmodel.StockItemID + "\n" + "Product Name:" + prevpmodel.StockItemName; string dicDir = Main.documentDirectory + "\\" + docID; string subDir = prevpmodel.StockItemID + "-" + prevpmodel.ModelNo; FileManager.LoadDocuments load = new FileManager.LoadDocuments(dicDir, subDir, docID, hdrString); load.ShowDialog(); this.RemoveOwnedForm(load); btnCancel_Click_2(null, null); return; } //-------- prevpmodel.Status = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["gStatus"].Value.ToString()); prevpmodel.CreateTime = DateTime.Parse(grdList.Rows[e.RowIndex].Cells["gCreateTime"].Value.ToString()); prevpmodel.CreateUser = grdList.Rows[e.RowIndex].Cells["gCreateUser"].Value.ToString(); prevpmodel.CreatorName = grdList.Rows[e.RowIndex].Cells["Creator"].Value.ToString(); prevpmodel.ForwardUser = grdList.Rows[e.RowIndex].Cells["ForwardUser"].Value.ToString(); prevpmodel.ApproveUser = grdList.Rows[e.RowIndex].Cells["ApproveUser"].Value.ToString(); prevpmodel.DocumentStatus = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["DocumentStatusNo"].Value.ToString()); prevpmodel.ForwarderName = grdList.Rows[e.RowIndex].Cells["Forwarder"].Value.ToString(); prevpmodel.ApproverName = grdList.Rows[e.RowIndex].Cells["Approver"].Value.ToString(); prevpmodel.ForwarderList = grdList.Rows[e.RowIndex].Cells["Forwarders"].Value.ToString(); txtModelName.Text = prevpmodel.ModelName.ToString(); txtModelNo.Text = prevpmodel.ModelNo.ToString(); txtRemarks.Text = prevpmodel.Remarks; txtStockItemID.Text = prevpmodel.StockItemID + "-" + prevpmodel.StockItemName; btnSave.Text = "Update"; pnlList.Visible = false; pnlAddEdit.Visible = true; btnSave.Text = "Update"; pnlList.Visible = false; pnlAddEdit.Visible = true; tabControl1.SelectedTab = tabProductModel; tabControl1.Visible = true; } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } }
private void btnSave_Click(object sender, EventArgs e) { Boolean status = true; try { ProductModelsDB pmdb = new ProductModelsDB(); productmodels pm = new productmodels(); System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btnSave.Text; try { pm.ModelName = txtModelName.Text; pm.StockItemID = txtStockItemID.Text.Substring(0, txtStockItemID.Text.IndexOf('-')); pm.Remarks = txtRemarks.Text; pm.ForwarderList = prevpmodel.ForwarderList; } catch (Exception ex) { MessageBox.Show("Validation failed"); return; } if (pmdb.validateProductModel(pm)) { if (btnText.Equals("Update")) { pm.DocumentStatus = prevpmodel.DocumentStatus; if (pmdb.updateProductModels(pm, prevpmodel)) { MessageBox.Show("Product Model Details updated"); closeAllPanels(); listOption = 1; ListFilteredProductModels(listOption, pid); } else { status = false; } if (!status) { MessageBox.Show("Failed to update Product Model"); } } else if (btnText.Equals("Save")) { pm.DocumentStatus = 1; if (pmdb.insertProductModel(pm)) { MessageBox.Show("Product Model Details Added"); closeAllPanels(); listOption = 1; ListFilteredProductModels(listOption, pid); } else { status = false; } if (!status) { MessageBox.Show("Failed to Insert Product Model"); } } } else { MessageBox.Show("Product Model Validation failed"); status = false; } } catch (Exception ex) { MessageBox.Show("Product Model(Save()) : Error"); status = false; } if (status) { setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save } }