protected void Button1_Click(object sender, EventArgs e)
{
//Upload images
string ID = "1";
makeDirectory(ID);
ImageFile mainPic = new ImageFile();
mainPic = UploadFile(flEventImages, ID, SUBFOLDER); //replace 1 with actual event ID
FileUploadClient fuc = new FileUploadClient();
string res = fuc.saveImage(mainPic);
string number = res;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string EVENT_TRACKER;
string SUBFOLDER = "Main_Image";
int hostID = Convert.ToInt32(Session["ID"].ToString());
String request = (Request.QueryString["EventID"]);
if (request == null)
{
request = (Request.QueryString["ed"]);
}
EventServiceClient _eventClient = new EventServiceClient();
EventModel oldEvent = new EventModel();
oldEvent = _eventClient.findByEventID(request);
//Editing Address
EventAddress currentAdd = new EventAddress();
EventAddress Oldadd = new EventAddress();
MappingClient mc = new MappingClient();
currentAdd = mc.getAddressById(Convert.ToString(oldEvent.EventAddress));
if (txtCountry.Text.Equals(""))
{
Oldadd.COUNTRY = currentAdd.COUNTRY;
}
else
{
Oldadd.COUNTRY = txtCountry.Text;
}
if (txtCity.Text.Equals(""))
{
Oldadd.CITY = currentAdd.CITY;
}
else
{
Oldadd.CITY = txtCity.Text;
}
if (txtStreet.Text.Equals(""))
{
Oldadd.STREET = currentAdd.STREET;
}
else
{
Oldadd.STREET = txtStreet.Text;
}
if (txtProvince.Text.Equals(""))
{
Oldadd.PROVINCE = currentAdd.PROVINCE;
}
else
{
Oldadd.PROVINCE = txtProvince.Text;
}
EventAddress newAddress = new EventAddress();
newAddress = mc.EditAddress(Oldadd, Convert.ToString(oldEvent.EventAddress));
EventModel _event = new EventModel();
_event.HostID = oldEvent.HostID;
_event.Name = txtEventName.Text; //Event Name
if (chkBoxPrivate.Checked == true) //Public or Private Event
{
_event.Type = "Private";
}
else
{
_event.Type = "Public";
}
_event.Desc = txtDesc.Text; //Event Description
string startdate = "";
string enddate = "";
//DateTime sDate = DateTime.ParseExact(startdate, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture);
//DateTime eDate = DateTime.ParseExact(enddate, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture);
//_event.sDate = sDate; //Event Start Date
//_event.eDate = eDate; //Event End Date
if (txtStart.Text.Equals(""))
{
_event.sDate = oldEvent.sDate;
}
else
{
// _event.sDate = DateTime.ParseExact(txtStart.Text, "yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);
//var date = DateTime.Parse(strDate,new CultureInfo("en-US", true))
_event.sDate = Convert.ToString(DateTime.Parse(txtStart.Text, new CultureInfo("en-US", true)));
}
if (txtEnd.Text.Equals(""))
{
_event.eDate = oldEvent.eDate;
}
else
{
// _event.eDate = DateTime.ParseExact(txtEnd.Text, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture);
_event.eDate = Convert.ToString(DateTime.Parse(txtEnd.Text, new CultureInfo("en-US", true)));
}
_event.EventAddress = newAddress.ID; //Event's address ID
//check ticket field
if (!txtE_Quantity.Text.Equals(""))
{
_event.EB_Quantity = Convert.ToInt32(txtE_Quantity.Text);
}
else
{
_event.EB_Quantity = 0;
}
if (!txtR_Quantity.Text.Equals(""))
{
_event.Reg_Quantity = Convert.ToInt32(txtR_Quantity.Text);
}
else
{
_event.Reg_Quantity = 0;
}
if (!txtV_Quantity.Text.Equals(""))
{
_event.VIP_Quantity = Convert.ToInt32(txtV_Quantity.Text);
}
else
{
_event.VIP_Quantity = 0;
}
if (!txtVV_Quantity.Text.Equals(""))
{
_event.VVIP_Quantity = Convert.ToInt32(txtVV_Quantity.Text);
}
else
{
_event.VVIP_Quantity = 0;
}
//Edit Event Event
EventServiceClient _editEvent = new EventServiceClient();
EventModel newEvent = new EventModel();
newEvent = _editEvent.updateEvent(_event, request);
bool isCreatedTicket = false; //Ticket Controller
EVENT_TRACKER = "Event Edited successfully";
//Import users
//string ImportSpreadsheet = "";
//ImportSpreadsheet = ImportData(flGuest, newEvent.EventID);
//===================Import guest,staff and products============================//
string path = "";
string response = "";
bool isValidGuestColumn = false;
bool isValidStaffColumn = false;
bool isValidProductColumn = false;
int startColumn = 0;
int startRow = 0;
ExcelWorksheet GuestworkSheet = null;
ExcelWorksheet StaffworkSheet = null;
ExcelWorksheet ProductworkSheet = null;
int count = 0;
if (flGuest.HasFile)
{
try
{
string filename = Path.GetFileName(flGuest.FileName);
string serverLocation = "~/Temp/" + "/" + filename;
string SaveLoc = Server.MapPath(serverLocation);
flGuest.SaveAs(SaveLoc);
path = Server.MapPath("/") + "\\Temp\\" + filename;
var package = new ExcelPackage(new System.IO.FileInfo(path));
//// package.Workbook.Worksheets["TABNAME"].View.TabSelected = true;
startColumn = 1; //where the file in the class excel start
startRow = 2;
GuestworkSheet = package.Workbook.Worksheets[1]; //read sheet one
StaffworkSheet = package.Workbook.Worksheets[2]; //read sheet two
ProductworkSheet = package.Workbook.Worksheets[3];
isValidGuestColumn = ValidateGuestColumns(GuestworkSheet);
isValidStaffColumn = ValidateStaffColumns(StaffworkSheet);
isValidProductColumn = ValidateProductColumns(ProductworkSheet);
// isValidColumn = true;
}
catch
{
response += "Failed";
}
//check staff sheet
object data = null;
if (isValidStaffColumn == true && isValidGuestColumn == true && isValidProductColumn == true)
{
do
{
data = StaffworkSheet.Cells[startRow, startColumn].Value; //column Number
if (data == null)
{
continue;
}
//read column class name
object Name = StaffworkSheet.Cells[startRow, startColumn].Value;
object Email = StaffworkSheet.Cells[startRow, startColumn + 1].Value;
object Occupation = StaffworkSheet.Cells[startRow, startColumn + 2].Value;
StaffModel _staff = new StaffModel();
_staff.NAME = Name.ToString();
_staff.EMAIL = Email.ToString();
_staff.Occupation = Occupation.ToString();
_staff.PASS = "******";
_staff.EventID = newEvent.EventID;
//edit to db
StaffServiceClient ssv = new StaffServiceClient();
bool isCreated = ssv.createStaff(_staff);
if (isCreated == true)
{
count++;
}
startRow++;
} while (data != null);
data = null;
startColumn = 1; //where the file in the class excel start
startRow = 2;
do
{
data = GuestworkSheet.Cells[startRow, startColumn].Value; //column Number
if (data == null)
{
continue;
}
object Name = GuestworkSheet.Cells[startRow, startColumn].Value;
object Surname = GuestworkSheet.Cells[startRow, startColumn + 1].Value;
object Email = GuestworkSheet.Cells[startRow, startColumn + 2].Value;
GuestModel _guest = new GuestModel();
_guest.NAME = Name.ToString();
_guest.SURNAME = Surname.ToString();
_guest.EMAIL = Email.ToString();
_guest.PASS = "******";
_guest.TYPE = "Private";
Eventrix_Client.Registration reg = new Eventrix_Client.Registration();
// response = reg.RegisterGuest(_guest);
sendMsg(_guest, _event);
if (response.Contains("successfully"))
{
count++;
}
startRow++;
} while (data != null);
//upload product details
data = null;
startColumn = 1; //where the file in the class excel start
startRow = 2;
do
{
data = ProductworkSheet.Cells[startRow, startColumn].Value; //column Number
if (data == null)
{
continue;
}
object Name = ProductworkSheet.Cells[startRow, startColumn].Value;
object Description = ProductworkSheet.Cells[startRow, startColumn + 1].Value;
object Quantity = ProductworkSheet.Cells[startRow, startColumn + 2].Value;
object Price = ProductworkSheet.Cells[startRow, startColumn + 3].Value;
EventProduct _product = new EventProduct();
_product._Name = Name.ToString();
// _product._Desc = Description.ToString();
_product._Quantity = Convert.ToInt32(Quantity.ToString());
_product._Price = Convert.ToInt32(Price.ToString());
_product.EventID = newEvent.EventID;
ProductServiceClient psv = new ProductServiceClient();
// string isProductUpdated = psv.createProduct(_product);
string isProductUpdated = psv.createProduct(_product);
if (isProductUpdated.Contains("success"))
{
count++;
}
startRow++;
} while (data != null);
//check record
if (count == (GuestworkSheet.Dimension.Rows - 1) + (StaffworkSheet.Dimension.Rows - 1) + (ProductworkSheet.Dimension.Rows - 1))
{
response = "success: All Records uploaded";
}
else
{
response = "success: Not All Records uploaded";
}
}
else
{
response += " Failed to upload Exceel: Check columns";
}
}
else
{
response = "Failed: File not found";
}
//==============================================================================//
if (response.Contains("success"))
{
EVENT_TRACKER += "\n Spreadsheet Uploaded";
//Create Tickets
isCreatedTicket = isLoadedTicket(newEvent, newEvent.EventID);
if (isCreatedTicket == true)
{
EVENT_TRACKER += "\n Ticket Created";
}
else
{
EVENT_TRACKER += "\n Failed to upload ticket";
}
}
else
{
EVENT_TRACKER += "\n Spreadsheet Uploaded";
//Create Tickets
isCreatedTicket = isLoadedTicket(newEvent, newEvent.EventID);
if (isCreatedTicket == true)
{
EVENT_TRACKER += "\n Ticket Created";
}
else
{
EVENT_TRACKER += "\n Failed to upload ticket";
}
//Unable to upload guest
EVENT_TRACKER += "\n failed to upload spreadsheet";
}
////Upload images
ImageFile mainPic = new ImageFile();
mainPic = UploadFile(flEventImages, Convert.ToString(newEvent.EventID), SUBFOLDER); //Upload Event Main's Image to client directory
if (mainPic != null)
{
FileUploadClient fuc = new FileUploadClient();
string res1 = fuc.saveImage(mainPic); //Upload Event Main's Image to Database
string number = res1;
}
Response.Redirect("EventDetails.aspx?EventID=" + newEvent.EventID);
// Response.Write("<script> Alert("+ EVENT_TRACKER + ");</script>");
}
protected void btnSubmitEvent_Click1(object sender, EventArgs e)
{
int hostID = Convert.ToInt32(Session["ID"].ToString());
//Creating Address
int AddressID = getAddressID();
int intEventID = 0;
EventServiceClient _eventClient = new EventServiceClient();
EventModel _event = new EventModel();
_event.HostID = hostID;
_event.Name = txtEventName.Text; //Event Name
_event.Category = txtCategory.Text;
if (chkBoxPrivate.Checked == true) //Public or Private Event
{
_event.Type = "Private";
}
else
{
_event.Type = "Public";
}
//Allowed to share?
//chkShare
if (chkShare.Checked == true)
{
//Share on Eventrix FB adn Twitter Page
}
_event.Desc = txtDesc.Value; //Event Description
string startdate = txtStart.Text;
string enddate = txtEnd.Text;
//Convert user input to DateTime format
DateTime sDate = DateTime.ParseExact(txtStart.Text, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture);
DateTime eDate = DateTime.ParseExact(txtEnd.Text, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture);
int result = DateTime.Compare(sDate, eDate);
int currentDate = DateTime.Compare(sDate, DateTime.Now);
string htmltag = "";
if (result > 0 || currentDate < 0)
{
htmltag = "<div class='alert alert-danger text-center' role='alert'>";
htmltag += "<button type = 'button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>";
htmltag += " <strong> Danger!</strong> Please Check Date!";
htmltag += "</div>";
status.InnerHtml = htmltag;
Response.Redirect("CreateEvent.aspx");
}
_event.Start_Date = sDate;
_event.sDate = Convert.ToString(sDate); //Event Start Date
_event.eDate = Convert.ToString(eDate); //Event End Date
_event.EventAddress = AddressID; //Event's address ID
//check ticket field
if (!txtE_Quantity.Text.Equals(""))
{
_event.EB_Quantity = Convert.ToInt32(txtE_Quantity.Text);
}
else
{
_event.EB_Quantity = 0;
}
if (!txtR_Quantity.Text.Equals(""))
{
_event.Reg_Quantity = Convert.ToInt32(txtR_Quantity.Text);
}
else
{
_event.Reg_Quantity = 0;
}
if (!txtV_Quantity.Text.Equals(""))
{
_event.VIP_Quantity = Convert.ToInt32(txtV_Quantity.Text);
}
else
{
_event.VIP_Quantity = 0;
}
if (!txtVV_Quantity.Text.Equals(""))
{
_event.VVIP_Quantity = Convert.ToInt32(txtVV_Quantity.Text);
}
else
{
_event.VVIP_Quantity = 0;
}
//Create Event
EventServiceClient _createEvent = new EventServiceClient();
string res = _createEvent.createEvent(_event);
bool isCreatedTicket = false; //Ticket Controller
if (res.ToLower().Contains("success")) //Event Created
{
EVENT_TRACKER = "Event Created successfully";
intEventID = _createEvent.findEventID(_event); //Get Event ID
string _strEventID = Convert.ToString(intEventID);
makeDirectory(_strEventID); //Create Event Directory
EVENT_TRACKER += "\n ID Exist";
//------------------------------Upload Guest, Staff and Product-----------------------//
string ImportSpreadsheet = "";
ImportSpreadsheet = ImportData(flGuest, intEventID, _event);
///-------------------------------------------------------------------------------------//
///
if (ImportSpreadsheet.Contains("success"))
{
EVENT_TRACKER += "\n Spreadsheet Uploaded";
//Create Tickets
isCreatedTicket = isLoadedTicket(_event, intEventID);
if (isCreatedTicket == true)
{
EVENT_TRACKER += "\n Ticket Created";
}
else
{
EVENT_TRACKER += "\n Failed to upload ticket";
}
}
else
{
//Unable to upload guest
EVENT_TRACKER += "\n failed to upload spreadsheet";
EVENT_TRACKER += "\n Spreadsheet Uploaded";
//Create Tickets
isCreatedTicket = isLoadedTicket(_event, intEventID);
if (isCreatedTicket == true)
{
EVENT_TRACKER += "\n Ticket Created";
}
else
{
EVENT_TRACKER += "\n Failed to upload ticket";
}
}
////Upload images
if (flEventImages.HasFile)
{
ImageFile mainPic = new ImageFile();
mainPic = UploadFile(flEventImages, _strEventID, SUBFOLDER); //Upload Event Main's Image to client directory
FileUploadClient fuc = new FileUploadClient();
string res1 = fuc.saveImage(mainPic); //Upload Event Main's Image to Database
string number = res1;
}
//Populate the modal popup-------------------------------
//EventModel _createdEvent = getDetails(_strEventID);
//MappingClient mc = new MappingClient();
//EventAddress _eventAddress = new EventAddress();
//_eventAddress = mc.getAddressById(Convert.ToString(AddressID));
//myModalLabel.InnerHtml = _createdEvent.Name;
//mdl_Image.InnerHtml = "<img class='img-responsive' src='" + _createdEvent.ImageLocation + "'/>";
//string htmltag = "";
//htmltag += "<p>" + _createdEvent.Desc + "</p>";
//htmltag += "<strong>Date: </strong> " + _createdEvent.sDate + " -" + _createdEvent.eDate;
//htmltag += "<br/>";
//htmltag += "<strong> Address: </strong><br/>";
//htmltag += _eventAddress.STREET + "<br/>";
//htmltag += _eventAddress.CITY + "<br/>";
//htmltag += _eventAddress.PROVINCE + "<br/>";
//htmltag += _eventAddress.COUNTRY + "<br/>";
//mld_Details.InnerHtml = htmltag;
//Session.Add("CurrentEventID", _strEventID);
//string strModalButton = "";
// strModalButton += "<a href='EventList.aspx?dl="+ _strEventID + "' runat='server' class='btn btn-default'>Cancel</a>";
// strModalButton += "<a href='EventDetails.aspx?EventID="+ _strEventID + "' runat='server' class='btn btn-default'>Conitnue</a>";
//btn_MDL.InnerHtml = strModalButton;
//cssMapModal.Visible = true;
Response.Redirect("EventDetails.aspx?ev=" + intEventID);
}
else
{
EVENT_TRACKER += "\n Event already exist";
Response.Redirect("CreateEvent.aspx");
}
// Response.Write("<script> Alert("+ EVENT_TRACKER + ");</script>");
}
