/// <summary> /// Fired when the event director triggers an event because it rolled the dice and hit it or it was forcefully /// triggered by some method under a defined condition. /// </summary> /// <param name="simEntity">The sim Entity.</param> /// <param name="directorEvent">The director Event.</param> private void Director_OnEventTriggered(IEntity simEntity, EventProduct directorEvent) { // Attached the random event state when we intercept an event it would like us to trigger. UserData.DirectorEvent = directorEvent; UserData.SourceEntity = simEntity; SetForm(typeof(EventExecutor)); }
public HttpResponseMessage UpdateEventProduct(EventProduct updateRecord) { try { ServicePointManager.Expect100Continue = true; ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 | SecurityProtocolType.Tls11; if (updateRecord == null) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } // Update the EventProduct record in the Azure SQL DB: int eventProductResult = _eventProductWorker.UpdateCreate(updateRecord); if (eventProductResult > 0) { return(new HttpResponseMessage(HttpStatusCode.OK)); } // Existed already: else if (eventProductResult == 0) { return(new HttpResponseMessage(HttpStatusCode.OK)); } return(new HttpResponseMessage(HttpStatusCode.OK)); } catch (Exception e) { return(new HttpResponseMessage(HttpStatusCode.BadRequest)); } }
private static void GenEventProduct(long productionID, short prevQuantity, RosieEvent rosieEvent) { EventProduct eventProduct = new EventProduct(); eventProduct.ProductionId = productionID; eventProduct.EventId = rosieEvent.Id; eventProduct.Quantity = (short)Faker.RandomNumber.Next(0, prevQuantity); eventProduct.Create(); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Edit(EventProduct model) { if (model == null) { return(false); } using (EventProductDAL dal = new EventProductDAL()) { CTMS_EVENTPRODUCT entitys = ModelToEntity(model); return(dal.Edit(entitys)); } }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(EventProduct model) { if (model == null) { return(string.Empty); } using (EventProductDAL dal = new EventProductDAL()) { CTMS_EVENTPRODUCT entity = ModelToEntity(model); entity.EVENTPRODUCTID = string.IsNullOrEmpty(model.EventProductId) ? Guid.NewGuid().ToString() : model.EventProductId; return(dal.Add(entity)); } }
internal static void UpdateProductsFromEventProduct(EventProduct eventProduct, PaymentContext context) { // get the list of all Products associated with this record var products = context.Product.Where(p => p.EventProductId == eventProduct.EventProductId && p.StateCode == 0).ToList(); // update their amount fields foreach (var curProduct in products) { curProduct.AmountNonreceiptable = eventProduct.AmountNonReceiptable ?? 0; curProduct.AmountReceipted = eventProduct.AmountReceipted ?? 0; curProduct.SyncDate = null; context.Update(curProduct); } context.SaveChanges(); }
public IHttpActionResult Get(string epid, string pid) { try { EventProductBLL epdBLL = new EventProductBLL(); EventProduct model = epdBLL.Get(p => p.EVENTPRODUCTID.Equals(epid) && p.PRODUCTID.Equals(pid)); model.IsAlreadyBuy = "1"; epdBLL.Edit(model); return(Ok("ok")); } catch (Exception ex) { LogService.WriteErrorLog("DoTreatmentController[Post]", ex.ToString()); return(BadRequest(ex.ToString())); } }
public string createProduct(EventProduct product) { try { using (EventrixDBDataContext dbd = new EventrixDBDataContext()) { int isAvail = (from eh in dbd.Products where eh.eventid.Equals(product.EventID) && eh.P_Name.Equals(product._Name) select eh).Count(); if (isAvail == 0) { Product _host = new Product() { P_Name = product._Name, P_Description = product._Desc, P_Quantity = product._Quantity, P_Price = product._Price, eventid = product.EventID, P_Quantity_Remaining = product._Quantity, }; dbd.Products.InsertOnSubmit(_host); dbd.SubmitChanges(); return("success"); } else //edit existing record { int _id = Convert.ToInt32(product._ID); Product pro = dbd.Products.Single(p => p.eventid == product.EventID && p.P_Name.Equals(product._Name)); Product _createNew = new Product(); pro.P_Name = product._Name; pro.P_Description = product._Desc; pro.P_Quantity = product._Quantity; pro.P_Price = product._Price; pro.P_Quantity_Remaining = product._Quantity; // pro.eventid = _product.EventID; // mde.Products.InsertOnSubmit(_createNew); dbd.SubmitChanges(); return("success"); } }; } catch (Exception) { return("fail"); } }
//EditProduct public bool EditProduct(EventProduct _product) { try { DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(EventProduct)); MemoryStream mem = new MemoryStream(); ser.WriteObject(mem, _product); string data = Encoding.UTF8.GetString(mem.ToArray(), 0, (int)mem.Length); WebClient webclient = new WebClient(); webclient.Headers["Content-type"] = "application/json"; webclient.Encoding = Encoding.UTF8; string res = webclient.UploadString(BASE_URL + "EditProduct", "PUT", data); return(true); } catch { return(false); } }
/// <summary> /// Model转Entity /// </summary> /// <param name="model"></param> /// <returns></returns> private CTMS_EVENTPRODUCT ModelToEntity(EventProduct model) { if (model != null) { var entity = new CTMS_EVENTPRODUCT() { EVENTPRODUCTID = model.EventProductId, EVENTID = model.EventId, PRODUCTID = model.ProductID, PRODUCTNAME = model.ProductName, PRODUCTPRICE = model.ProductPrice, PRODUCTDES = model.ProductDes, ISALREADYBUY = model.IsAlreadyBuy }; return(entity); } return(null); }
internal static List <EventPackage> GetEventPackagesFromEventProduct(EventProduct eventProduct, IPaymentContext context) { var eventPackages = new List <EventPackage>(); // get the list of all Products associated with this record var products = context.Product.Where(t => t.EventProductId == eventProduct.EventProductId && t.StateCode == 0).ToList(); // get Event Packages from the Products foreach (var curProduct in products) { if (curProduct.EventPackageId.HasValue) { var curEventPackages = context.EventPackage.Where(e => e.EventPackageId == curProduct.EventPackageId && e.StateCode == 0).Distinct().ToList(); eventPackages.AddRange(curEventPackages); } } return(eventPackages); }
/// <summary> /// Entity转Model /// </summary> /// <param name="entity"></param> /// <returns></returns> private EventProduct EntityToModel(CTMS_EVENTPRODUCT entity) { if (entity != null) { var model = new EventProduct() { EventProductId = entity.EVENTPRODUCTID, EventId = entity.EVENTID, ProductID = entity.PRODUCTID, ProductName = entity.PRODUCTNAME, ProductPrice = entity.PRODUCTPRICE, ProductDes = entity.PRODUCTDES, IsAlreadyBuy = entity.ISALREADYBUY }; return(model); } return(null); }
private void addNewSaleProduct() { SaleProduct newSaleProduct = new SaleProduct(); newSaleProduct.SaleId = SaleID; newSaleProduct.SaleQuantity = int.Parse(ndpQuanitity.Value.ToString()); newSaleProduct.SalePrice = Double.Parse(lblItemPrice.Text.Substring(1)); newSaleProduct.EventProductId = long.Parse(DBMethod.GetSelectedItemID(cmbProduct)); DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; newSaleProduct.Create(); // EventProduct eventProduct = new EventProduct(); conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; eventProduct.Id = long.Parse(DBMethod.GetSelectedItemID(cmbProduct)); eventProduct.UpdateQuantity(null, ndpQuanitity.Value.ToString()); }
private void cmbProduct_SelectedIndexChanged(object sender, EventArgs e) { try { DBConnector conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; EventProduct product = EventProduct.Retrieve(short.Parse(DBMethod.GetSelectedItemID(cmbProduct))); ndpQuanitity.Maximum = product.Quantity - product.SoldQuantity; // conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; Production production = Production.Retrieve(product.ProductionId); // conn = new DBConnector(Classes.DBMethod.GetConnectionString()); RosieEntity.Connector = conn; ProductItem productItem = ProductItem.Retrieve(production.ProductItemID); lblItemPrice.Text = productItem.Price.ToString("C"); ndpQuanitity.Value = 1; } catch (Exception ex) { } }
public void Get() { EventProduct eventProduct = DataRepository.EventProduct.Get(1, 1); Assert.AreEqual(10, eventProduct.DiscountRate); }
public bool SaveUserApply(UserApply model) { using (var context = new CRDatabase()) { //根据model的NextCurrentNode字段来判断是否有选择 //if (model.NextCurrentNode == "") //当为空的时候,默认就更新几个字段 //{ // var entity = context.CTMS_USERAPPLY.FirstOrDefault(p => p.APPLYID == oldApplyId); // entity.DOCTORSUGGEST = model.DOCTORSUGGEST; // return context.SaveChanges() > 0; //} //else //{ UserInfo currentUser = new UserInfoService().GetCurrentUser(); UserEventBLL ueBll = new UserEventBLL(); UserEvent ueModel = new UserEvent(); UserEvent oldEvent = ueBll.Get(p => p.EVENTID == model.EventId); //更新原先的待办信息 ueBll.CloseEvent(model.EventId); var entity = context.CTMS_USERAPPLY.FirstOrDefault(p => p.APPLYID == model.APPLYID); entity.STATUS = ((int)ActionStatus.Complete).ToString(); var addModel = new CTMS_USERAPPLY(); addModel.ID = Guid.NewGuid().ToString(); addModel.APPLYID = model.APPLYID; addModel.USERID = entity.USERID; addModel.GUIDELINEID = entity.GUIDELINEID; addModel.CURRENTNODE = model.NextCurrentNode; addModel.STATUS = ((int)ActionStatus.Progress).ToString(); addModel.DOCTORSUGGEST = model.DOCTORSUGGEST; addModel.ENTRYDATE = model.ENTRYDATE; addModel.EXITDATE = model.EXITDATE; addModel.ISDELETED = false; context.CTMS_USERAPPLY.Add(addModel); //发送待办任务 CancerUserInfoRepository _repository = new CancerUserInfoRepository(); HR_CNR_USER user = _repository.FindOne(p => p.USERID == entity.USERID); ueModel.EventID = Guid.NewGuid().ToString(); string userEventId = ueModel.EventID; ueModel.UserApplyId = addModel.ID; ueModel.ActionType = "1"; ueModel.ActionInfo = "您收到了Doc医生的建议,请查看";// + model.NextCurrentNodeName; ueModel.ReceiptTime = System.DateTime.Now; ueModel.ActionStatus = ((int)ActionStatus.Progress).ToString(); ueModel.FromUser = currentUser.UserId; ueModel.ToUser = entity.USERID; ueModel.CreateTime = System.DateTime.Now; ueModel.LinkUrl = "DoTreatmentView"; //用户待办界面 ueModel.ModelId = oldEvent.ModelId; ueBll.AddUserEvent(ueModel); #region 推荐产品与待办关联 string _guidID = model.NextCurrentNode == "" ? model.CURRENTNODE : model.NextCurrentNode; GuidelineProductBLL gpBLL = new GuidelineProductBLL(); IEnumerable <GuidelineProduct> products = gpBLL.GetList(p => p.GUIDELINEID.Equals(_guidID)); EventProductBLL epdBLL = new EventProductBLL(); foreach (GuidelineProduct item in products) { EventProduct eventProduct = new EventProduct(); eventProduct.EventId = ueModel.EventID; eventProduct.ProductID = item.ProductId; eventProduct.ProductName = item.ProductName; eventProduct.ProductPrice = item.ProductPrice; eventProduct.ProductDes = item.Productdes; eventProduct.IsAlreadyBuy = "0"; epdBLL.Add(eventProduct); } #endregion #region 发送客服待办 ueModel = new UserEvent(); ueModel.EventID = Guid.NewGuid().ToString(); ueModel.UserApplyId = addModel.ID; ueModel.ActionType = "1"; ueModel.ActionInfo = string.Format("{0}收到了{1}对于病例的处理建议,请跟踪", user.USERNAME, currentUser.LoginName); ueModel.ReceiptTime = System.DateTime.Now; ueModel.ActionStatus = ((int)ActionStatus.Progress).ToString(); ueModel.FromUser = currentUser.UserId; var toUserId = context.CTMS_SYS_USERINFO.FirstOrDefault(p => p.USERTYPE == (decimal)UserType.客服); ueModel.ToUser = toUserId.USERID; ueModel.CreateTime = System.DateTime.Now; ueModel.LinkUrl = "ServiceTask"; //客服待办 ueModel.Remarks = userEventId; ueModel.ModelId = oldEvent.ModelId; ueBll.AddUserEvent(ueModel); #endregion return(context.SaveChanges() > 0); //} } }
public async Task BankRunAppSelector(string selectedProcess, Guid?bankRunGUID, Guid?entityId, string entityName) { logger.LogInformation("----------Entering BankRunAppSelector()----------"); try { #region Bank Run Generate List // ----------Bank Run Generate List---------- if (selectedProcess.Equals("List")) { BankRun bankRunEntity = BankRunFileReport.GetBankRunEntityFromId(bankRunGUID, this.context); if (bankRunEntity == null) { logger.LogInformation("Exiting web job."); return; } // Assign the payment schedules to the bank run: BankRunGenerateList.GetPaymentSchedulesForBankRun(bankRunEntity, context, this.logger); // Now do the same for one off transactions (TODO in future sprint). try { // Update the Bankrun Status to "Report Available" (844060004): BankRun bankRunToUpdate = new BankRun(); bankRunToUpdate.BankRunId = bankRunEntity.BankRunId; bankRunToUpdate.BankRunStatus = 844060004; logger.LogInformation("Updating BankRun Status."); await this.xrmService.UpdateAsync(bankRunToUpdate); logger.LogInformation("Updated BankRun Status to \"Report Available\" successfully."); } catch (Exception ex) { logger.LogError("Could not Update Bank Run Status. Exception:" + ex.Message); } } #endregion #region Bank Run Generate File // ----------Bank Run Generate File---------- else if (selectedProcess.Equals("File")) { BankRun bankRunEntity = BankRunFileReport.GetBankRunEntityFromId(bankRunGUID, this.context); //Configuration configEntity = Common.GetConfigurationEntityFromId(configGuid, this.DataContext); PaymentProcessor paymentProcessorEntity = BankRunFileReport.GetPaymentProcessorEntityFromBankRun(bankRunEntity, this.context, this.logger); PaymentMethod paymentMethodEntity = BankRunFileReport.GetPaymentMethodEntityFromBankRun(bankRunEntity, this.context, this.logger); int?bankRunFileFormat = paymentProcessorEntity.BankRunFileFormat; logger.LogInformation("Requested Bank Run File Format:" + bankRunFileFormat); BankRunFileReport bankRunFileReport; switch (bankRunFileFormat) { case (int)BankRunFileFormat.ABA: bankRunFileReport = new AbaFileReport(bankRunEntity, paymentProcessorEntity, paymentMethodEntity, this.context, this.logger); break; case (int)BankRunFileFormat.BMO: bankRunFileReport = new BMOFileReport(bankRunEntity, paymentProcessorEntity, paymentMethodEntity, this.context, this.logger); break; case (int)BankRunFileFormat.ScotiaBank: bankRunFileReport = new ScotiaBankFileReport(bankRunEntity, paymentProcessorEntity, paymentMethodEntity, this.context, this.logger); break; case null: throw new Exception("No Bank Run File Format set on the Payment Processor with ID:" + paymentProcessorEntity.PaymentProcessorId); default: throw new Exception("Can't find Bank Run File Format for provided value:" + bankRunFileFormat); } await bankRunFileReport.GenerateFileReport(); await bankRunFileReport.SaveReport(); } #endregion #region Bank Run Generate Recurring Donation Records else if (selectedProcess.Equals("GenerateTransactions")) { BankRun bankRunEntity = BankRunFileReport.GetBankRunEntityFromId(bankRunGUID, this.context); BankRunRecurringDonations.GenerateBankRunRecurringDonations(bankRunEntity, this.context, this.logger); } #endregion #region Event Receipting else if (selectedProcess.Equals("EventReceipting") && entityId.HasValue) { List <EventPackage> eventPackages = new List <EventPackage>(); switch (entityName) { case EventReceipting.EventTicket: EventTicket eventTicket = EventReceipting.GetEventTicketFromId(entityId.Value, this.context); EventReceipting.UpdateTicketsFromEventTicket(eventTicket, this.context); eventPackages = EventReceipting.GetEventPackagesFromEventTicket(eventTicket, this.context); break; case EventReceipting.EventProduct: EventProduct eventProduct = EventReceipting.GetEventProductFromId(entityId.Value, this.context); EventReceipting.UpdateProductsFromEventProduct(eventProduct, this.context); eventPackages = EventReceipting.GetEventPackagesFromEventProduct(eventProduct, this.context); break; case EventReceipting.EventSponsorship: EventSponsorship eventSponsorship = EventReceipting.GetEventSponsorshipFromId(entityId.Value, this.context); EventReceipting.UpdateSponsorshipsFromEventSponsorship(eventSponsorship, this.context); eventPackages = EventReceipting.GetEventPackagesFromEventSponsorship(eventSponsorship, this.context); break; default: throw new Exception("Unknown Entity for Event Receipting: " + entityName + ". Exiting."); } EventReceipting.UpdateEventPackages(eventPackages, this.context); } #endregion } catch (Exception e) { logger.LogError("Error in BankRunAppSelector(): " + e.Message); if (e.InnerException != null) { logger.LogError("Inner exception: " + e.InnerException.ToString()); } } logger.LogInformation("----------Exiting BankRunAppSelector()----------"); logger.LogInformation("----------Exiting Web Job----------"); }
string ImportData(FileUpload flInfo, int EventID) { string path = ""; string response = ""; bool isValidGuestColumn = false; bool isValidStaffColumn = false; bool isValidProductColumn = false; int startColumn; int startRow; ExcelWorksheet GuestworkSheet; ExcelWorksheet StaffworkSheet; ExcelWorksheet ProductworkSheet; int count = 0; if (flInfo.HasFile) { try { string filename = Path.GetFileName(flInfo.FileName); string serverLocation = "~/Temp/" + "/" + filename; string SaveLoc = Server.MapPath(serverLocation); flInfo.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"; return(response); } //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 = 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); 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 = 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"; } //Directory.Delete(path, true); return(response); }
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>"); }
string ImportData(FileUpload flInfo, int EventID, EventModel _event) { string path = ""; string response = ""; bool isValidGuestColumn = false; bool isValidStaffColumn = false; bool isValidProductColumn = false; int startColumn; int startRow; ExcelWorksheet GuestworkSheet; ExcelWorksheet StaffworkSheet; ExcelWorksheet ProductworkSheet; int count = 0; if (flInfo.HasFile) { try { string filename = Path.GetFileName(flInfo.FileName); string serverLocation = "~/temp/" + "/" + filename; string SaveLoc = Server.MapPath(serverLocation); flInfo.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"; return(response); } //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 = EventID; //import db Eventrix_Client.Registration reg = new Eventrix_Client.Registration(); response = reg.RegisterStaff(_staff); if (response.Contains("successfully")) { count++; //====================-----------Send Email TO Staff-----------------=====================================// //=========================================================================================================// } 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; object Tyicket_Type = GuestworkSheet.Cells[startRow, startColumn + 3].Value; GuestModel _guest = new GuestModel(); _guest.NAME = Name.ToString(); _guest.SURNAME = Surname.ToString(); _guest.EMAIL = Email.ToString(); _guest.PASS = "******"; _guest.TYPE = Tyicket_Type.ToString(); Eventrix_Client.Registration reg = new Eventrix_Client.Registration(); int G_ID = reg.RegisterGuest(_guest); //Generate OTP string pass = genCode(Convert.ToString(G_ID)); //HashPass GuestModel gWithPass = new GuestModel(); gWithPass.PASS = pass; response = reg.InsertOTP(gWithPass, Convert.ToString(G_ID)); // response = reg.RegisterGuest(_guest); if (G_ID != -1) { count++; //====================-----------Send Invitation Email-----------------=====================================// EmailClient email = new EmailClient(); email.sendMsgInvite(_guest, _event, pass, EventID); //=========================================================================================================// } 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.ProdRemaining = Convert.ToInt32(Quantity.ToString()); _product._Price = Convert.ToInt32(Price.ToString()); _product.EventID = EventID; ProductServiceClient psv = new ProductServiceClient(); 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"; } return(response); }