public EventMasterModel GetEventDetails(string EventID)
{
try
{
EventMasterModel eventMasterModel = new EventMasterModel();
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand cmd = new SqlCommand("SL_PROC_EVENTMASTER", conn))
{
conn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EventSPID", SqlDbType.VarChar, 22).Value = EventID;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
eventMasterModel.EventTypeID = dr["EventTypeID"].ToString();
eventMasterModel.EventType = dr["EventType"].ToString();
eventMasterModel.EventSubtypeID = dr["EventSubtypeID"].ToString();
eventMasterModel.EventSubTypeDesc = dr["EventSubTypeDesc"].ToString();
eventMasterModel.VenueID = dr["VenueID"].ToString();
eventMasterModel.VenueName = dr["VenueName"].ToString();
eventMasterModel.EventTitle = dr["EventTitle"].ToString();
eventMasterModel.EventDesc = dr["EventDesc"].ToString();
eventMasterModel.Artists = dr["Artists"].ToString();
eventMasterModel.Genre = dr["Genre"].ToString();
eventMasterModel.ImagePath = dr["ImagePath"].ToString();
eventMasterModel.EventID = dr["EventSPID"].ToString();
eventMasterModel.EventDate = dr["EventDate"].ToString();
eventMasterModel.EventLayout = dr["EventLayout"].ToString();
eventMasterModel.SmallImagePath = dr["SmallImagePath"].ToString();
}
}
}
return eventMasterModel;
}
catch
{
return null;
}
}
public bool UpdateEventMaster(EventMasterModel eventMasterModel, List<EventTimeDetailsModel> eventTimeDetailsModel)
{
try
{
string EVENTID = "";
using (SqlConnection conn = new SqlConnection(ConnString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
using (SqlCommand cmd = new SqlCommand("SL_PROC_UPDATE_EVENT_NEW", conn, trans))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@EventTypeID", SqlDbType.Int).Value = eventMasterModel.EventTypeID;
cmd.Parameters.Add("@EventSubtypeID", SqlDbType.Int).Value = eventMasterModel.EventSubtypeID;
cmd.Parameters.Add("@VenueID", SqlDbType.Int).Value = eventMasterModel.VenueID;
cmd.Parameters.Add("@EventTitle", SqlDbType.VarChar, 200).Value = eventMasterModel.EventTitle;
cmd.Parameters.Add("@EventDesc", SqlDbType.VarChar).Value = eventMasterModel.EventDesc;
cmd.Parameters.Add("@Artists", SqlDbType.VarChar, 500).Value = eventMasterModel.Artists;
cmd.Parameters.Add("@Genre", SqlDbType.VarChar, 500).Value = eventMasterModel.Genre;
cmd.Parameters.Add("@EventImg", SqlDbType.VarChar).Value = eventMasterModel.ImagePath;
cmd.Parameters.Add("@EventID", SqlDbType.VarChar, 22).Value = eventMasterModel.EventID;
cmd.Parameters.Add("@EventDate", SqlDbType.VarChar, 22).Value = eventMasterModel.EventDate;
cmd.Parameters.Add("@EvenLayOut", SqlDbType.VarChar).Value = eventMasterModel.EventLayout;
cmd.Parameters.Add("@SmallImage", SqlDbType.VarChar).Value = eventMasterModel.SmallImagePath;
cmd.ExecuteNonQuery();
EVENTID = eventMasterModel.EventID;
}
for (int i = 0; i < eventTimeDetailsModel.Count; i++)
{
using (SqlCommand cmd = new SqlCommand("proc_UPDATE_EventTime", conn, trans))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@EventFromTime", SqlDbType.VarChar, 35).Value = eventTimeDetailsModel[i].EventFromTime.ToString();
cmd.Parameters.Add("@EventToTime", SqlDbType.VarChar, 35).Value = eventTimeDetailsModel[i].EventToTime.ToString();
cmd.Parameters.Add("@EventSPID", SqlDbType.VarChar, 22).Value = eventMasterModel.EventID;
cmd.ExecuteNonQuery();
}
}
trans.Commit();
}
catch (Exception ex)
{
ErrHandler.WriteError(ex.Message);
trans.Rollback();
return false;
}
}
}
return true;
}
catch (Exception ex1)
{
ErrHandler.WriteError(ex1.Message);
return false;
}
}
private void EditEventDetails(string EventSPID)
{
try
{
EventsEntryPageViewModel eventsEntryPageViewModel = new EventsEntryPageViewModel();
EventMasterModel _eventMasterModel = new EventMasterModel();
_eventMasterModel = eventsEntryPageViewModel.GetEventDetails(EventSPID);
if (_eventMasterModel != null)
{
txtEventTitle.Value = _eventMasterModel.EventTitle;
txtEventDesc.Value = _eventMasterModel.EventDesc;
txtArtist.Value = _eventMasterModel.Artists;
txtGenre.Value = _eventMasterModel.Genre;
txtEventDate.Value = _eventMasterModel.EventDate;
ddEventType.SelectedValue = _eventMasterModel.EventTypeID;
GetEventSubType(Convert.ToInt32(_eventMasterModel.EventTypeID));
img_prev.Src = _eventMasterModel.ImagePath;
imgSmallImg.Src = _eventMasterModel.SmallImagePath;
ImgTicketImage.Src = _eventMasterModel.EventLayout;
ddEvebtSubType.SelectedValue = _eventMasterModel.EventSubtypeID;
ddVenueDetails.SelectedValue = _eventMasterModel.VenueID;
hdEventID.Value = _eventMasterModel.EventID;
hdImagePath.Value = _eventMasterModel.ImagePath;
hdEventImagePath.Value = _eventMasterModel.SmallImagePath;
hdTicketImagePath.Value = _eventMasterModel.EventLayout;
txtEventDate.Value = Convert.ToDateTime(_eventMasterModel.EventDate).ToString("dd/MMM/yyyy");
}
EventTimeDetailsModel _eventTimeDetailsModel = new EventTimeDetailsModel();
_eventTimeDetailsModel = eventsEntryPageViewModel.GetEventTimeDetails(EventSPID);
if (_eventTimeDetailsModel != null)
{
txtFromTime.Value = _eventTimeDetailsModel.EventFromTime.ToString("HH:mm");
txtTotTime.Value = _eventTimeDetailsModel.EventToTime.ToString("HH:mm");
EventTimeID.Value = _eventTimeDetailsModel.EventTimeID.ToString();
}
List<EventPriceDetailsModel> _eventPriceDetailsModel = new List<EventPriceDetailsModel>();
_eventPriceDetailsModel = eventsEntryPageViewModel.GetEventPriceDetails(EventSPID);
int i = 1;
if (_eventPriceDetailsModel != null)
{
foreach (var item in _eventPriceDetailsModel)
{
if (i == 1)
{
EPID1.Value = item.EventPriceID;
txtTicketType1.Value = item.EventPriceDetails;
txtTotalSeat1.Value = item.EventTotalSeat.ToString();
txtTicketPrice1.Value = item.EventPrice;
}
if (i == 2)
{
EPID2.Value = item.EventPriceID;
txtTicketType2.Value = item.EventPriceDetails;
txtTotalSeat2.Value = item.EventTotalSeat.ToString();
txtTicketPrice2.Value = item.EventPrice;
}
if (i == 3)
{
EPID3.Value = item.EventPriceID;
txtTicketType3.Value = item.EventPriceDetails;
txtTotalSeat3.Value = item.EventTotalSeat.ToString();
txtTicketPrice3.Value = item.EventPrice;
}
if (i == 4)
{
EPID4.Value = item.EventPriceID;
txtTicketType4.Value = item.EventPriceDetails;
txtTotalSeat4.Value = item.EventTotalSeat.ToString();
txtTicketPrice4.Value = item.EventPrice;
}
if (i == 5)
{
EPID5.Value = item.EventPriceID;
txtTicketType5.Value = item.EventPriceDetails;
txtTotalSeat5.Value = item.EventTotalSeat.ToString();
txtTicketPrice5.Value = item.EventPrice;
}
if (i == 6)
{
EPID6.Value = item.EventPriceID;
txtTicketType6.Value = item.EventPriceDetails;
txtTotalSeat6.Value = item.EventTotalSeat.ToString();
txtTicketPrice6.Value = item.EventPrice;
}
if (i == 7)
{
EPID7.Value = item.EventPriceID;
txtTicketType7.Value = item.EventPriceDetails;
txtTotalSeat7.Value = item.EventTotalSeat.ToString();
txtTicketPrice7.Value = item.EventPrice;
}
if (i == 8)
{
EPID8.Value = item.EventPriceID;
txtTicketType8.Value = item.EventPriceDetails;
txtTotalSeat8.Value = item.EventTotalSeat.ToString();
txtTicketPrice8.Value = item.EventPrice;
}
if (i == 9)
{
EPID9.Value = item.EventPriceID;
txtTicketType9.Value = item.EventPriceDetails;
txtTotalSeat9.Value = item.EventTotalSeat.ToString();
txtTicketPrice9.Value = item.EventPrice;
}
if (i == 10)
{
EPID10.Value = item.EventPriceID;
txtTicketType10.Value = item.EventPriceDetails;
txtTotalSeat10.Value = item.EventTotalSeat.ToString();
txtTicketPrice10.Value = item.EventPrice;
}
if (i == 11)
{
EPID11.Value = item.EventPriceID;
txtTicketType11.Value = item.EventPriceDetails;
txtTotalSeat11.Value = item.EventTotalSeat.ToString();
txtTicketPrice11.Value = item.EventPrice;
}
if (i == 12)
{
EPID12.Value = item.EventPriceID;
txtTicketType12.Value = item.EventPriceDetails;
txtTotalSeat12.Value = item.EventTotalSeat.ToString();
txtTicketPrice12.Value = item.EventPrice;
}
if (i == 13)
{
EPID13.Value = item.EventPriceID;
txtTicketType13.Value = item.EventPriceDetails;
txtTotalSeat13.Value = item.EventTotalSeat.ToString();
txtTicketPrice13.Value = item.EventPrice;
}
if (i == 14)
{
EPID14.Value = item.EventPriceID;
txtTicketType14.Value = item.EventPriceDetails;
txtTotalSeat14.Value = item.EventTotalSeat.ToString();
txtTicketPrice14.Value = item.EventPrice;
}
if (i == 15)
{
EPID15.Value = item.EventPriceID;
txtTicketType15.Value = item.EventPriceDetails;
txtTotalSeat15.Value = item.EventTotalSeat.ToString();
txtTicketPrice15.Value = item.EventPrice;
}
i++;
}
}
btnSave.Visible = false;
btnUpdate.Visible = true;
}
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 btnSave_ServerClick(object sender, EventArgs e)
{
try
{
if (ValidatePage() == true)
{
//BIG IMAGE
string s = filenm.Value;
string[] file = s.Split('.');
string t = file[file.Length - 1].ToString();
string ext = "";
var r = new Random();
string d = DateTime.Now.ToString("ddMMyyhhmmss") + r.Next(100);
ext = "E" + d;
string baseImageLocation = Server.MapPath("~\\ShowlineImages\\");
HttpFileCollection files = Request.Files;
HttpPostedFile httpPostedFile = files["filenm"];
string fileExt = Path.GetExtension(httpPostedFile.FileName).ToLower();
string fileName = Path.GetFileName(httpPostedFile.FileName);
//SMALL IMAGE
string sm = filesmallimage.Value;
string[] filesm = sm.Split('.');
string tsm = filesm[filesm.Length - 1].ToString();
string extSM = "";
string dsm = DateTime.Now.ToString("ddMMyyhhmmss") + r.Next(100);
extSM = "S" + dsm;
string baseImageLocationsm = Server.MapPath("~\\ShowlineImages\\");
HttpFileCollection filessm = Request.Files;
HttpPostedFile httpPostedFilesm = filessm["filesmallimage"];
string fileExtsm = Path.GetExtension(httpPostedFilesm.FileName).ToLower();
string fileNamesm = Path.GetFileName(httpPostedFilesm.FileName);
// TICKET IMAGE
string sTm = filebackgroundimage.Value;
string[] filesTm = sTm.Split('.');
string tsTm = filesTm[filesTm.Length - 1].ToString();
string extSTM = "";
string dsTm = DateTime.Now.ToString("ddMMyyhhmmss") + r.Next(100);
extSTM = "T" + dsTm;
string baseImageLocationsTm = Server.MapPath("~\\ShowlineImages\\");
HttpFileCollection filessTm = Request.Files;
HttpPostedFile httpPostedFilesTm = filessTm["filebackgroundimage"];
string fileExtsTm = Path.GetExtension(httpPostedFilesTm.FileName).ToLower();
string fileNamesTm = Path.GetFileName(httpPostedFilesTm.FileName);
//
EventsEntryPageViewModel _eventMasterDAL = new EventsEntryPageViewModel();
EventMasterModel eventMasterModel = new EventMasterModel();
List<EventTimeDetailsModel> eventTimeDetailsModel = new List<EventTimeDetailsModel>();
List<EventPriceDetailsModel> eventPriceDetailsModel = new List<EventPriceDetailsModel>();
eventMasterModel.EventTypeID = ddEventType.SelectedItem.Value;
eventMasterModel.EventSubtypeID = ddEvebtSubType.SelectedItem.Value.ToString();
eventMasterModel.VenueID = ddVenueDetails.SelectedItem.Value;
eventMasterModel.EventTitle = txtEventTitle.Value.Trim();
eventMasterModel.EventDesc = txtEventDesc.Value.Trim();
eventMasterModel.Artists = txtArtist.Value.Trim();
eventMasterModel.Genre = txtGenre.Value.Trim();
eventMasterModel.ImagePath = "/ShowlineImages/" + ext + "." + file[file.Length - 1].ToString();
eventMasterModel.SmallImagePath = "/ShowlineImages/" + extSM + "." + filesm[filesm.Length - 1].ToString();
eventMasterModel.EventLayout = "/ShowlineImages/" + extSTM + "." + filesTm[filesTm.Length - 1].ToString();
eventMasterModel.EventID = ext;
eventMasterModel.EventDate = txtEventDate.Value;
eventTimeDetailsModel.Add(new EventTimeDetailsModel
{
EventFromTime = Convert.ToDateTime(txtFromTime.Value),
EventToTime = Convert.ToDateTime(txtTotTime.Value)
});
if (txtTicketType1.Value.Trim() != "" || txtTotalSeat1.Value.Trim() != "" || txtTicketPrice1.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType1.Value.Trim(), EventPrice = txtTicketPrice1.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat1.Value.Trim()) });
}
if (txtTicketType2.Value.Trim() != "" || txtTotalSeat2.Value.Trim() != "" || txtTicketPrice2.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType2.Value.Trim(), EventPrice = txtTicketPrice2.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat2.Value.Trim()) });
}
if (txtTicketType3.Value.Trim() != "" || txtTotalSeat3.Value.Trim() != "" || txtTicketPrice3.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType3.Value.Trim(), EventPrice = txtTicketPrice3.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat3.Value.Trim()) });
}
if (txtTicketType4.Value.Trim() != "" || txtTotalSeat4.Value.Trim() != "" || txtTicketPrice4.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType4.Value.Trim(), EventPrice = txtTicketPrice4.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat4.Value.Trim()) });
}
if (txtTicketType5.Value.Trim() != "" || txtTotalSeat5.Value.Trim() != "" || txtTicketPrice5.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType5.Value.Trim(), EventPrice = txtTicketPrice5.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat5.Value.Trim()) });
}
if (txtTicketType6.Value.Trim() != "" || txtTotalSeat6.Value.Trim() != "" || txtTicketPrice6.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType6.Value.Trim(), EventPrice = txtTicketPrice6.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat6.Value.Trim()) });
}
if (txtTicketType7.Value.Trim() != "" || txtTotalSeat7.Value.Trim() != "" || txtTicketPrice7.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType7.Value.Trim(), EventPrice = txtTicketPrice7.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat7.Value.Trim()) });
}
if (txtTicketType8.Value.Trim() != "" || txtTotalSeat8.Value.Trim() != "" || txtTicketPrice8.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType8.Value.Trim(), EventPrice = txtTicketPrice8.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat8.Value.Trim()) });
}
if (txtTicketType9.Value.Trim() != "" || txtTotalSeat9.Value.Trim() != "" || txtTicketPrice9.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType9.Value.Trim(), EventPrice = txtTicketPrice9.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat9.Value.Trim()) });
}
if (txtTicketType10.Value.Trim() != "" || txtTotalSeat10.Value.Trim() != "" || txtTicketPrice10.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType10.Value.Trim(), EventPrice = txtTicketPrice10.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat10.Value.Trim()) });
}
if (txtTicketType11.Value.Trim() != "" || txtTotalSeat11.Value.Trim() != "" || txtTicketPrice11.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType11.Value.Trim(), EventPrice = txtTicketPrice11.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat11.Value.Trim()) });
}
if (txtTicketType12.Value.Trim() != "" || txtTotalSeat12.Value.Trim() != "" || txtTicketPrice12.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType12.Value.Trim(), EventPrice = txtTicketPrice12.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat12.Value.Trim()) });
}
if (txtTicketType13.Value.Trim() != "" || txtTotalSeat13.Value.Trim() != "" || txtTicketPrice13.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType13.Value.Trim(), EventPrice = txtTicketPrice13.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat13.Value.Trim()) });
}
if (txtTicketType14.Value.Trim() != "" || txtTotalSeat14.Value.Trim() != "" || txtTicketPrice14.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType14.Value.Trim(), EventPrice = txtTicketPrice14.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat14.Value.Trim()) });
}
if (txtTicketType15.Value.Trim() != "" || txtTotalSeat15.Value.Trim() != "" || txtTicketPrice15.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType15.Value.Trim(), EventPrice = txtTicketPrice15.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat15.Value.Trim()) });
}
if (_eventMasterDAL.InsertEventMaster(eventMasterModel, eventTimeDetailsModel, eventPriceDetailsModel) == true)
{
if (fileName != "")
{
httpPostedFile.SaveAs(baseImageLocation + ext + "." + file[file.Length - 1].ToString());
}
if (fileNamesm != "")
{
httpPostedFilesm.SaveAs(baseImageLocationsm + extSM + "." + filesm[filesm.Length - 1].ToString());
}
if (fileExtsTm != "")
{
httpPostedFilesTm.SaveAs(baseImageLocationsTm + extSTM + "." + filesTm[filesTm.Length - 1].ToString());
}
ClearAllControl();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add Event Details", "<script type='text/javascript'>ConfirmMsg('Event Saved Sucessfully.','Add Event Details');</script>", false);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add Event Details", "<script type='text/javascript'>ErrorMsg('Unexpected error occured.Plese refresh the page and try again!','Add Event Details');</script>", false);
}
}
}
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 btnUpdate_ServerClick(object sender, EventArgs e)
{
try
{
if (ValidatePage() == true)
{
string s = filenm.Value;
string[] file;
string ext = "";
if (s == "")
{
file = hdImagePath.Value.Split('.');
}
else
{
file = s.Split('.');
}
string t = file[file.Length - 1].ToString();
var r = new Random();
string d = hdEventID.Value;
ext = d;
string baseImageLocation = Server.MapPath("~\\ShowlineImages\\");
HttpFileCollection files = Request.Files;
HttpPostedFile httpPostedFile = files["filenm"];
string fileExt = Path.GetExtension(httpPostedFile.FileName).ToLower();
string fileName = Path.GetFileName(httpPostedFile.FileName);
#region SmallImagePath
string sm = filesmallimage.Value;
string[] filesm;
string extsm = "";
string dsm = "S" + hdEventID.Value.Substring(1, hdEventID.Value.Length - 1);
if (sm == "")
{
filesm = hdEventImagePath.Value.Split('.');
}
else
{
filesm = sm.Split('.');
}
string tsm = filesm[filesm.Length - 1].ToString();
r = new Random();
extsm = dsm;
string baseImageLocationsm = Server.MapPath("~\\ShowlineImages\\");
HttpFileCollection filessm = Request.Files;
HttpPostedFile httpPostedFilesm = filessm["filesmallimage"];
string fileExtsm = Path.GetExtension(httpPostedFilesm.FileName).ToLower();
string fileNamesm = Path.GetFileName(httpPostedFilesm.FileName);
#endregion
#region TicketImage
string sTm = filebackgroundimage.Value;
string[] filesTm;
string extsTm = "";
string dsTm = "T" + hdEventID.Value.Substring(1, hdEventID.Value.Length - 1);
if (sTm == "")
{
filesTm = hdTicketImagePath.Value.Split('.');
}
else
{
filesTm = sTm.Split('.');
}
string tTm = filesTm[filesTm.Length - 1].ToString();
r = new Random();
extsTm = dsTm;
string baseImageLocationsTm = Server.MapPath("~\\ShowlineImages\\");
HttpFileCollection filessTm = Request.Files;
HttpPostedFile httpPostedFilesTm = filessTm["filebackgroundimage"];
string fileExtsTm = Path.GetExtension(httpPostedFilesTm.FileName).ToLower();
string fileNamesTm = Path.GetFileName(httpPostedFilesTm.FileName);
#endregion
EventsEntryPageViewModel _eventMasterDAL = new EventsEntryPageViewModel();
EventMasterModel eventMasterModel = new EventMasterModel();
List<EventTimeDetailsModel> eventTimeDetailsModel = new List<EventTimeDetailsModel>();
List<EventPriceDetailsModel> eventPriceDetailsModel = new List<EventPriceDetailsModel>();
eventMasterModel.EventTypeID = ddEventType.SelectedItem.Value;
eventMasterModel.EventSubtypeID = ddEvebtSubType.SelectedItem.Value.ToString();
eventMasterModel.VenueID = ddVenueDetails.SelectedItem.Value;
eventMasterModel.EventTitle = txtEventTitle.Value.Trim();
eventMasterModel.EventDesc = txtEventDesc.Value.Trim();
eventMasterModel.Artists = txtArtist.Value.Trim();
eventMasterModel.Genre = txtGenre.Value.Trim();
eventMasterModel.ImagePath = "/ShowlineImages/" + ext + "." + file[file.Length - 1].ToString();
eventMasterModel.SmallImagePath = "/ShowlineImages/" + extsm + "." + filesm[filesm.Length - 1].ToString();
eventMasterModel.EventLayout = "/ShowlineImages/" + extsTm + "." + filesTm[filesTm.Length - 1].ToString();
eventMasterModel.EventID = ext;
eventMasterModel.EventDate = txtEventDate.Value;
eventTimeDetailsModel.Add(new EventTimeDetailsModel
{
EventFromTime = Convert.ToDateTime(txtFromTime.Value),
EventToTime = Convert.ToDateTime(txtTotTime.Value)
//EventFromTime = Convert.ToDateTime(txtEventDate.Value + " " + txtFromTime.Value),
//EventToTime = Convert.ToDateTime(txtEventDate.Value + " " + txtTotTime.Value)
});
if (txtTicketType1.Value.Trim() != "" || txtTotalSeat1.Value.Trim() != "" || txtTicketPrice1.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType1.Value.Trim(), EventPrice = txtTicketPrice1.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat1.Value.Trim()) });
}
if (txtTicketType2.Value.Trim() != "" || txtTotalSeat2.Value.Trim() != "" || txtTicketPrice2.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType2.Value.Trim(), EventPrice = txtTicketPrice2.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat2.Value.Trim()) });
}
if (txtTicketType3.Value.Trim() != "" || txtTotalSeat3.Value.Trim() != "" || txtTicketPrice3.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType3.Value.Trim(), EventPrice = txtTicketPrice3.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat3.Value.Trim()) });
}
if (txtTicketType4.Value.Trim() != "" || txtTotalSeat4.Value.Trim() != "" || txtTicketPrice4.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType4.Value.Trim(), EventPrice = txtTicketPrice4.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat4.Value.Trim()) });
}
if (txtTicketType5.Value.Trim() != "" || txtTotalSeat5.Value.Trim() != "" || txtTicketPrice5.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType5.Value.Trim(), EventPrice = txtTicketPrice5.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat5.Value.Trim()) });
}
if (txtTicketType6.Value.Trim() != "" || txtTotalSeat6.Value.Trim() != "" || txtTicketPrice6.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType6.Value.Trim(), EventPrice = txtTicketPrice6.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat6.Value.Trim()) });
}
if (txtTicketType7.Value.Trim() != "" || txtTotalSeat7.Value.Trim() != "" || txtTicketPrice7.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType7.Value.Trim(), EventPrice = txtTicketPrice7.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat7.Value.Trim()) });
}
if (txtTicketType8.Value.Trim() != "" || txtTotalSeat8.Value.Trim() != "" || txtTicketPrice8.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType8.Value.Trim(), EventPrice = txtTicketPrice8.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat8.Value.Trim()) });
}
if (txtTicketType9.Value.Trim() != "" || txtTotalSeat9.Value.Trim() != "" || txtTicketPrice9.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType9.Value.Trim(), EventPrice = txtTicketPrice9.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat9.Value.Trim()) });
}
if (txtTicketType10.Value.Trim() != "" || txtTotalSeat10.Value.Trim() != "" || txtTicketPrice10.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType10.Value.Trim(), EventPrice = txtTicketPrice10.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat10.Value.Trim()) });
}
if (txtTicketType11.Value.Trim() != "" || txtTotalSeat11.Value.Trim() != "" || txtTicketPrice11.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType11.Value.Trim(), EventPrice = txtTicketPrice11.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat11.Value.Trim()) });
}
if (txtTicketType12.Value.Trim() != "" || txtTotalSeat12.Value.Trim() != "" || txtTicketPrice12.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType12.Value.Trim(), EventPrice = txtTicketPrice12.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat12.Value.Trim()) });
}
if (txtTicketType13.Value.Trim() != "" || txtTotalSeat13.Value.Trim() != "" || txtTicketPrice13.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType13.Value.Trim(), EventPrice = txtTicketPrice13.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat13.Value.Trim()) });
}
if (txtTicketType14.Value.Trim() != "" || txtTotalSeat14.Value.Trim() != "" || txtTicketPrice14.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType14.Value.Trim(), EventPrice = txtTicketPrice14.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat14.Value.Trim()) });
}
if (txtTicketType15.Value.Trim() != "" || txtTotalSeat15.Value.Trim() != "" || txtTicketPrice15.Value.Trim() != "")
{
eventPriceDetailsModel.Add(new EventPriceDetailsModel { EventPriceDetails = txtTicketType15.Value.Trim(), EventPrice = txtTicketPrice15.Value.Trim(), EventTotalSeat = Convert.ToInt32(txtTotalSeat15.Value.Trim()) });
}
if (_eventMasterDAL.UpdateEventMaster(eventMasterModel, eventTimeDetailsModel) == true)
{
if (fileName != "")
{
//FileInfo fileInfoPath = new FileInfo(baseImageLocation + ext + "." + file[file.Length - 1].ToString());
//if (fileInfoPath.Exists)
//{
// fileInfoPath.Delete();
//}
httpPostedFile.SaveAs(baseImageLocation + ext + "." + file[file.Length - 1].ToString());
}
if (fileNamesm != "")
{
httpPostedFilesm.SaveAs(baseImageLocation + extsm + "." + filesm[filesm.Length - 1].ToString());
}
if (fileNamesTm != "")
{
httpPostedFilesTm.SaveAs(baseImageLocation + extsTm + "." + filesTm[filesTm.Length - 1].ToString());
}
ClearAllControl();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add Event Details", "<script type='text/javascript'>ConfirmMsg('Event Saved Sucessfully.','Add Event Details');</script>", false);
Response.Redirect("~/viewevent.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add Event Details", "<script type='text/javascript'>ErrorMsg('Unexpected error occured.Plese refresh the page and try again!','Add Event Details');</script>", false);
}
//if (_eventMasterDAL.DeleteEventDetails(hdEventID.Value) == true)
//{
// if (_eventMasterDAL.InsertEventMaster(eventMasterModel, eventTimeDetailsModel, eventPriceDetailsModel) == true)
// {
// if (fileName != "")
// {
// httpPostedFile.SaveAs(baseImageLocation + ext + "." + file[file.Length - 1].ToString());
// }
// if (fileNamesm != "")
// {
// httpPostedFilesm.SaveAs(baseImageLocation + extsm + "." + filesm[filesm.Length - 1].ToString());
// }
// if (fileNamesTm != "")
// {
// httpPostedFilesTm.SaveAs(baseImageLocation + extsTm + "." + filesTm[filesTm.Length - 1].ToString());
// }
// ClearAllControl();
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add Event Details", "<script type='text/javascript'>ConfirmMsg('Event Saved Sucessfully.','Add Event Details');</script>", false);
// //Response.Redirect("~/viewevent.aspx"); //kk redirect
// Response.Redirect("~/viewevent.aspx", false);
// Context.ApplicationInstance.CompleteRequest();
// }
// else
// {
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add Event Details", "<script type='text/javascript'>ErrorMsg('Unexpected error occured.Plese refresh the page and try again!','Add Event Details');</script>", false);
// }
//}
//else
//{
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Add Event Details", "<script type='text/javascript'>ErrorMsg('Unexpected error occured.Plese refresh the page and try again!','Add Event Details');</script>", false);
//}
}
}
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 InsertEventMaster(EventMasterModel eventMasterModel, List<EventTimeDetailsModel> eventTimeDetailsModel, List<EventPriceDetailsModel> eventPriceDetailsModel)
{
try
{
string EVENTID = "";
using (SqlConnection conn = new SqlConnection(ConnString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
using (SqlCommand cmd = new SqlCommand("proc_INSERT_EVENT", conn, trans))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@EventTypeID", SqlDbType.Int).Value = eventMasterModel.EventTypeID;
cmd.Parameters.Add("@EventSubtypeID", SqlDbType.Int).Value = eventMasterModel.EventSubtypeID;
cmd.Parameters.Add("@VenueID", SqlDbType.Int).Value = eventMasterModel.VenueID;
cmd.Parameters.Add("@EventTitle", SqlDbType.VarChar, 200).Value = eventMasterModel.EventTitle;
cmd.Parameters.Add("@EventDesc", SqlDbType.VarChar).Value = eventMasterModel.EventDesc;
cmd.Parameters.Add("@Artists", SqlDbType.VarChar, 500).Value = eventMasterModel.Artists;
cmd.Parameters.Add("@Genre", SqlDbType.VarChar, 500).Value = eventMasterModel.Genre;
cmd.Parameters.Add("@EventImg", SqlDbType.VarChar).Value = eventMasterModel.ImagePath;
cmd.Parameters.Add("@EventID", SqlDbType.VarChar, 22).Value = eventMasterModel.EventID;
cmd.Parameters.Add("@EventDate", SqlDbType.VarChar, 22).Value = eventMasterModel.EventDate;
cmd.Parameters.Add("@EvenLayOut", SqlDbType.VarChar).Value = eventMasterModel.EventLayout;
cmd.Parameters.Add("@SmallImage", SqlDbType.VarChar).Value = eventMasterModel.SmallImagePath;
cmd.ExecuteNonQuery();
EVENTID = eventMasterModel.EventID;
}
for (int i = 0; i < eventTimeDetailsModel.Count; i++)
{
using (SqlCommand cmd = new SqlCommand("proc_INSERT_EventTime", conn, trans))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@EventFromTime", SqlDbType.VarChar, 35).Value = eventTimeDetailsModel[i].EventFromTime.ToString();
cmd.Parameters.Add("@EventToTime", SqlDbType.VarChar, 35).Value = eventTimeDetailsModel[i].EventToTime.ToString();
cmd.Parameters.Add("@EventSPID", SqlDbType.VarChar, 22).Value = eventMasterModel.EventID;
cmd.ExecuteNonQuery();
}
}
for (int j = 0; j < eventPriceDetailsModel.Count; j++)
{
using (SqlCommand cmd = new SqlCommand("proc_insert_eventprice", conn, trans))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@eventpricedetails", SqlDbType.VarChar, 100).Value = eventPriceDetailsModel[j].EventPriceDetails.ToString();
cmd.Parameters.Add("@eventprice", SqlDbType.VarChar, 6).Value = eventPriceDetailsModel[j].EventPrice.ToString();
cmd.Parameters.Add("@eventtotalseat", SqlDbType.Int).Value = eventPriceDetailsModel[j].EventTotalSeat.ToString();
cmd.Parameters.Add("@eventspid", SqlDbType.VarChar, 22).Value = eventMasterModel.EventID;
cmd.ExecuteNonQuery();
}
}
trans.Commit();
GenerateBarCode(EVENTID);
}
catch (Exception ex)
{
trans.Rollback();
}
}
}
return true;
}
catch
{
return false;
}
}
private void EditEventDetails(string EventSPID)
{
EventsEntryPageViewModel eventsEntryPageViewModel = new EventsEntryPageViewModel();
EventMasterModel _eventMasterModel = new EventMasterModel();
_eventMasterModel = eventsEntryPageViewModel.GetEventDetails(EventSPID);
if (_eventMasterModel != null)
{
txtEventTitle.Value = _eventMasterModel.EventTitle;
txtEventDesc.Value = _eventMasterModel.EventDesc;
txtArtist.Value = _eventMasterModel.Artists;
txtGenre.Value = _eventMasterModel.Genre;
txtEventDate.Value = _eventMasterModel.EventDate;
ddEventType.SelectedValue= _eventMasterModel.EventTypeID;
GetEventSubType(Convert.ToInt32(_eventMasterModel.EventTypeID));
img_prev.Src = _eventMasterModel.ImagePath;
imgSmallImg.Src = _eventMasterModel.SmallImagePath;
ImgTicketImage.Src = _eventMasterModel.EventLayout;
ddEvebtSubType.SelectedValue = _eventMasterModel.EventSubtypeID;
ddVenueDetails.SelectedValue = _eventMasterModel.VenueID;
hdEventID.Value = _eventMasterModel.EventID;
hdImagePath.Value = _eventMasterModel.ImagePath;
hdEventImagePath.Value = _eventMasterModel.SmallImagePath;
hdTicketImagePath.Value = _eventMasterModel.EventLayout;
txtEventDate.Value = Convert.ToDateTime(_eventMasterModel.EventDate).ToString("dd/MMM/yyyy");
}
EventTimeDetailsModel _eventTimeDetailsModel = new EventTimeDetailsModel();
_eventTimeDetailsModel = eventsEntryPageViewModel.GetEventTimeDetails(EventSPID);
if (_eventTimeDetailsModel != null)
{
txtFromTime.Value = _eventTimeDetailsModel.EventFromTime.ToString("HH:mm");
txtTotTime.Value = _eventTimeDetailsModel.EventToTime.ToString("HH:mm");
EventTimeID.Value = _eventTimeDetailsModel.EventTimeID.ToString();
}
List<EventPriceDetailsModel> _eventPriceDetailsModel = new List<EventPriceDetailsModel>();
_eventPriceDetailsModel = eventsEntryPageViewModel.GetEventPriceDetails(EventSPID);
int i = 1;
if (_eventPriceDetailsModel != null)
{
foreach (var item in _eventPriceDetailsModel)
{
if (i == 1)
{
EPID1.Value = item.EventPriceID;
txtTicketType1.Value = item.EventPriceDetails;
txtTotalSeat1.Value = item.EventTotalSeat.ToString();
txtTicketPrice1.Value = item.EventPrice;
}
if (i == 2)
{
EPID2.Value = item.EventPriceID;
txtTicketType2.Value = item.EventPriceDetails;
txtTotalSeat2.Value = item.EventTotalSeat.ToString();
txtTicketPrice2.Value = item.EventPrice;
}
if (i == 3)
{
EPID3.Value = item.EventPriceID;
txtTicketType3.Value = item.EventPriceDetails;
txtTotalSeat3.Value = item.EventTotalSeat.ToString();
txtTicketPrice3.Value = item.EventPrice;
}
if (i == 4)
{
EPID4.Value = item.EventPriceID;
txtTicketType4.Value = item.EventPriceDetails;
txtTotalSeat4.Value = item.EventTotalSeat.ToString();
txtTicketPrice4.Value = item.EventPrice;
}
i++;
}
}
btnSave.Visible = false;
btnUpdate.Visible = true;
}