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