private void showPos_ProductStatusData()
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus();
pos_ProductStatus = Pos_ProductStatusManager.GetPos_ProductStatusByID(Int32.Parse(Request.QueryString["pos_ProductStatusID"]));
txtProductStatusName.Text = pos_ProductStatus.ProductStatusName;
}
public static Pos_ProductStatus GetPos_ProductStatusByID(int id)
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus();
SqlPos_ProductStatusProvider sqlPos_ProductStatusProvider = new SqlPos_ProductStatusProvider();
pos_ProductStatus = sqlPos_ProductStatusProvider.GetPos_ProductStatusByID(id);
return(pos_ProductStatus);
}
private void showPos_ProductStatusData()
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus();
pos_ProductStatus = Pos_ProductStatusManager.GetPos_ProductStatusByID(Int32.Parse(Request.QueryString["pos_ProductStatusID"]));
txtProductStatusName.Text = pos_ProductStatus.ProductStatusName;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus();
pos_ProductStatus.ProductStatusName = txtProductStatusName.Text;
int resutl = Pos_ProductStatusManager.InsertPos_ProductStatus(pos_ProductStatus);
Response.Redirect("AdminPos_ProductStatusDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus();
pos_ProductStatus.ProductStatusName = txtProductStatusName.Text;
int resutl = Pos_ProductStatusManager.InsertPos_ProductStatus(pos_ProductStatus);
Response.Redirect("AdminPos_ProductStatusDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus();
pos_ProductStatus = Pos_ProductStatusManager.GetPos_ProductStatusByID(Int32.Parse(Request.QueryString["pos_ProductStatusID"]));
Pos_ProductStatus tempPos_ProductStatus = new Pos_ProductStatus();
tempPos_ProductStatus.Pos_ProductStatusID = pos_ProductStatus.Pos_ProductStatusID;
tempPos_ProductStatus.ProductStatusName = txtProductStatusName.Text;
bool result = Pos_ProductStatusManager.UpdatePos_ProductStatus(tempPos_ProductStatus);
Response.Redirect("AdminPos_ProductStatusDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus();
pos_ProductStatus = Pos_ProductStatusManager.GetPos_ProductStatusByID(Int32.Parse(Request.QueryString["pos_ProductStatusID"]));
Pos_ProductStatus tempPos_ProductStatus = new Pos_ProductStatus();
tempPos_ProductStatus.Pos_ProductStatusID = pos_ProductStatus.Pos_ProductStatusID;
tempPos_ProductStatus.ProductStatusName = txtProductStatusName.Text;
bool result = Pos_ProductStatusManager.UpdatePos_ProductStatus(tempPos_ProductStatus);
Response.Redirect("AdminPos_ProductStatusDisplay.aspx");
}
public int InsertPos_ProductStatus(Pos_ProductStatus pos_ProductStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertPos_ProductStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Pos_ProductStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ProductStatusName", SqlDbType.NVarChar).Value = pos_ProductStatus.ProductStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Pos_ProductStatusID"].Value);
}
}
public bool UpdatePos_ProductStatus(Pos_ProductStatus pos_ProductStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Pos_ProductStatusID", SqlDbType.Int).Value = pos_ProductStatus.Pos_ProductStatusID;
cmd.Parameters.Add("@ProductStatusName", SqlDbType.NVarChar).Value = pos_ProductStatus.ProductStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Pos_ProductStatus GetPos_ProductStatusFromReader(IDataReader reader)
{
try
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus
(
(int)reader["Pos_ProductStatusID"],
reader["ProductStatusName"].ToString()
);
return(pos_ProductStatus);
}
catch (Exception ex)
{
return(null);
}
}
public Pos_ProductStatus GetPos_ProductStatusFromReader(IDataReader reader)
{
try
{
Pos_ProductStatus pos_ProductStatus = new Pos_ProductStatus
(
(int)reader["Pos_ProductStatusID"],
reader["ProductStatusName"].ToString()
);
return pos_ProductStatus;
}
catch(Exception ex)
{
return null;
}
}
public static bool UpdatePos_ProductStatus(Pos_ProductStatus pos_ProductStatus)
{
SqlPos_ProductStatusProvider sqlPos_ProductStatusProvider = new SqlPos_ProductStatusProvider();
return(sqlPos_ProductStatusProvider.UpdatePos_ProductStatus(pos_ProductStatus));
}
public static int InsertPos_ProductStatus(Pos_ProductStatus pos_ProductStatus)
{
SqlPos_ProductStatusProvider sqlPos_ProductStatusProvider = new SqlPos_ProductStatusProvider();
return(sqlPos_ProductStatusProvider.InsertPos_ProductStatus(pos_ProductStatus));
}
public bool UpdatePos_ProductStatus(Pos_ProductStatus pos_ProductStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Pos_ProductStatusID", SqlDbType.Int).Value = pos_ProductStatus.Pos_ProductStatusID;
cmd.Parameters.Add("@ProductStatusName", SqlDbType.NVarChar).Value = pos_ProductStatus.ProductStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertPos_ProductStatus(Pos_ProductStatus pos_ProductStatus)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertPos_ProductStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Pos_ProductStatusID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ProductStatusName", SqlDbType.NVarChar).Value = pos_ProductStatus.ProductStatusName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@Pos_ProductStatusID"].Value;
}
}
