public static Inv_QualityUnit GetInv_QualityUnitByID(int id)
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
SqlInv_QualityUnitProvider sqlInv_QualityUnitProvider = new SqlInv_QualityUnitProvider();
inv_QualityUnit = sqlInv_QualityUnitProvider.GetInv_QualityUnitByID(id);
return inv_QualityUnit;
}
public static Inv_QualityUnit GetInv_QualityUnitByID(int id)
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
SqlInv_QualityUnitProvider sqlInv_QualityUnitProvider = new SqlInv_QualityUnitProvider();
inv_QualityUnit = sqlInv_QualityUnitProvider.GetInv_QualityUnitByID(id);
return(inv_QualityUnit);
}
private void showInv_QualityUnitData()
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
inv_QualityUnit = Inv_QualityUnitManager.GetInv_QualityUnitByID(Int32.Parse(Request.QueryString["inv_QualityUnitID"]));
txtQualityUnitName.Text = inv_QualityUnit.QualityUnitName;
ddlRowStatus.SelectedValue = inv_QualityUnit.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
inv_QualityUnit.QualityUnitName = txtQualityUnitName.Text;
inv_QualityUnit.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = Inv_QualityUnitManager.InsertInv_QualityUnit(inv_QualityUnit);
Response.Redirect("AdminInv_QualityUnitDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
inv_QualityUnit.QualityUnitName = txtQualityUnitName.Text;
inv_QualityUnit.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
int resutl = Inv_QualityUnitManager.InsertInv_QualityUnit(inv_QualityUnit);
Response.Redirect("AdminInv_QualityUnitDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
inv_QualityUnit = Inv_QualityUnitManager.GetInv_QualityUnitByID(Int32.Parse(Request.QueryString["inv_QualityUnitID"]));
Inv_QualityUnit tempInv_QualityUnit = new Inv_QualityUnit();
tempInv_QualityUnit.Inv_QualityUnitID = inv_QualityUnit.Inv_QualityUnitID;
tempInv_QualityUnit.QualityUnitName = txtQualityUnitName.Text;
tempInv_QualityUnit.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = Inv_QualityUnitManager.UpdateInv_QualityUnit(tempInv_QualityUnit);
Response.Redirect("AdminInv_QualityUnitDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
inv_QualityUnit = Inv_QualityUnitManager.GetInv_QualityUnitByID(Int32.Parse(Request.QueryString["inv_QualityUnitID"]));
Inv_QualityUnit tempInv_QualityUnit = new Inv_QualityUnit();
tempInv_QualityUnit.Inv_QualityUnitID = inv_QualityUnit.Inv_QualityUnitID;
tempInv_QualityUnit.QualityUnitName = txtQualityUnitName.Text;
tempInv_QualityUnit.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = Inv_QualityUnitManager.UpdateInv_QualityUnit(tempInv_QualityUnit);
Response.Redirect("AdminInv_QualityUnitDisplay.aspx");
}
public int InsertInv_QualityUnit(Inv_QualityUnit inv_QualityUnit)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertInv_QualityUnit", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_QualityUnitID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@QualityUnitName", SqlDbType.NVarChar).Value = inv_QualityUnit.QualityUnitName;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_QualityUnit.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Inv_QualityUnitID"].Value);
}
}
public Inv_QualityUnit GetInv_QualityUnitFromReader(IDataReader reader)
{
try
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit
(
(int)reader["Inv_QualityUnitID"],
reader["QualityUnitName"].ToString(),
(int)reader["RowStatusID"]
);
return(inv_QualityUnit);
}
catch (Exception ex)
{
return(null);
}
}
public Inv_QualityUnit GetInv_QualityUnitFromReader(IDataReader reader)
{
try
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit
(
(int)reader["Inv_QualityUnitID"],
reader["QualityUnitName"].ToString(),
(int)reader["RowStatusID"]
);
return inv_QualityUnit;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdateInv_QualityUnit(Inv_QualityUnit inv_QualityUnit)
{
SqlInv_QualityUnitProvider sqlInv_QualityUnitProvider = new SqlInv_QualityUnitProvider();
return sqlInv_QualityUnitProvider.UpdateInv_QualityUnit(inv_QualityUnit);
}
public bool UpdateInv_QualityUnit(Inv_QualityUnit inv_QualityUnit)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_QualityUnit", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_QualityUnitID", SqlDbType.Int).Value = inv_QualityUnit.Inv_QualityUnitID;
cmd.Parameters.Add("@QualityUnitName", SqlDbType.NVarChar).Value = inv_QualityUnit.QualityUnitName;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_QualityUnit.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertInv_QualityUnit(Inv_QualityUnit inv_QualityUnit)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertInv_QualityUnit", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_QualityUnitID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@QualityUnitName", SqlDbType.NVarChar).Value = inv_QualityUnit.QualityUnitName;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_QualityUnit.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@Inv_QualityUnitID"].Value;
}
}
private void showInv_QualityUnitData()
{
Inv_QualityUnit inv_QualityUnit = new Inv_QualityUnit();
inv_QualityUnit = Inv_QualityUnitManager.GetInv_QualityUnitByID(Int32.Parse(Request.QueryString["inv_QualityUnitID"]));
txtQualityUnitName.Text = inv_QualityUnit.QualityUnitName;
ddlRowStatus.SelectedValue = inv_QualityUnit.RowStatusID.ToString();
}
public static bool UpdateInv_QualityUnit(Inv_QualityUnit inv_QualityUnit)
{
SqlInv_QualityUnitProvider sqlInv_QualityUnitProvider = new SqlInv_QualityUnitProvider();
return(sqlInv_QualityUnitProvider.UpdateInv_QualityUnit(inv_QualityUnit));
}
public static int InsertInv_QualityUnit(Inv_QualityUnit inv_QualityUnit)
{
SqlInv_QualityUnitProvider sqlInv_QualityUnitProvider = new SqlInv_QualityUnitProvider();
return sqlInv_QualityUnitProvider.InsertInv_QualityUnit(inv_QualityUnit);
}
public static int InsertInv_QualityUnit(Inv_QualityUnit inv_QualityUnit)
{
SqlInv_QualityUnitProvider sqlInv_QualityUnitProvider = new SqlInv_QualityUnitProvider();
return(sqlInv_QualityUnitProvider.InsertInv_QualityUnit(inv_QualityUnit));
}
