public static Pos_Size GetPos_SizeByID(int id) { Pos_Size pos_Size = new Pos_Size(); SqlPos_SizeProvider sqlPos_SizeProvider = new SqlPos_SizeProvider(); pos_Size = sqlPos_SizeProvider.GetPos_SizeByID(id); return pos_Size; }
public static Pos_Size GetPos_SizeByID(int id) { Pos_Size pos_Size = new Pos_Size(); SqlPos_SizeProvider sqlPos_SizeProvider = new SqlPos_SizeProvider(); pos_Size = sqlPos_SizeProvider.GetPos_SizeByID(id); return(pos_Size); }
private void showPos_SizeData() { Pos_Size pos_Size = new Pos_Size(); pos_Size = Pos_SizeManager.GetPos_SizeByID(Int32.Parse(Request.QueryString["pos_SizeID"])); txtSizeName.Text = pos_Size.SizeName; txtCode.Text = pos_Size.Code; }
protected void btnAdd_Click(object sender, EventArgs e) { Pos_Size pos_Size = new Pos_Size(); pos_Size.SizeName = txtSizeName.Text; pos_Size.Code = txtCode.Text; int resutl = Pos_SizeManager.InsertPos_Size(pos_Size); Response.Redirect("AdminPos_SizeDisplay.aspx"); }
protected void btnUpdate_Click(object sender, EventArgs e) { Pos_Size pos_Size = new Pos_Size(); pos_Size = Pos_SizeManager.GetPos_SizeByID(Int32.Parse(Request.QueryString["pos_SizeID"])); Pos_Size tempPos_Size = new Pos_Size(); tempPos_Size.Pos_SizeID = pos_Size.Pos_SizeID; tempPos_Size.SizeName = txtSizeName.Text; tempPos_Size.Code = txtCode.Text; bool result = Pos_SizeManager.UpdatePos_Size(tempPos_Size); Response.Redirect("AdminPos_SizeDisplay.aspx"); }
public int InsertPos_Size(Pos_Size pos_Size) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_InsertPos_Size", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Pos_SizeID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@SizeName", SqlDbType.NVarChar).Value = pos_Size.SizeName; cmd.Parameters.Add("@Code", SqlDbType.NChar).Value = pos_Size.Code; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@Pos_SizeID"].Value); } }
public bool UpdatePos_Size(Pos_Size pos_Size) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_UpdatePos_Size", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Pos_SizeID", SqlDbType.Int).Value = pos_Size.Pos_SizeID; cmd.Parameters.Add("@SizeName", SqlDbType.NVarChar).Value = pos_Size.SizeName; cmd.Parameters.Add("@Code", SqlDbType.NChar).Value = pos_Size.Code; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public Pos_Size GetPos_SizeFromReader(IDataReader reader) { try { Pos_Size pos_Size = new Pos_Size ( (int)reader["Pos_SizeID"], reader["SizeName"].ToString(), reader["Code"].ToString() ); return(pos_Size); } catch (Exception ex) { return(null); } }
public static bool UpdatePos_Size(Pos_Size pos_Size) { SqlPos_SizeProvider sqlPos_SizeProvider = new SqlPos_SizeProvider(); return(sqlPos_SizeProvider.UpdatePos_Size(pos_Size)); }
public static int InsertPos_Size(Pos_Size pos_Size) { SqlPos_SizeProvider sqlPos_SizeProvider = new SqlPos_SizeProvider(); return(sqlPos_SizeProvider.InsertPos_Size(pos_Size)); }
public static bool UpdatePos_Size(Pos_Size pos_Size) { SqlPos_SizeProvider sqlPos_SizeProvider = new SqlPos_SizeProvider(); return sqlPos_SizeProvider.UpdatePos_Size(pos_Size); }
public static int InsertPos_Size(Pos_Size pos_Size) { SqlPos_SizeProvider sqlPos_SizeProvider = new SqlPos_SizeProvider(); return sqlPos_SizeProvider.InsertPos_Size(pos_Size); }