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