public static Pos_BranchWiseProductStockCapacity GetPos_BranchWiseProductStockCapacityByID(int id)
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
SqlPos_BranchWiseProductStockCapacityProvider sqlPos_BranchWiseProductStockCapacityProvider = new SqlPos_BranchWiseProductStockCapacityProvider();
pos_BranchWiseProductStockCapacity = sqlPos_BranchWiseProductStockCapacityProvider.GetPos_BranchWiseProductStockCapacityByID(id);
return pos_BranchWiseProductStockCapacity;
}
public static Pos_BranchWiseProductStockCapacity GetPos_BranchWiseProductStockCapacityByID(int id)
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
SqlPos_BranchWiseProductStockCapacityProvider sqlPos_BranchWiseProductStockCapacityProvider = new SqlPos_BranchWiseProductStockCapacityProvider();
pos_BranchWiseProductStockCapacity = sqlPos_BranchWiseProductStockCapacityProvider.GetPos_BranchWiseProductStockCapacityByID(id);
return(pos_BranchWiseProductStockCapacity);
}
private void showPos_BranchWiseProductStockCapacityData()
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
pos_BranchWiseProductStockCapacity = Pos_BranchWiseProductStockCapacityManager.GetPos_BranchWiseProductStockCapacityByID(Int32.Parse(Request.QueryString["pos_BranchWiseProductStockCapacityID"]));
ddlProduct.SelectedValue = pos_BranchWiseProductStockCapacity.ProductID.ToString();
ddlWorkStation.SelectedValue = pos_BranchWiseProductStockCapacity.WorkStationID.ToString();
txtStockAmount.Text = pos_BranchWiseProductStockCapacity.StockAmount.ToString();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
pos_BranchWiseProductStockCapacity.ProductID = Int32.Parse(ddlProduct.SelectedValue);
pos_BranchWiseProductStockCapacity.WorkStationID = Int32.Parse(ddlWorkStation.SelectedValue);
pos_BranchWiseProductStockCapacity.StockAmount = Int64.Parse(txtStockAmount.Text);
int resutl = Pos_BranchWiseProductStockCapacityManager.InsertPos_BranchWiseProductStockCapacity(pos_BranchWiseProductStockCapacity);
Response.Redirect("AdminPos_BranchWiseProductStockCapacityDisplay.aspx");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
pos_BranchWiseProductStockCapacity.ProductID = Int32.Parse(ddlProduct.SelectedValue);
pos_BranchWiseProductStockCapacity.WorkStationID = Int32.Parse(ddlWorkStation.SelectedValue);
pos_BranchWiseProductStockCapacity.StockAmount = Int64.Parse(txtStockAmount.Text);
int resutl = Pos_BranchWiseProductStockCapacityManager.InsertPos_BranchWiseProductStockCapacity(pos_BranchWiseProductStockCapacity);
Response.Redirect("AdminPos_BranchWiseProductStockCapacityDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
pos_BranchWiseProductStockCapacity = Pos_BranchWiseProductStockCapacityManager.GetPos_BranchWiseProductStockCapacityByID(Int32.Parse(Request.QueryString["pos_BranchWiseProductStockCapacityID"]));
Pos_BranchWiseProductStockCapacity tempPos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
tempPos_BranchWiseProductStockCapacity.Pos_BranchWiseProductStockCapacityID = pos_BranchWiseProductStockCapacity.Pos_BranchWiseProductStockCapacityID;
tempPos_BranchWiseProductStockCapacity.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempPos_BranchWiseProductStockCapacity.WorkStationID = Int32.Parse(ddlWorkStation.SelectedValue);
tempPos_BranchWiseProductStockCapacity.StockAmount = Int64.Parse(txtStockAmount.Text);
bool result = Pos_BranchWiseProductStockCapacityManager.UpdatePos_BranchWiseProductStockCapacity(tempPos_BranchWiseProductStockCapacity);
Response.Redirect("AdminPos_BranchWiseProductStockCapacityDisplay.aspx");
}
public int InsertPos_BranchWiseProductStockCapacity(Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("GP_InsertPos_BranchWiseProductStockCapacity", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Pos_BranchWiseProductStockCapacityID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = pos_BranchWiseProductStockCapacity.ProductID;
cmd.Parameters.Add("@WorkStationID", SqlDbType.Int).Value = pos_BranchWiseProductStockCapacity.WorkStationID;
cmd.Parameters.Add("@StockAmount", SqlDbType.BigInt).Value = pos_BranchWiseProductStockCapacity.StockAmount;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Pos_BranchWiseProductStockCapacityID"].Value);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
pos_BranchWiseProductStockCapacity = Pos_BranchWiseProductStockCapacityManager.GetPos_BranchWiseProductStockCapacityByID(Int32.Parse(Request.QueryString["pos_BranchWiseProductStockCapacityID"]));
Pos_BranchWiseProductStockCapacity tempPos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
tempPos_BranchWiseProductStockCapacity.Pos_BranchWiseProductStockCapacityID = pos_BranchWiseProductStockCapacity.Pos_BranchWiseProductStockCapacityID;
tempPos_BranchWiseProductStockCapacity.ProductID = Int32.Parse(ddlProduct.SelectedValue);
tempPos_BranchWiseProductStockCapacity.WorkStationID = Int32.Parse(ddlWorkStation.SelectedValue);
tempPos_BranchWiseProductStockCapacity.StockAmount = Int64.Parse(txtStockAmount.Text);
bool result = Pos_BranchWiseProductStockCapacityManager.UpdatePos_BranchWiseProductStockCapacity(tempPos_BranchWiseProductStockCapacity);
Response.Redirect("AdminPos_BranchWiseProductStockCapacityDisplay.aspx");
}
public Pos_BranchWiseProductStockCapacity GetPos_BranchWiseProductStockCapacityFromReader(IDataReader reader)
{
try
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity
(
(int)reader["Pos_BranchWiseProductStockCapacityID"],
(int)reader["ProductID"],
(int)reader["WorkStationID"],
(long)reader["StockAmount"]
);
return(pos_BranchWiseProductStockCapacity);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdatePos_BranchWiseProductStockCapacity(Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity)
{
SqlPos_BranchWiseProductStockCapacityProvider sqlPos_BranchWiseProductStockCapacityProvider = new SqlPos_BranchWiseProductStockCapacityProvider();
return sqlPos_BranchWiseProductStockCapacityProvider.UpdatePos_BranchWiseProductStockCapacity(pos_BranchWiseProductStockCapacity);
}
public static int InsertPos_BranchWiseProductStockCapacity(Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity)
{
SqlPos_BranchWiseProductStockCapacityProvider sqlPos_BranchWiseProductStockCapacityProvider = new SqlPos_BranchWiseProductStockCapacityProvider();
return sqlPos_BranchWiseProductStockCapacityProvider.InsertPos_BranchWiseProductStockCapacity(pos_BranchWiseProductStockCapacity);
}
public static bool UpdatePos_BranchWiseProductStockCapacity(Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity)
{
SqlPos_BranchWiseProductStockCapacityProvider sqlPos_BranchWiseProductStockCapacityProvider = new SqlPos_BranchWiseProductStockCapacityProvider();
return(sqlPos_BranchWiseProductStockCapacityProvider.UpdatePos_BranchWiseProductStockCapacity(pos_BranchWiseProductStockCapacity));
}
public static int InsertPos_BranchWiseProductStockCapacity(Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity)
{
SqlPos_BranchWiseProductStockCapacityProvider sqlPos_BranchWiseProductStockCapacityProvider = new SqlPos_BranchWiseProductStockCapacityProvider();
return(sqlPos_BranchWiseProductStockCapacityProvider.InsertPos_BranchWiseProductStockCapacity(pos_BranchWiseProductStockCapacity));
}
private void showPos_BranchWiseProductStockCapacityData()
{
Pos_BranchWiseProductStockCapacity pos_BranchWiseProductStockCapacity = new Pos_BranchWiseProductStockCapacity();
pos_BranchWiseProductStockCapacity = Pos_BranchWiseProductStockCapacityManager.GetPos_BranchWiseProductStockCapacityByID(Int32.Parse(Request.QueryString["pos_BranchWiseProductStockCapacityID"]));
ddlProduct.SelectedValue = pos_BranchWiseProductStockCapacity.ProductID.ToString();
ddlWorkStation.SelectedValue = pos_BranchWiseProductStockCapacity.WorkStationID.ToString();
txtStockAmount.Text = pos_BranchWiseProductStockCapacity.StockAmount.ToString();
}