private void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtDescription.Text != string.Empty && txtName.Text != string.Empty)
{
string strQuery = $"update Categorias set Nombre='{txtName.Text}',Descripcion = '{txtDescription.Text}' where id_categoria ={dgvCategorys.Rows[dgvCategorys.CurrentRow.Index].Cells[0].Value.ToString()} ";
frmInformation frmUpdateResult = new frmInformation("¿Actualizar categoria?");
DialogResult result = new DialogResult();
result = frmUpdateResult.ShowDialog();
if (result == DialogResult.OK)
{
DB.ExecuteQuery(strQuery);
frmRealizado frmCheced = new frmRealizado("Registro actualizado con exito");
result = frmCheced.ShowDialog();
if (result == DialogResult.OK)
{
frmCheced.Close();
dgvCategorys.DataSource = getInfoCategory();
dgvCategorys.Columns["id_categoria"].Visible = false;
txtDescription.Text = "";
txtName.Text = "";
}
}
}
else
{
MessageBox.Show("Rellene los Campos", "Campos Vacios", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception)
{
throw;
}
}
private void UpdateProduct()
{
if (txtName.Text != string.Empty && textBox1.Text != string.Empty && txtPriceSale.Text != string.Empty && txtDescription.Text != string.Empty)
{
string strQuery = $@"update Producto set Nombre='{txtName.Text}',Descripcion='{txtDescription.Text}',Precio_Unitario={textBox1.Text.Replace(",",".")},Precio_Compra={txtPriceSale.Text.Replace(",", ".")},
Categoria={CmCategory.SelectedValue.ToString()} where id_producto={dgvProducts.Rows[dgvProducts.CurrentRow.Index].Cells[0].Value.ToString()}";
frmInformation frmUpdate = new frmInformation("Actualzar Producto");
DialogResult result = new DialogResult();
result = frmUpdate.ShowDialog();
if (result == DialogResult.OK)
{
DB.ExecuteQuery(strQuery);
frmRealizado frmCheked = new frmRealizado("Producto Actualizado");
result = frmCheked.ShowDialog();
if (result == DialogResult.OK)
{
txtDescription.Text = "";
txtName.Text = "";
txtPriceSale.Text = "";
textBox1.Text = "";
UpdateTable();
}
}
}
else
{
MessageBox.Show("Rellene los Campos", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void DeleteProduct()
{
try
{
if (txtName.Text != string.Empty && textBox1.Text != string.Empty && txtPriceSale.Text != string.Empty && txtDescription.Text != string.Empty)
{
string strQuery = $"Delete from Producto where id_producto={dgvProducts.Rows[dgvProducts.CurrentRow.Index].Cells[0].Value.ToString()}";
frmInformation frmDelete = new frmInformation("¿Eliminar Producto?");
DialogResult result = new DialogResult();
result = frmDelete.ShowDialog();
if (result == DialogResult.OK)
{
DB.ExecuteQuery(strQuery);
UpdateTable();
frmRealizado frmchecked = new frmRealizado("Producto Eliminado");
result = frmchecked.ShowDialog();
if (result == DialogResult.OK)
{
txtDescription.Text = "";
txtName.Text = "";
txtPriceSale.Text = "";
textBox1.Text = "";
}
}
}
else
{
MessageBox.Show("Rellene los Campos", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception)
{
throw;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
clsParameter._isLoadHoSoDauThau = true;
Int64 _tongDiemKT = 0;
for (int i = 0; i < dtDiemKyThuat.Columns.Count; i++)
{
string _NHOM_KYTHUAT_CT_ID = dtDiemKyThuat.Columns[i].ColumnName;
if (_NHOM_KYTHUAT_CT_ID != "TONG_DIEM_KT")
{
_tongDiemKT += Convert.ToInt64(dtDiemKyThuat.Rows[0][i]);
string str = string.Format("update DAUTHAU_CT set DIEM={0} where DAUTHAU_ID = {1} and NHOM_KYTHUAT_CT_ID = {2}"
, dtDiemKyThuat.Rows[0][i]
, _dauThauID
, _NHOM_KYTHUAT_CT_ID);
SqlCommand cmd = new SqlCommand(str, clsConnection._conn);
cmd.ExecuteNonQuery();
//Cap nhat tong diem
str = string.Format("update DAU_THAU set TONG_DIEM_KT = {0} where DAUTHAU_ID = {1}", _tongDiemKT, _dauThauID);
cmd = new SqlCommand(str, clsConnection._conn);
cmd.ExecuteNonQuery();
}
}
frmInformation f = new frmInformation("Lưu dữ liệu thành công.");
f.ShowDialog();
}
private void pictureBox1_Click(object sender, EventArgs e)
{
try
{
frmInformation Info = new frmInformation("Salir");
DialogResult Result = new DialogResult();
Result = Info.ShowDialog();
if (Result == DialogResult.OK)
{
this.Close();
}
else
{
Info.Close();
}
}
catch (Exception)
{
throw;
}
}
private void BtnDelete_Click(object sender, EventArgs e)
{
try
{
if (txtDescription.Text != string.Empty && txtName.Text != string.Empty)
{
string strQuery = $"Delete from Categorias where Nombre ='{txtName.Text}' and Descripcion = '{txtDescription.Text}'";
DialogResult result = new DialogResult();
frmInformation frmDelete = new frmInformation("¿Eliminar Categoria?");
result = frmDelete.ShowDialog();
if (result == DialogResult.OK)
{
frmDelete.Close();
DB.ExecuteQuery(strQuery);
frmRealizado frmChecked = new frmRealizado("Categoria Eliminada");
result = frmChecked.ShowDialog();
if (result == DialogResult.OK)
{
frmChecked.Close();
dgvCategorys.DataSource = getInfoCategory();
dgvCategorys.Columns.Remove("id_categoria");
txtDescription.Text = "";
txtName.Text = "";
}
}
}
else
{
MessageBox.Show("Rellene los campos", "Campos Vacios", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception)
{
throw;
}
}