private void showMarketingVanueData() { MarketingVanue marketingVanue = new MarketingVanue(); marketingVanue = MarketingVanueManager.GetMarketingVanueByMarketingVanueID(Int32.Parse(Request.QueryString["ID"])); txtMarketingVanueName.Text = marketingVanue.MarketingVanueName.ToString(); }
public static MarketingVanue GetMarketingVanueByMarketingVanueID(int MarketingVanueID) { MarketingVanue marketingVanue = new MarketingVanue(); SqlMarketingVanueProvider sqlMarketingVanueProvider = new SqlMarketingVanueProvider(); marketingVanue = sqlMarketingVanueProvider.GetMarketingVanueByMarketingVanueID(MarketingVanueID); return marketingVanue; }
public static MarketingVanue GetMarketingVanueByMarketingVanueID(int MarketingVanueID) { MarketingVanue marketingVanue = new MarketingVanue(); SqlMarketingVanueProvider sqlMarketingVanueProvider = new SqlMarketingVanueProvider(); marketingVanue = sqlMarketingVanueProvider.GetMarketingVanueByMarketingVanueID(MarketingVanueID); return(marketingVanue); }
protected void btnUpdate_Click(object sender, EventArgs e) { MarketingVanue marketingVanue = new MarketingVanue(); marketingVanue.MarketingVanueID = int.Parse(Request.QueryString["ID"].ToString()); marketingVanue.MarketingVanueName = txtMarketingVanueName.Text; bool resutl = MarketingVanueManager.UpdateMarketingVanue(marketingVanue); Response.Redirect("AdminDisplayMarketingVanue.aspx"); }
protected void btnAdd_Click(object sender, EventArgs e) { MarketingVanue marketingVanue = new MarketingVanue(); // marketingVanue.MarketingVanueID= int.Parse(ddlMarketingVanueID.SelectedValue); marketingVanue.MarketingVanueName = txtMarketingVanueName.Text; int resutl = MarketingVanueManager.InsertMarketingVanue(marketingVanue); Response.Redirect("AdminDisplayMarketingVanue.aspx"); }
public bool UpdateMarketingVanue(MarketingVanue marketingVanue) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateMarketingVanue", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MarketingVanueID", SqlDbType.Int).Value = marketingVanue.MarketingVanueID; cmd.Parameters.Add("@MarketingVanueName", SqlDbType.NVarChar).Value = marketingVanue.MarketingVanueName; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public int InsertMarketingVanue(MarketingVanue marketingVanue) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertMarketingVanue", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MarketingVanueID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@MarketingVanueName", SqlDbType.NVarChar).Value = marketingVanue.MarketingVanueName; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@MarketingVanueID"].Value); } }
public MarketingVanue GetMarketingVanueFromReader(IDataReader reader) { try { MarketingVanue marketingVanue = new MarketingVanue ( DataAccessObject.IsNULL <int>(reader["MarketingVanueID"]), DataAccessObject.IsNULL <string>(reader["MarketingVanueName"]) ); return(marketingVanue); } catch (Exception ex) { return(null); } }
public static bool UpdateMarketingVanue(MarketingVanue marketingVanue) { SqlMarketingVanueProvider sqlMarketingVanueProvider = new SqlMarketingVanueProvider(); return(sqlMarketingVanueProvider.UpdateMarketingVanue(marketingVanue)); }
public static int InsertMarketingVanue(MarketingVanue marketingVanue) { SqlMarketingVanueProvider sqlMarketingVanueProvider = new SqlMarketingVanueProvider(); return(sqlMarketingVanueProvider.InsertMarketingVanue(marketingVanue)); }
public static bool UpdateMarketingVanue(MarketingVanue marketingVanue) { SqlMarketingVanueProvider sqlMarketingVanueProvider = new SqlMarketingVanueProvider(); return sqlMarketingVanueProvider.UpdateMarketingVanue(marketingVanue); }
public static int InsertMarketingVanue(MarketingVanue marketingVanue) { SqlMarketingVanueProvider sqlMarketingVanueProvider = new SqlMarketingVanueProvider(); return sqlMarketingVanueProvider.InsertMarketingVanue(marketingVanue); }
public MarketingVanue GetMarketingVanueFromReader(IDataReader reader) { try { MarketingVanue marketingVanue = new MarketingVanue ( DataAccessObject.IsNULL<int>(reader["MarketingVanueID"]), DataAccessObject.IsNULL<string>(reader["MarketingVanueName"]) ); return marketingVanue; } catch(Exception ex) { return null; } }
public bool UpdateMarketingVanue(MarketingVanue marketingVanue) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateMarketingVanue", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MarketingVanueID", SqlDbType.Int).Value = marketingVanue.MarketingVanueID; cmd.Parameters.Add("@MarketingVanueName", SqlDbType.NVarChar).Value = marketingVanue.MarketingVanueName; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public int InsertMarketingVanue(MarketingVanue marketingVanue) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("InsertMarketingVanue", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MarketingVanueID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@MarketingVanueName", SqlDbType.NVarChar).Value = marketingVanue.MarketingVanueName; connection.Open(); int result = cmd.ExecuteNonQuery(); return (int)cmd.Parameters["@MarketingVanueID"].Value; } }