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");
}
}
}
