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