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 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); } }
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)); }