private void LoadVenuePresenterData(int type ,VenuePresenter vp)
{
if (type == 1)
{
txtpresentername.Text = vp.VenuePresenterName;
}
else
{
txtvenuname.Text = vp.VenuePresenterName;
txtCapacity1.Text = vp.capacity;
}
txtCountry.Text= vp.Country;
txtbxFirstname.Text= vp.FirstName;
txtbxLastName.Text = vp.LastName;
}
public void SearchAllHistoryUpdate(int type, int mode, string userid, VenuePresenter vp)
{
SqlCommand cmd = new SqlCommand("spInsertHistoryAll", dbconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Type", type);
cmd.Parameters.AddWithValue("@Mode", mode);
cmd.Parameters.AddWithValue("@Presenter", vp.VenuePresenterName);
cmd.Parameters.AddWithValue("@City", vp.City);
cmd.Parameters.AddWithValue("@ZipCode", vp.ZipCode);
cmd.Parameters.AddWithValue("@Country", vp.Country);
cmd.Parameters.AddWithValue("@FirstName", vp.FirstName);
cmd.Parameters.AddWithValue("@LastName", vp.LastName);
cmd.Parameters.AddWithValue("@Capacity", vp.capacity);
cmd.Parameters.AddWithValue("@UserID", userid);
try
{
if (dbconn.State == ConnectionState.Closed)
{
dbconn.Open();
}
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbconn.State == ConnectionState.Open)
{
dbconn.Close();
}
}
}
private void InsertHistoryPresenterVenue(int type)
{
string city = "", zipcode = "";
VenuePresenter vp = new VenuePresenter();
int t = type ;
if (type == 2)
{
vp.capacity = txtCapacity1.Text.Trim().ToString();
vp.VenuePresenterName = txtvenuname.Text.Trim().ToString();
}
else{vp.VenuePresenterName= txtpresentername.Text.Trim().ToString();}
vp.Country= txtCountry.Text.Trim().ToString();
vp.FirstName= txtbxFirstname.Text.Trim().ToString();
vp.LastName=txtbxLastName.Text.Trim().ToString();
vp.ZipCode = zipcode;
objmsd.SearchAllHistoryUpdate(t,0,userid,vp);
}
public VenuePresenter GetSearchAllHistory(int mode, string userid)
{
DataTable dt = new DataTable();
VenuePresenter vp = null;
SqlCommand cmd = new SqlCommand("spGetHistoryAll", dbconn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Mode", mode);
cmd.Parameters.AddWithValue("@UserID", userid);
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (dbconn.State == ConnectionState.Closed) { dbconn.Open(); }
SqlDataReader dr = cmd.ExecuteReader();
dt.Load(dr);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
vp = new VenuePresenter();
vp.VenuePresenterName = Convert.ToString(dt.Rows[0][0]);
vp.Country = Convert.ToString(dt.Rows[0][3]);
vp.FirstName = Convert.ToString(dt.Rows[0][5]);
vp.LastName = Convert.ToString(dt.Rows[0][4]);
vp.City = Convert.ToString(dt.Rows[0][1]);
vp.ZipCode = Convert.ToString(dt.Rows[0][2]);
vp.capacity = Convert.ToString(dt.Rows[0][6]);
return vp;
}
}
return vp;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dbconn.State == ConnectionState.Open) { dbconn.Close(); }
}
}
