private void btnSave_Click(object sender, EventArgs e) { Boolean status = true; try { DocTcMappingDB tc = new DocTcMappingDB(); System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btnSave.Text; if (btnText.Equals("Save") || btnText.Equals("Update")) { if (createAndUpdateTermsAndConditions(tc)) { MessageBox.Show("Terms and Conditions updated"); closeAllPanels(); ListDocEmpMapping(); } else { status = false; } } if (!status) { MessageBox.Show("Failed to update Terms and condition mappiing"); } } catch (Exception ex) { MessageBox.Show("createAndUpdateTermsAndConditions() : Error"); } }
public void creategrid() { DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle(); dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; dataGridViewCellStyle1.BackColor = System.Drawing.Color.LightSeaGreen; dataGridViewCellStyle1.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText; dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight; dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText; dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True; tclist.EnableHeadersVisualStyles = false; tclist.AllowUserToAddRows = false; tclist.AllowUserToDeleteRows = false; tclist.BackgroundColor = System.Drawing.Color.White; tclist.BorderStyle = System.Windows.Forms.BorderStyle.None; tclist.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1; tclist.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter; tclist.ColumnHeadersHeight = 27; tclist.RowHeadersVisible = false; tclist.Columns.Clear(); tclist.Columns.Add("RowID", "RowID"); tclist.Columns.Add("Header", "Header"); tclist.Columns.Add("Detail", "Detail"); tclist.Bounds = new Rectangle(new Point(140, 60), new Size(820, 300)); pnlDocumentInner.Controls.Add(tclist); tclist.Columns["RowID"].Visible = false; tclist.Columns["Header"].Width = 200; tclist.Columns["Detail"].Width = 600; DocTcMappingDB dbrecord = new DocTcMappingDB(); List <doctcmapping> TCdocMappings = dbrecord.getdocTCList(txtDocument.Text); if (TCdocMappings.Count != 0) { foreach (doctcmapping dm in TCdocMappings) { tclist.Rows.Add(); tclist.Rows[tclist.RowCount - 1].Cells["RowID"].Value = dm.RowID; tclist.Rows[tclist.RowCount - 1].Cells["Header"].Value = dm.Heading; tclist.Rows[tclist.RowCount - 1].Cells["Detail"].Value = dm.Detail; tclist.Rows[tclist.RowCount - 1].Height = 60; tclist.DefaultCellStyle.WrapMode = DataGridViewTriState.True; } tclist.CurrentCell.Selected = false; foreach (DataGridViewColumn column in tclist.Columns) { column.SortMode = DataGridViewColumnSortMode.Automatic; } tclist.ReadOnly = true; tclist.Visible = true; } }
private Boolean createAndUpdateTermsAndConditions(DocTcMappingDB tcm) { Boolean status = true; try { DocTcMappingDB tcdb = new DocTcMappingDB(); doctcmapping tc = new doctcmapping(); int count = 0; List <doctcmapping> TCMDetails = new List <doctcmapping>(); foreach (DataGridViewRow row in tclist.Rows) { try { tc = new doctcmapping(); tc.DocumentID = txtDocument.Text; tc.ReferenceTC = row.Cells["RowID"].Value.ToString(); TCMDetails.Add(tc); count++; } catch (Exception ex) { MessageBox.Show("createAndUpdateTermsAndConditions() : Error creating Terms and Conditions mapping"); status = false; } } if (count == 0) { MessageBox.Show("No item selected"); status = false; } else { if (!tcdb.UpdateTCMapping(TCMDetails, tc)) { MessageBox.Show("createAndUpdateTermsAndConditions() : Failed to update Terms and Conditions mapping. Please check the values"); status = false; } } } catch (Exception) { MessageBox.Show("createAndUpdateTermsAndConditions() : Error updating Terms and Conditions."); status = false; } return(status); }
////private void Form1_Load(object sender, EventArgs e) ////{ //// try //// { //// ListDocEmpMapping(); //// } //// catch (Exception) //// { //// } ////} private void ListDocEmpMapping() { try { grdList.Rows.Clear(); DocTcMappingDB dbrecord = new DocTcMappingDB(); List <doctcmapping> TCMappings = dbrecord.getTCMapping(); foreach (doctcmapping doc in TCMappings) { grdList.Rows.Add(doc.DocumentID, doc.DocumentName); } } catch (Exception ex) { MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error"); } enableBottomButtons(); pnlDocumentList.Visible = true; }
private void showTCDataGridView() { try { frmPopup = new Form(); frmPopup.StartPosition = FormStartPosition.CenterScreen; frmPopup.BackColor = Color.CadetBlue; frmPopup.MaximizeBox = false; frmPopup.MinimizeBox = false; frmPopup.ControlBox = false; frmPopup.FormBorderStyle = FormBorderStyle.FixedSingle; frmPopup.Size = new Size(685, 370); Label lblSearch = new Label(); lblSearch.Location = new System.Drawing.Point(120, 5); lblSearch.AutoSize = true; lblSearch.Text = "Search by Name"; lblSearch.Font = new System.Drawing.Font("Microsoft Sans Serif", 9, FontStyle.Bold); lblSearch.ForeColor = Color.Black; frmPopup.Controls.Add(lblSearch); txtSearch = new TextBox(); txtSearch.Size = new Size(220, 18); txtSearch.Location = new System.Drawing.Point(250, 3); txtSearch.Font = new System.Drawing.Font("Microsoft Sans Serif", 9, FontStyle.Regular); txtSearch.ForeColor = Color.Black; txtSearch.TextChanged += new System.EventHandler(this.txtSearch_TextChangedInTCGridList); txtSearch.TabIndex = 0; txtSearch.Focus(); frmPopup.Controls.Add(txtSearch); DocTcMappingDB TcDB = new DocTcMappingDB(); grdEmpList = TcDB.getTclistGrid(); foreach (DataGridViewRow rows in tclist.Rows) { foreach (DataGridViewRow rw in grdEmpList.Rows) { if (rw.Cells["Heading"].Value.ToString() == rows.Cells["Header"].Value.ToString()) { rw.Cells["Select"].Value = true; } } } grdEmpList.Bounds = new Rectangle(new Point(0, 27), new Size(680, 300)); frmPopup.Controls.Add(grdEmpList); grdEmpList.Columns["DocumentID"].Visible = false; grdEmpList.Columns["DocumentName"].Visible = false; grdEmpList.Columns["ReferenceTC"].Visible = false; grdEmpList.Columns["RowID"].Visible = false; grdEmpList.Columns["ParagraphID"].Visible = false; grdEmpList.Columns["Heading"].Width = 130; grdEmpList.Columns["Detail"].Width = 499; grdEmpList.RowTemplate.Height = 80; foreach (DataGridViewColumn column in grdEmpList.Columns) { column.SortMode = DataGridViewColumnSortMode.Automatic; column.DefaultCellStyle.WrapMode = DataGridViewTriState.True; } grdEmpList.CurrentCell.Selected = false; grdEmpList.Columns["Heading"].ReadOnly = true; grdEmpList.Columns["Detail"].ReadOnly = true; Button lvOK = new Button(); lvOK.BackColor = Color.Tan; lvOK.Text = "OK"; lvOK.Location = new System.Drawing.Point(20, 335); lvOK.Click += new System.EventHandler(this.grdOK_Click1); frmPopup.Controls.Add(lvOK); Button lvCancel = new Button(); lvCancel.Text = "CANCEL"; lvCancel.BackColor = Color.Tan; lvCancel.Location = new System.Drawing.Point(110, 335); lvCancel.Click += new System.EventHandler(this.grdCancel_Click1); frmPopup.Controls.Add(lvCancel); frmPopup.ShowDialog(); } catch (Exception ex) { } }