public static bool UpdateUnit(Unit_DTO unit)
{
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_updateUnit]", con);
try
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@UnitID", unit.UnitID);
cmd.Parameters.Add(p);
p = new SqlParameter("@UnitName", unit.UnitName);
cmd.Parameters.Add(p);
p = new SqlParameter("@UnitPrice", unit.UnitPrice);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch
{
DataProvider.CloseConnection(con);
return(false);
}
}
private void btnAddUnit_Click(object sender, EventArgs e)
{
try
{
Unit_DTO unit = new Unit_DTO();
unit.UnitID = txtUnitID.Text;
unit.UnitName = txtUnitName.Text;
unit.UnitPrice = txtUnitPrice.Text;
if (txtUnitID.Text == "" || txtUnitName.Text == "" || txtUnitPrice.Text == "")
{
XtraMessageBox.Show("You have to fullfill unit information!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Warning);
ClearDisplay();
return;
}
if (Unit_BUS.InsertUnit(unit))
{
XtraMessageBox.Show("Unit Info has been inserted sucessfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoadUnitList();
ClearDisplay();
return;
}
}
catch
{
XtraMessageBox.Show("Insert Info Failed!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public static List <Unit_DTO> LoadUnit()
{
List <Unit_DTO> listUnit = new List <Unit_DTO>();
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_getUnitList]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
{
return(null);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
Unit_DTO unit = new Unit_DTO();
unit.UnitID = dt.Rows[i]["UnitID"].ToString();
unit.UnitName = dt.Rows[i]["UnitName"].ToString();
unit.UnitPrice = dt.Rows[i]["UnitPrice"].ToString();
listUnit.Add(unit);
}
DataProvider.CloseConnection(con);
return(listUnit);
}
public void btnDeleteUnit_Click(object sender, EventArgs e)
{
try
{
Unit_DTO unit = new Unit_DTO();
unit.UnitID = dtgvUnitInfoList.CurrentRow.Cells["UnitID"].Value.ToString();
unit.UnitName = txtUnitName.Text;
if (txtUnitID.Text == "" || txtUnitName.Text == "" || txtUnitPrice.Text == "")
{
XtraMessageBox.Show("You have to choose at least one unit to delete!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Warning);
ClearDisplay();
return;
}
if (Unit_BUS.DeleteUnit(unit))
{
LoadUnitList();
XtraMessageBox.Show("Unit Info has been deleted sucessfully!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearDisplay();
return;
}
}
catch
{
XtraMessageBox.Show("Delete Info Failed!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public static bool DeleteUnit(Unit_DTO unit)
{
SqlConnection con = DataProvider.OpenConnection();
SqlCommand cmd = new SqlCommand("[JEWELRYSTOREMGMT].[dbo].[usp_deleteUnit]", con);
try
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p = new SqlParameter("@UnitID", unit.UnitID);
cmd.Parameters.Add(p);
cmd.ExecuteNonQuery();
DataProvider.CloseConnection(con);
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Notification", MessageBoxButtons.OK, MessageBoxIcon.Error);
DataProvider.CloseConnection(con);
return(false);
}
}
public static bool DeleteUnit(Unit_DTO unit)
{
return(Unit_DAL.DeleteUnit(unit));
}
public static bool UpdateUnit(Unit_DTO unit)
{
return(Unit_DAL.UpdateUnit(unit));
}
public static bool InsertUnit(Unit_DTO unit)
{
return(Unit_DAL.InsertUnit(unit));
}
