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)
{
}
}
