public static Pos_ProductType GetPos_ProductTypeByID(int id)
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
SqlPos_ProductTypeProvider sqlPos_ProductTypeProvider = new SqlPos_ProductTypeProvider();
pos_ProductType = sqlPos_ProductTypeProvider.GetPos_ProductTypeByID(id);
return pos_ProductType;
}
private void showPos_ProductTypeData()
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
pos_ProductType = Pos_ProductTypeManager.GetPos_ProductTypeByID(Int32.Parse(Request.QueryString["pos_ProductTypeID"]));
txtProductTypeName.Text = pos_ProductType.ProductTypeName;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
pos_ProductType.ProductTypeName = txtProductTypeName.Text;
int resutl = Pos_ProductTypeManager.InsertPos_ProductType(pos_ProductType);
Response.Redirect("AdminPos_ProductTypeDisplay.aspx");
}
public static Pos_ProductType GetPos_ProductTypeByID(int id)
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
SqlPos_ProductTypeProvider sqlPos_ProductTypeProvider = new SqlPos_ProductTypeProvider();
pos_ProductType = sqlPos_ProductTypeProvider.GetPos_ProductTypeByID(id);
return(pos_ProductType);
}
private void showPos_ProductTypeData()
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
pos_ProductType = Pos_ProductTypeManager.GetPos_ProductTypeByID(Int32.Parse(Request.QueryString["pos_ProductTypeID"]));
txtProductTypeName.Text = pos_ProductType.ProductTypeName;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
pos_ProductType.ProductTypeName = txtProductTypeName.Text;
int resutl = Pos_ProductTypeManager.InsertPos_ProductType(pos_ProductType);
Response.Redirect("AdminPos_ProductTypeDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
pos_ProductType = Pos_ProductTypeManager.GetPos_ProductTypeByID(Int32.Parse(Request.QueryString["pos_ProductTypeID"]));
Pos_ProductType tempPos_ProductType = new Pos_ProductType();
tempPos_ProductType.Pos_ProductTypeID = pos_ProductType.Pos_ProductTypeID;
tempPos_ProductType.ProductTypeName = txtProductTypeName.Text;
bool result = Pos_ProductTypeManager.UpdatePos_ProductType(tempPos_ProductType);
Response.Redirect("AdminPos_ProductTypeDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Pos_ProductType pos_ProductType = new Pos_ProductType();
pos_ProductType = Pos_ProductTypeManager.GetPos_ProductTypeByID(Int32.Parse(Request.QueryString["pos_ProductTypeID"]));
Pos_ProductType tempPos_ProductType = new Pos_ProductType();
tempPos_ProductType.Pos_ProductTypeID = pos_ProductType.Pos_ProductTypeID;
tempPos_ProductType.ProductTypeName = txtProductTypeName.Text;
bool result = Pos_ProductTypeManager.UpdatePos_ProductType(tempPos_ProductType);
Response.Redirect("AdminPos_ProductTypeDisplay.aspx");
}
public int InsertPos_ProductType(Pos_ProductType pos_ProductType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertPos_ProductType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Pos_ProductTypeID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ProductTypeName", SqlDbType.NVarChar).Value = pos_ProductType.ProductTypeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Pos_ProductTypeID"].Value);
}
}
public bool UpdatePos_ProductType(Pos_ProductType pos_ProductType)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductType", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Pos_ProductTypeID", SqlDbType.Int).Value = pos_ProductType.Pos_ProductTypeID;
cmd.Parameters.Add("@ProductTypeName", SqlDbType.NVarChar).Value = pos_ProductType.ProductTypeName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Pos_ProductType GetPos_ProductTypeFromReader(IDataReader reader)
{
try
{
Pos_ProductType pos_ProductType = new Pos_ProductType
(
(int)reader["Pos_ProductTypeID"],
reader["ProductTypeName"].ToString()
);
return(pos_ProductType);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdatePos_ProductType(Pos_ProductType pos_ProductType)
{
SqlPos_ProductTypeProvider sqlPos_ProductTypeProvider = new SqlPos_ProductTypeProvider();
return sqlPos_ProductTypeProvider.UpdatePos_ProductType(pos_ProductType);
}
public static int InsertPos_ProductType(Pos_ProductType pos_ProductType)
{
SqlPos_ProductTypeProvider sqlPos_ProductTypeProvider = new SqlPos_ProductTypeProvider();
return sqlPos_ProductTypeProvider.InsertPos_ProductType(pos_ProductType);
}
public static bool UpdatePos_ProductType(Pos_ProductType pos_ProductType)
{
SqlPos_ProductTypeProvider sqlPos_ProductTypeProvider = new SqlPos_ProductTypeProvider();
return(sqlPos_ProductTypeProvider.UpdatePos_ProductType(pos_ProductType));
}
public static int InsertPos_ProductType(Pos_ProductType pos_ProductType)
{
SqlPos_ProductTypeProvider sqlPos_ProductTypeProvider = new SqlPos_ProductTypeProvider();
return(sqlPos_ProductTypeProvider.InsertPos_ProductType(pos_ProductType));
}
