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