public static Inv_QuantityUnit GetInv_QuantityUnitByID(int id)
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
SqlInv_QuantityUnitProvider sqlInv_QuantityUnitProvider = new SqlInv_QuantityUnitProvider();
inv_QuantityUnit = sqlInv_QuantityUnitProvider.GetInv_QuantityUnitByID(id);
return inv_QuantityUnit;
}
public static Inv_QuantityUnit GetInv_QuantityUnitByID(int id)
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
SqlInv_QuantityUnitProvider sqlInv_QuantityUnitProvider = new SqlInv_QuantityUnitProvider();
inv_QuantityUnit = sqlInv_QuantityUnitProvider.GetInv_QuantityUnitByID(id);
return(inv_QuantityUnit);
}
private void showInv_QuantityUnitData()
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
inv_QuantityUnit = Inv_QuantityUnitManager.GetInv_QuantityUnitByID(Int32.Parse(Request.QueryString["inv_QuantityUnitID"]));
txtQuantityUnitName.Text = inv_QuantityUnit.QuantityUnitName;
ddlRowStatus.SelectedValue = inv_QuantityUnit.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
inv_QuantityUnit.QuantityUnitName = txtQuantityUnitName.Text;
inv_QuantityUnit.RowStatusID = 1;
int resutl = Inv_QuantityUnitManager.InsertInv_QuantityUnit(inv_QuantityUnit);
Response.Redirect("AdminInv_QuantityUnitDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
inv_QuantityUnit.QuantityUnitName = txtQuantityUnitName.Text;
inv_QuantityUnit.RowStatusID = 1;
int resutl = Inv_QuantityUnitManager.InsertInv_QuantityUnit(inv_QuantityUnit);
Response.Redirect("AdminInv_QuantityUnitDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
inv_QuantityUnit = Inv_QuantityUnitManager.GetInv_QuantityUnitByID(Int32.Parse(Request.QueryString["inv_QuantityUnitID"]));
Inv_QuantityUnit tempInv_QuantityUnit = new Inv_QuantityUnit();
tempInv_QuantityUnit.Inv_QuantityUnitID = inv_QuantityUnit.Inv_QuantityUnitID;
tempInv_QuantityUnit.QuantityUnitName = txtQuantityUnitName.Text;
tempInv_QuantityUnit.RowStatusID = 1;
bool result = Inv_QuantityUnitManager.UpdateInv_QuantityUnit(tempInv_QuantityUnit);
Response.Redirect("AdminInv_QuantityUnitDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
inv_QuantityUnit = Inv_QuantityUnitManager.GetInv_QuantityUnitByID(Int32.Parse(Request.QueryString["inv_QuantityUnitID"]));
Inv_QuantityUnit tempInv_QuantityUnit = new Inv_QuantityUnit();
tempInv_QuantityUnit.Inv_QuantityUnitID = inv_QuantityUnit.Inv_QuantityUnitID;
tempInv_QuantityUnit.QuantityUnitName = txtQuantityUnitName.Text;
tempInv_QuantityUnit.RowStatusID = 1;
bool result = Inv_QuantityUnitManager.UpdateInv_QuantityUnit(tempInv_QuantityUnit);
Response.Redirect("AdminInv_QuantityUnitDisplay.aspx");
}
public int InsertInv_QuantityUnit(Inv_QuantityUnit inv_QuantityUnit)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertInv_QuantityUnit", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_QuantityUnitID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@QuantityUnitName", SqlDbType.NVarChar).Value = inv_QuantityUnit.QuantityUnitName;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_QuantityUnit.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Inv_QuantityUnitID"].Value);
}
}
public Inv_QuantityUnit GetInv_QuantityUnitFromReader(IDataReader reader)
{
try
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit
(
(int)reader["Inv_QuantityUnitID"],
reader["QuantityUnitName"].ToString(),
(int)reader["RowStatusID"]
);
return inv_QuantityUnit;
}
catch(Exception ex)
{
return null;
}
}
public Inv_QuantityUnit GetInv_QuantityUnitFromReader(IDataReader reader)
{
try
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit
(
(int)reader["Inv_QuantityUnitID"],
reader["QuantityUnitName"].ToString(),
(int)reader["RowStatusID"]
);
return(inv_QuantityUnit);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateInv_QuantityUnit(Inv_QuantityUnit inv_QuantityUnit)
{
SqlInv_QuantityUnitProvider sqlInv_QuantityUnitProvider = new SqlInv_QuantityUnitProvider();
return(sqlInv_QuantityUnitProvider.UpdateInv_QuantityUnit(inv_QuantityUnit));
}
public static int InsertInv_QuantityUnit(Inv_QuantityUnit inv_QuantityUnit)
{
SqlInv_QuantityUnitProvider sqlInv_QuantityUnitProvider = new SqlInv_QuantityUnitProvider();
return(sqlInv_QuantityUnitProvider.InsertInv_QuantityUnit(inv_QuantityUnit));
}
public static bool UpdateInv_QuantityUnit(Inv_QuantityUnit inv_QuantityUnit)
{
SqlInv_QuantityUnitProvider sqlInv_QuantityUnitProvider = new SqlInv_QuantityUnitProvider();
return sqlInv_QuantityUnitProvider.UpdateInv_QuantityUnit(inv_QuantityUnit);
}
public static int InsertInv_QuantityUnit(Inv_QuantityUnit inv_QuantityUnit)
{
SqlInv_QuantityUnitProvider sqlInv_QuantityUnitProvider = new SqlInv_QuantityUnitProvider();
return sqlInv_QuantityUnitProvider.InsertInv_QuantityUnit(inv_QuantityUnit);
}
public bool UpdateInv_QuantityUnit(Inv_QuantityUnit inv_QuantityUnit)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_QuantityUnit", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_QuantityUnitID", SqlDbType.Int).Value = inv_QuantityUnit.Inv_QuantityUnitID;
cmd.Parameters.Add("@QuantityUnitName", SqlDbType.NVarChar).Value = inv_QuantityUnit.QuantityUnitName;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_QuantityUnit.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
private void showInv_QuantityUnitData()
{
Inv_QuantityUnit inv_QuantityUnit = new Inv_QuantityUnit();
inv_QuantityUnit = Inv_QuantityUnitManager.GetInv_QuantityUnitByID(Int32.Parse(Request.QueryString["inv_QuantityUnitID"]));
txtQuantityUnitName.Text = inv_QuantityUnit.QuantityUnitName;
ddlRowStatus.SelectedValue = inv_QuantityUnit.RowStatusID.ToString();
}
