protected void btnUpdate_ServerClick(object sender, EventArgs e) { try { if (ValidatePage() == true) { VenueDetailsViewModel _venueDetailsViewModel = new VenueDetailsViewModel(); VenueDetailsModel _venueDetailsModel = new VenueDetailsModel(); _venueDetailsModel.VenueName = txtVenueName.Value; _venueDetailsModel.StreetAddress = txtStreetAddress.Value; _venueDetailsModel.City = txtCity.Value; _venueDetailsModel.StateProvision = txtStateProvision.Value; _venueDetailsModel.ZipCode = txtZipCode.Value; _venueDetailsModel.VenueID = Convert.ToInt32(hdVenueID.Value); string FileName = SaveImage(); _venueDetailsModel.VenueImage = FileName; bool retval = _venueDetailsViewModel.UpdateVenueDetails(_venueDetailsModel); if (retval == true) { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Venue Details", "<script type='text/javascript'>ConfirmMsg('Venue details updated sucessfully.','Add Event Details');</script>", false); // Response.Redirect("/VenueDetails.aspx"); //-kk redirect Response.Redirect("/VenueDetails.aspx", false); Context.ApplicationInstance.CompleteRequest(); } else { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Venue Details", "<script type='text/javascript'>ConfirmMsg('Unexpected error occured.Plese refresh the page and try again!','Add Event Details');</script>", false); } } } catch (Exception ex) { ErrHandler.WriteError(ex.Message); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", "javascript:alert('Server is busy.Please try after sometime.');", true); } }
protected void GetVenueDetails() { try { VenueDetailsViewModel _venueDetailsViewModel = new VenueDetailsViewModel(); List<VenueDetailsModel> _venueDetailsModel = new List<VenueDetailsModel>(); VenueDetailsModel _venueDetails = new VenueDetailsModel(); if (Convert.ToInt32(Session["SVenue"].ToString()) == 0) { _venueDetailsModel = _venueDetailsViewModel.GetVenueDetails(); ddVenue.DataSource = _venueDetailsModel; ddVenue.DataTextField = "VenueName"; ddVenue.DataValueField = "VenueID"; ddVenue.DataBind(); } else { _venueDetails = _venueDetailsViewModel.GetVenueDetailsByID(Session["SVenue"].ToString()); ListItem lst = new ListItem(); lst.Text = _venueDetails.VenueName; lst.Value = _venueDetails.VenueID.ToString(); ddVenue.Items.Add(lst); } ListItem lst1 = new ListItem(); lst1.Text = "--SELECT--"; lst1.Value = "--SELECT--"; ddVenue.Items.Insert(0, lst1); } catch (Exception ex) { ErrHandler.WriteError(ex.Message); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript'>"); sb.Append(@"alert('Error : " + ex.Message + "')"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", sb.ToString(), false); } }
protected void GetVenueDetails(string VenueID) { try { VenueDetailsViewModel _venueDetailsViewModel = new VenueDetailsViewModel(); VenueDetailsModel _venueDetailsModel = new VenueDetailsModel(); _venueDetailsModel = _venueDetailsViewModel.GetVenueDetailsByID(VenueID); hdVenueID.Value = _venueDetailsModel.VenueID.ToString(); txtVenueName.Value = _venueDetailsModel.VenueName; txtStreetAddress.Value = _venueDetailsModel.StreetAddress; txtCity.Value = _venueDetailsModel.City; txtStateProvision.Value = _venueDetailsModel.StateProvision; txtZipCode.Value = _venueDetailsModel.ZipCode; VenueImagePath.Value = _venueDetailsModel.VenueImage; img_prev.Src = _venueDetailsModel.VenueImage; } catch (Exception ex) { throw ex; } }
protected void GetVenueDetails() { try { List<VenueDetailsModel> _venueDetails = new List<VenueDetailsModel>(); VenueDetailsModel _VenueDetailsModel = new VenueDetailsModel(); VenueDetailsViewModel venueList = new VenueDetailsViewModel(); //TODO if (Convert.ToInt32(Session["SVenue"].ToString()) == 0) { _venueDetails = venueList.GetVenueDetails(); foreach (var item in _venueDetails) { ListItem lst = new ListItem(); lst.Text = item.VenueName; lst.Value = item.VenueID.ToString(); ddVenueDetails.Items.Add(lst); } } else { _VenueDetailsModel = venueList.GetVenueDetailsByID(Session["SVenue"].ToString()); ListItem lst = new ListItem(); lst.Text = _VenueDetailsModel.VenueName; lst.Value = _VenueDetailsModel.VenueID.ToString(); ddVenueDetails.Items.Add(lst); } } catch (Exception ex) { ErrHandler.WriteError(ex.Message); System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append(@"<script language='javascript'>"); sb.Append(@"alert('Error : " + ex.Message + "')"); sb.Append(@"</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Error", sb.ToString(), false); } }
public bool UpdateVenueDetails(VenueDetailsModel venueDetailsModel) { try { using (SqlConnection conn = new SqlConnection(ConnString)) { using (SqlCommand cmd = new SqlCommand("SL_PROC_UPDATE_VENUE", conn)) { conn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@VenueID", SqlDbType.Int).Value = venueDetailsModel.VenueID; cmd.Parameters.Add("@VenueName", SqlDbType.VarChar,50).Value = venueDetailsModel.VenueName; cmd.Parameters.Add("@StreetAddress", SqlDbType.VarChar,200).Value = venueDetailsModel.StreetAddress; cmd.Parameters.Add("@City", SqlDbType.VarChar,100).Value = venueDetailsModel.City; cmd.Parameters.Add("@StateProvision", SqlDbType.VarChar,100).Value = venueDetailsModel.StateProvision; cmd.Parameters.Add("@ZipCode", SqlDbType.VarChar,20).Value = venueDetailsModel.ZipCode; cmd.Parameters.Add("@VenueImage", SqlDbType.VarChar).Value = venueDetailsModel.VenueImage; cmd.ExecuteNonQuery(); return true; } } } catch (Exception ex) { throw ex; } }
public bool SaveVenueDetails(VenueDetailsModel venueDetailsModel) { try { using (SqlConnection conn = new SqlConnection(ConnString)) { using (SqlCommand cmd = new SqlCommand("INSERT INTO Venue(VenueName, StreetAddress, City, StateProvision, ZipCode, VenueImage) VALUES('" + venueDetailsModel.VenueName + "','" + venueDetailsModel.StreetAddress + "','" + venueDetailsModel.City + "','" + venueDetailsModel.StateProvision + "','" + venueDetailsModel.ZipCode + "','" + venueDetailsModel.VenueImage + "')" , conn)) { conn.Open(); cmd.ExecuteNonQuery(); return true; } } } catch (Exception ex) { throw ex; } }
public VenueDetailsModel GetVenueDetailsByID(string VenueID) { try { VenueDetailsModel _venueDetailsModel = new VenueDetailsModel(); using (SqlConnection conn = new SqlConnection(ConnString)) { using (SqlCommand cmd = new SqlCommand("SELECT * FROM Venue Where VenueID='" + VenueID + "'", conn)) { conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { _venueDetailsModel.VenueID = Convert.ToInt32(dr["VenueID"]); _venueDetailsModel.VenueName = dr["VenueName"].ToString(); _venueDetailsModel.StreetAddress = dr["StreetAddress"].ToString(); _venueDetailsModel.City = dr["City"].ToString(); _venueDetailsModel.StateProvision = dr["StateProvision"].ToString(); _venueDetailsModel.ZipCode = dr["ZipCode"].ToString(); _venueDetailsModel.VenueImage = dr["VenueImage"].ToString(); _venueDetailsModel.TicketBackgroundImage = dr["TicketBackgroundImage"].ToString(); } } } return _venueDetailsModel; } catch (Exception ex) { throw ex; } }