private void btnDelete_Click(object sender, EventArgs e) { if (txtCode.Text != "") { DLMaterial objDLMaterial = new DLMaterial(); int ID = objDLMaterial.FetchIDbyCode(txtCode.Text); if (ID > 0) { if (objDLMaterial.DeleteByID(ID) > 0) { MessageBox.Show("Record Deleted"); ClearControls(); } else { MessageBox.Show("Record not Deleted"); } } else { MessageBox.Show("Invalid Code"); } } else { MessageBox.Show("Invalid Code"); } }
private void btnDisplay_Click(object sender, EventArgs e) { gvMaterial.Visible = true; ClearControls(); DLMaterial objDLMaterial = new DLMaterial(); gvMaterial.DataSource = objDLMaterial.FetchMaterials(); if (gvMaterial.Rows.Count > 0) { for (int i = 0; i <= gvMaterial.Rows.Count - 1; i++) { gvMaterial.Columns[0].Visible = false; } } // gvMaterial.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); }
private void gvMaterial_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex > 0) { string strCode = gvMaterial.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); string materialID = gvMaterial.Rows[e.RowIndex].Cells[0].Value.ToString(); ELMaterial objELMaterial = new ELMaterial(); DLMaterial objDLMaterial = new DLMaterial(); objELMaterial = objDLMaterial.FetchMaterialsByID(Convert.ToInt32(materialID)); if (objELMaterial != null) { lblMaterialID.Text = objELMaterial.ID.ToString(); txtCode.Text = objELMaterial.Code; txtName.Text = objELMaterial.Name; chkIsActive.Checked = Convert.ToBoolean( objELMaterial.IsActive); } } gvMaterial.Visible = false; }
private void btnSave_Click(object sender, EventArgs e) { ELMaterial objELMaterail = new ELMaterial(); DLMaterial objDLMaterial = new DLMaterial(); int newID = 0; if (lblMaterialID.Text.Length > 0) { objELMaterail.ID = Convert.ToInt32(lblMaterialID.Text); } else { newID = Common.GetNewID(tableName); objELMaterail.ID = newID; } objELMaterail.Code = txtCode.Text; objELMaterail.Name = txtName.Text; objELMaterail.Creator = 0; objELMaterail.Created = DateTime.Now; objELMaterail.IsActive = false; if (chkIsActive.Checked) objELMaterail.IsActive = true; if (Validations()) { if (objDLMaterial.Add(objELMaterail) > 0) { MessageBox.Show("Record Inserted"); // ClearControls(); } else { MessageBox.Show("Record not Inserted"); } } }