public static Inv_QualityUnitName GetInv_QualityUnitNameByID(int id)
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
SqlInv_QualityUnitNameProvider sqlInv_QualityUnitNameProvider = new SqlInv_QualityUnitNameProvider();
inv_QualityUnitName = sqlInv_QualityUnitNameProvider.GetInv_QualityUnitNameByID(id);
return inv_QualityUnitName;
}
public static Inv_QualityUnitName GetInv_QualityUnitNameByID(int id)
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
SqlInv_QualityUnitNameProvider sqlInv_QualityUnitNameProvider = new SqlInv_QualityUnitNameProvider();
inv_QualityUnitName = sqlInv_QualityUnitNameProvider.GetInv_QualityUnitNameByID(id);
return(inv_QualityUnitName);
}
private void showInv_QualityUnitNameData()
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
inv_QualityUnitName = Inv_QualityUnitNameManager.GetInv_QualityUnitNameByID(Int32.Parse(Request.QueryString["inv_QualityUnitNameID"]));
txtQualityUnitName.Text = inv_QualityUnitName.QualityUnitName;
ddlRowStatus.SelectedValue = inv_QualityUnitName.RowStatusID.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
inv_QualityUnitName.QualityUnitName = txtQualityUnitName.Text;
inv_QualityUnitName.RowStatusID = 1;
int resutl = Inv_QualityUnitNameManager.InsertInv_QualityUnitName(inv_QualityUnitName);
Response.Redirect("AdminInv_QualityUnitNameDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
inv_QualityUnitName.QualityUnitName = txtQualityUnitName.Text;
inv_QualityUnitName.RowStatusID = 1;
int resutl = Inv_QualityUnitNameManager.InsertInv_QualityUnitName(inv_QualityUnitName);
Response.Redirect("AdminInv_QualityUnitNameDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
inv_QualityUnitName = Inv_QualityUnitNameManager.GetInv_QualityUnitNameByID(Int32.Parse(Request.QueryString["inv_QualityUnitNameID"]));
Inv_QualityUnitName tempInv_QualityUnitName = new Inv_QualityUnitName();
tempInv_QualityUnitName.Inv_QualityUnitNameID = inv_QualityUnitName.Inv_QualityUnitNameID;
tempInv_QualityUnitName.QualityUnitName = txtQualityUnitName.Text;
tempInv_QualityUnitName.RowStatusID = 1;
bool result = Inv_QualityUnitNameManager.UpdateInv_QualityUnitName(tempInv_QualityUnitName);
Response.Redirect("AdminInv_QualityUnitNameDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
inv_QualityUnitName = Inv_QualityUnitNameManager.GetInv_QualityUnitNameByID(Int32.Parse(Request.QueryString["inv_QualityUnitNameID"]));
Inv_QualityUnitName tempInv_QualityUnitName = new Inv_QualityUnitName();
tempInv_QualityUnitName.Inv_QualityUnitNameID = inv_QualityUnitName.Inv_QualityUnitNameID;
tempInv_QualityUnitName.QualityUnitName = txtQualityUnitName.Text;
tempInv_QualityUnitName.RowStatusID = 1;
bool result = Inv_QualityUnitNameManager.UpdateInv_QualityUnitName(tempInv_QualityUnitName);
Response.Redirect("AdminInv_QualityUnitNameDisplay.aspx");
}
public int InsertInv_QualityUnitName(Inv_QualityUnitName inv_QualityUnitName)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertInv_QualityUnitName", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_QualityUnitNameID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@QualityUnitName", SqlDbType.NVarChar).Value = inv_QualityUnitName.QualityUnitName;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_QualityUnitName.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Inv_QualityUnitNameID"].Value);
}
}
public Inv_QualityUnitName GetInv_QualityUnitNameFromReader(IDataReader reader)
{
try
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName
(
(int)reader["Inv_QualityUnitNameID"],
reader["QualityUnitName"].ToString(),
(int)reader["RowStatusID"]
);
return inv_QualityUnitName;
}
catch(Exception ex)
{
return null;
}
}
public Inv_QualityUnitName GetInv_QualityUnitNameFromReader(IDataReader reader)
{
try
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName
(
(int)reader["Inv_QualityUnitNameID"],
reader["QualityUnitName"].ToString(),
(int)reader["RowStatusID"]
);
return(inv_QualityUnitName);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateInv_QualityUnitName(Inv_QualityUnitName inv_QualityUnitName)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdateInv_QualityUnitName", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Inv_QualityUnitNameID", SqlDbType.Int).Value = inv_QualityUnitName.Inv_QualityUnitNameID;
cmd.Parameters.Add("@QualityUnitName", SqlDbType.NVarChar).Value = inv_QualityUnitName.QualityUnitName;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = inv_QualityUnitName.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public static bool UpdateInv_QualityUnitName(Inv_QualityUnitName inv_QualityUnitName)
{
SqlInv_QualityUnitNameProvider sqlInv_QualityUnitNameProvider = new SqlInv_QualityUnitNameProvider();
return(sqlInv_QualityUnitNameProvider.UpdateInv_QualityUnitName(inv_QualityUnitName));
}
public static int InsertInv_QualityUnitName(Inv_QualityUnitName inv_QualityUnitName)
{
SqlInv_QualityUnitNameProvider sqlInv_QualityUnitNameProvider = new SqlInv_QualityUnitNameProvider();
return(sqlInv_QualityUnitNameProvider.InsertInv_QualityUnitName(inv_QualityUnitName));
}
public static bool UpdateInv_QualityUnitName(Inv_QualityUnitName inv_QualityUnitName)
{
SqlInv_QualityUnitNameProvider sqlInv_QualityUnitNameProvider = new SqlInv_QualityUnitNameProvider();
return sqlInv_QualityUnitNameProvider.UpdateInv_QualityUnitName(inv_QualityUnitName);
}
public static int InsertInv_QualityUnitName(Inv_QualityUnitName inv_QualityUnitName)
{
SqlInv_QualityUnitNameProvider sqlInv_QualityUnitNameProvider = new SqlInv_QualityUnitNameProvider();
return sqlInv_QualityUnitNameProvider.InsertInv_QualityUnitName(inv_QualityUnitName);
}
private void showInv_QualityUnitNameData()
{
Inv_QualityUnitName inv_QualityUnitName = new Inv_QualityUnitName();
inv_QualityUnitName = Inv_QualityUnitNameManager.GetInv_QualityUnitNameByID(Int32.Parse(Request.QueryString["inv_QualityUnitNameID"]));
txtQualityUnitName.Text = inv_QualityUnitName.QualityUnitName;
ddlRowStatus.SelectedValue = inv_QualityUnitName.RowStatusID.ToString();
}
