protected void LoadItems() { if (!HasEditPermission) { dgAppUsers.Columns[dgAppUsers.Columns.Count - 1].Visible = false; } string searchName = "%" + txtSearchName.Text.Trim() + "%"; string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%"; DateTime from, to = new DateTime(); DateTime.TryParse(dpSearchCreateDateFrom.Value.ToString(), out from); DateTime.TryParse(dpSearchCreateDateTo.Value.ToString(), out to); dgAppUsers.VirtualItemCount = AppUserUI.GetAllAppUserUI(from, to, searchName, searchPhone).Count; if (dgAppUsers.VirtualItemCount == 0) { phHasItems.Visible = false; phHasNoItems.Visible = true; lblNoItems.Text = AppUsersStrings.GetText(@"MessageNoUsersFound"); } else { phHasItems.Visible = true; phHasNoItems.Visible = false; if (dgAppUsers.PageSize * dgAppUsers.CurrentPageIndex > dgAppUsers.VirtualItemCount) { dgAppUsers.CurrentPageIndex = 0; hfCurrentPageIndex_dgAppUsers.Value = dgAppUsers.CurrentPageIndex.ToString(); } List <AppUserUI> app_users = AppUserUI.GetAllAppUserUI(from, to, searchName, searchPhone, dgAppUsers.PageSize, dgAppUsers.CurrentPageIndex); BindList(app_users); } }
protected void btnDelete_Click(object sender, EventArgs e) { if (Page.IsValid) { //Delete AppUser Token try { new Query(AppUserAuthToken.TableSchema).Delete().Where(AppUserAuthToken.Columns.AppUserId, AppUserId).Execute(); new Query(AppUserAPNSToken.TableSchema).Delete().Where(AppUserAPNSToken.Columns.AppUserId, AppUserId).Execute(); new Query(AppUserGcmToken.TableSchema).Delete().Where(AppUserGcmToken.Columns.AppUserId, AppUserId).Execute(); Query.New <AppUser>().Where(AppUser.Columns.AppUserId, AppUserId) .Update(AppUser.Columns.IsDeleted, true) .Update(AppUser.Columns.UniqueIdString, null) .Update(AppUser.Columns.FacebookId, null) .Execute(); } catch { } Master.MessageCenter.DisplaySuccessMessage(AppUsersStrings.GetText(@"MessageAppUserDeleted")); lblDeleteConfirm.Visible = false; chkDeleteConfirm.Visible = false; btnDelete.Visible = false; } }
protected void Page_Init(object sender, EventArgs e) { HasEditPermission = Permissions.PermissionsForUser(SessionHelper.UserId()).Contains(Permissions.PermissionKeys.sys_perm); Master.AddButtonNew(AppUsersStrings.GetText(@"NewAppUserButton"), @"EditAppUser.aspx?New=yes", new string[] { Permissions.PermissionKeys.sys_perm }); dgAppUsers.PageIndexChanged += dgAppUsers_PageIndexChanging; }
protected void Page_PreRender(object sender, EventArgs e) { Master.PageTitle = AppUsersStrings.GetText(IsNewMode ? @"NewAppUserPageTitle" : @"EditAppUserPageTitle"); Master.ActiveMenu = IsNewMode ? "NewAppUser" : "AppUsers"; Master.AddClientScriptInclude(@"dgDatePicker.js"); //trCurrentPassword.Visible = !IsNewMode && AppUserId == SessionHelper.UserId(); rfvPasswordRequired.Visible = rfvPasswordRequired.Enabled = IsNewMode; rfvConfirmPasswordRequired.Visible = rfvConfirmPasswordRequired.Enabled = IsNewMode; }
protected void btnExport_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Email"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"FirstName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"LastName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"IsLocked"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Phone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Address"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"IsAdv"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"LastLogin"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"CreateDate"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"UserId"), typeof(string))); string searchName = "%" + txtSearchName.Text.Trim() + "%"; string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%"; DateTime from, to = new DateTime(); DateTime.TryParse(dpSearchCreateDateFrom.Value.ToString(), out from); DateTime.TryParse(dpSearchCreateDateTo.Value.ToString(), out to); List <AppUserUI> app_users = AppUserUI.GetAllAppUserUI(from, to, searchName, searchPhone); foreach (AppUserUI appUser in app_users) { System.Data.DataRow row = dt.NewRow(); row[0] = appUser.Email; row[1] = appUser.FirstName; row[2] = appUser.LastName; row[3] = GlobalStrings.GetYesNo(appUser.IsLocked); row[4] = "\"" + appUser.Phone + "\""; row[5] = appUser.Street + " " + appUser.HouseNum + "\n" + AppUsersStrings.GetText(@"Floor") + " " + appUser.Floor + "\n" + AppUsersStrings.GetText(@"ApartmentNumber") + " " + appUser.ApartmentNumber + "\n" + appUser.CityName; row[6] = GlobalStrings.GetYesNo(appUser.IsAdv); row[7] = "\"" + appUser.LastLogin + "\""; row[8] = "\"" + appUser.CreateDate + "\""; row[9] = "\"" + appUser.AppUserId + "\""; dt.Rows.Add(row); } SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true); Response.Clear(); Response.AddHeader(@"content-disposition", @"attachment;filename=AppUsersExport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension); Response.Charset = @"UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = ex.FileContentType; Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble()); Response.Write(ex.ToString()); Response.End(); }
protected void btnExportForCRM_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierId"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"BusinessName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierServices"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Address"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Email"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierType"), typeof(string))); List <SupplierUI> suppliers = new List <SupplierUI>(); string searchName = "%" + txtSearchName.Text.Trim() + "%"; string searchPhone = "%" + txtSearchPhone.Text.Trim() + "%"; suppliers = SupplierController.GetAllSuppliersUI(true, searchName, searchPhone); foreach (SupplierUI supplier in suppliers) { int i = 0; System.Data.DataRow row = dt.NewRow(); row[i++] = supplier.SupplierId; row[i++] = supplier.BusinessName; row[i++] = getSupplierServices(supplier); row[i++] = supplier.Street + " " + supplier.HouseNum; row[i++] = supplier.CityName; row[i++] = "=\"" + supplier.Phone + "\""; row[i++] = "=\"" + supplier.ContactPhone + "\""; row[i++] = supplier.ContactName; row[i++] = supplier.Email; row[i++] = supplier.IsProduct ? SuppliersStrings.GetText(@"IsProduct") : SuppliersStrings.GetText(@"IsService"); dt.Rows.Add(row); } System.Data.DataRow sumRow = dt.NewRow(); sumRow[0] = SuppliersStrings.GetText(@"SumSumPerMonth") + " " + suppliers.Sum(o => o.SumPerMonth); dt.Rows.Add(sumRow); SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true); Response.Clear(); Response.AddHeader(@"content-disposition", @"attachment;filename=SuppliersExportForCRM_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension); Response.Charset = @"UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = ex.FileContentType; Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble()); Response.Write(ex.ToString()); Response.End(); }
protected void btnImport_Click(object sender, EventArgs e) { if (CsvDataTable != null) { int count = 0; try { foreach (DataRow appUserRow in CsvDataTable.Rows) { if (appUserRow["Comments"].ToString() == "") { AppUser app_user = null; AppMembership.AppUserCreateResults results = AppMembership.CreateAppUser(appUserRow["Email"].ToString(), appUserRow["Password"].ToString(), @"", out app_user); if (results != AppMembership.AppUserCreateResults.Success) { throw new Exception(); } app_user.FirstName = appUserRow["FirstName"].ToString(); app_user.LastName = appUserRow["LastName"].ToString(); app_user.IsLocked = appUserRow["IsLocked"].ToString() == "0" ? false : true;; app_user.Phone = appUserRow["Phone"].ToString(); // app_user.OrderDisplay = OrderDisplay.GetLastOrder() + 1; app_user.Save(); count++; } } lblImportResult.Text = AppUsersStrings.GetText(@"MessageImportSuccess"); } catch { lblImportResult.Text = AppUsersStrings.GetText(@"MessageImportFailedUnknown"); } phImportResult.Visible = true; lblTotalImported.Text = count.ToString(); btnImport.Enabled = false; phErrors.Visible = false; phAppUsersList.Visible = false; } }
protected void btnAcceptFile_Click(object sender, EventArgs e) { if (fuImportFile.HasFile) { string[] allowedFileTypes = { "text/csv", "application/vnd.ms-excel" }; if (allowedFileTypes.Contains(fuImportFile.PostedFile.ContentType)) { string filename = Path.GetRandomFileName() + "_" + Path.GetFileName(fuImportFile.FileName); string filePath = Path.Combine(Settings.GetSetting(Settings.Keys.API_TEMP_UPLOAD_FOLDER), filename); string fullFilePath = filePath; if (!fullFilePath.Contains(@":/") && !fullFilePath.Contains(@":\")) { fullFilePath = Server.MapPath(filePath); } //Save that file in temp folder fuImportFile.SaveAs(fullFilePath); ReadCSVFile(fullFilePath); phErrors.Visible = true; phAppUsersList.Visible = true; phImportResult.Visible = false; } else { Master.MessageCenter.DisplayErrorMessage(AppUsersStrings.GetText(@"ImportFileWrongFormat")); return; } } else { lblErrors.Text = AppUsersStrings.GetText(@"MessageFileNotSelected"); phErrors.Visible = true; phAppUsersList.Visible = false; phImportResult.Visible = false; } }
protected void Page_PreRender(object sender, EventArgs e) { Master.PageTitleHtml = string.Format(AppUsersStrings.GetText(@"DeleteAppUserPageTitle"), AppUserName); Master.ActiveMenu = "AppUsers"; }
private void ReadCSVFile(string filePath) { using (FileStream fs = new FileStream(filePath, FileMode.Open)) { using (CsvReader csv = new CsvReader(fs)) { string[] _values = null; CsvDataTable = new DataTable(); CsvDataTable.Columns.Add(new DataColumn("Line", typeof(int))); CsvDataTable.Columns.Add(new DataColumn("Email", typeof(string))); CsvDataTable.Columns.Add(new DataColumn("Password", typeof(string))); CsvDataTable.Columns.Add(new DataColumn("FirstName", typeof(string))); CsvDataTable.Columns.Add(new DataColumn("LastName", typeof(string))); CsvDataTable.Columns.Add(new DataColumn("IsLocked", typeof(string))); CsvDataTable.Columns.Add(new DataColumn("Phone", typeof(string))); CsvDataTable.Columns.Add(new DataColumn("Comments", typeof(string))); bool bErrors = false; int line = -1; int numAppUsersToImport = 0; _values = csv.ReadRow(); while (_values != null) { if (++line == 0) { _values = csv.ReadRow(); continue; } DataRow DR = CsvDataTable.NewRow(); string comments = ""; try { DR["Line"] = line; DR["Email"] = _values[0] == "" ? "" : _values[0].Trim(); DR["Password"] = _values[1] == "" ? "" : _values[1].Trim(); DR["FirstName"] = _values[2] == "" ? "" : _values[2].Trim(); DR["LastName"] = _values[3] == "" ? "" : _values[3].Trim(); DR["IsLocked"] = _values[4] == "" ? "" : _values[4].Trim(); DR["Phone"] = _values[5] == "" ? "" : _values[5].Trim('"'); //Email must be unique if (core.DAL.AppUser.FetchByEmail(DR["Email"].ToString()) != null) { if (comments != "") { comments += "<br />"; } comments += AppUsersStrings.GetText(@"MessageEmailAlreadyExists"); } } catch (Exception e) { if (comments != "") { comments += "<br />"; } comments += AppUsersStrings.GetText(@"MessageLineParsingError") + ": " + e.Message; } if (comments != "") { bErrors = true; comments += "<br />" + AppUsersStrings.GetText(@"MessageAppUsersWillNotImported"); } else { numAppUsersToImport++; } DR["Comments"] = comments; CsvDataTable.Rows.Add(DR); _values = csv.ReadRow(); } if (bErrors) { lblErrors.Text = AppUsersStrings.GetText(@"ImportErrorsLabel");; } else { lblErrors.Text = AppUsersStrings.GetText(@"ImportNoErrorsLabel");; } dgAppUsers.DataSource = CsvDataTable; dgAppUsers.DataBind(); lblTotal.Text = CsvDataTable.Rows.Count.ToString(); lblTotalToImport.Text = numAppUsersToImport.ToString(); btnImport.Enabled = numAppUsersToImport == 0 ? false : true; } } }
protected void Page_PreRender(object sender, EventArgs e) { Master.PageTitleHtml = AppUsersStrings.GetText(@"ImportAppUsersPageTitle"); Master.ActiveMenu = "ImportAppUsers"; }
protected void btnSave_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } string SupplierEmail = null; bool EmailChanged = false; AppSupplier supplier = null; if (IsNewMode) { Membership.UserCreateResults results = Membership.CreateSupplier(txtEmail.Text, txtPassword.Text.Trim(), Convert.ToInt64(ddlCity.SelectedValue), out supplier); switch (results) { default: case Membership.UserCreateResults.UnknownError: Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedUnknown")); return; case Membership.UserCreateResults.AlreadyExists: Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedAlreadyExists")); return; case Membership.UserCreateResults.InvalidEmailAddress: Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedEmailAddressInvalid")); return; case Membership.UserCreateResults.Success: break; } SupplierId = supplier.SupplierId; SupplierEmail = supplier.Email; //supplier.OrderDisplay = OrderDisplay.GetLastOrder() + 1; } else { supplier = core.DAL.AppSupplier.FetchByID(SupplierId); SupplierEmail = supplier.Email; } supplier.BusinessName = txtBusinessName.Text; if (ddlIsProduct.SelectedValue == "prod") { supplier.IsProduct = true; supplier.IsService = false; } else { supplier.IsProduct = false; supplier.IsService = true; } //supplier.IsProduct = chkIsProduct.Checked; //supplier.IsService = chkIsService.Checked; supplier.IsPremium = chkIsPremium.Checked; supplier.IsLocked = chkIsLocked.Checked; supplier.ContactName = txtContactName.Text; supplier.ContactPhone = txtContactPhone.Text; supplier.Phone = txtPhone.Text; supplier.CityId = Convert.ToInt64(ddlCity.SelectedValue); supplier.Street = txtStreet.Text; supplier.HouseNum = txtHouseNum.Text; try { string city = ddlCity.SelectedItem.Text; //var address = (city != "" ? city + " " : "") +" "+ (txtStreet.Text != "" ? txtStreet.Text+" " : "") + (txtHouseNum.Text != "" ? txtHouseNum.Text : ""); var locationService = new GoogleLocationService(); var point = (city.Trim() != "" ? locationService.GetLatLongFromAddress(city) : new MapPoint()); supplier.AddressLocation = new Geometry.Point(point.Latitude, point.Longitude); } catch (Exception) { supplier.AddressLocation = new Geometry.Point(0, 0); } supplier.HouseNum = txtHouseNum.Text; supplier.Precent = txtPrecent.Text != "" ?Convert.ToInt32(txtPrecent.Text):0; supplier.SumPerMonth = txtSumPerMonth.Text != "" ? Convert.ToInt32(txtSumPerMonth.Text) : 0; //supplier.StatusJoinBid = chkIsStatusJoinBid.Checked; //supplier.AllowChangeStatusJoinBid = chkAllowChangeStatusJoinBid.Checked; //supplier.MaxWinningsNum =txtMaxWinningsNum.Text != "" ? Convert.ToInt32(txtMaxWinningsNum.Text) : 0; supplier.MastercardCode = txtMastercardCode.Text; supplier.Save(); if (IsNewMode) { SupplierId = supplier.SupplierId; //if (chkIsStatusJoinBid.Checked == false)//handel //{ // (new Query(SupplierProduct.TableSchema).Where(SupplierProduct.Columns.SupplierId, SupplierId).Delete()).Execute(); // ProductCollection pcol = ProductCollection.FetchByQuery(new Query(Product.TableSchema).Where(Product.Columns.IsDeleted, false)); // foreach (Product item in pcol) // { // SupplierProduct sp = new SupplierProduct(); // sp.SupplierId = SupplierId; // sp.ProductId = item.ProductId; // sp.Gift = ""; // sp.Save(); // } //} } //if (chkIsService.Checked) if (ddlIsProduct.SelectedValue != "prod") { foreach (ListItem item in ddlServices.Items) { if (item.Selected) { SupplierService supplierService = SupplierService.FetchByID(Convert.ToInt64(item.Value), SupplierId); if (supplierService == null) { supplierService = new SupplierService(); supplierService.SupplierId = SupplierId; supplierService.ServiceId = Convert.ToInt64(item.Value); supplierService.Save(); } } else { SupplierService.Delete(Convert.ToInt64(item.Value), SupplierId); } } } else { SupplierController.DeleteAllSupplierServices(SupplierId); } if (supplier.Email != txtEmail.Text.Trim().NormalizeEmail()) { if (AppSupplier.FetchByEmail(txtEmail.Text.Trim().NormalizeEmail()) != null) { Master.MessageCenter.DisplayWarningMessage(AppUsersStrings.GetText(@"MessageEmailChangeFailed")); } else { supplier.Email = txtEmail.Text.Trim().NormalizeEmail(); supplier.UniqueIdString = supplier.Email;//email.NormalizeEmail(); SupplierEmail = supplier.Email; EmailChanged = true; } } SupplierEmail = supplier.Email; supplier.Save(); if (txtPassword.Text.Length > 0) { if (txtConfirmPassword.Text != txtPassword.Text) { Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"SupplierNewPasswordConfirmInvalid")); return; } Membership.UserPasswordChangeResults results; results = Membership.ChangeSupplierPassword(supplier.Email, txtPassword.Text); switch (results) { default: Master.MessageCenter.DisplayWarningMessage(SuppliersStrings.GetText(@"MessagePasswordChangeFailedUnknown")); break; case Membership.UserPasswordChangeResults.PasswordDoNotMatch: Master.MessageCenter.DisplayWarningMessage(SuppliersStrings.GetText(@"MessagePasswordChangeBadOldPassword")); break; case Membership.UserPasswordChangeResults.Success: break; } } if (IsNewMode) { string successMessage = SuppliersStrings.GetText(@"MessageSupplierCreated"); string url = @"EditSupplier.aspx?Email=" + SupplierEmail + "&SupplierId=" + supplier.SupplierId; url += @"&message-success=" + Server.UrlEncode(successMessage); Response.Redirect(url, true); } else { string successMessage = SuppliersStrings.GetText(@"MessageSupplierSaved"); if (EmailChanged) { string url = @"EditSupplier.aspx?message-success=" + Server.UrlEncode(successMessage) + "&SupplierId=" + supplier.SupplierId; if (SupplierId != supplier.SupplierId) { url += @"&Email=" + SupplierEmail; } Response.Redirect(url, true); } else { Master.MessageCenter.DisplaySuccessMessage(successMessage); LoadView(); } } }
protected void Page_PreRender(object sender, EventArgs e) { Master.PageTitle = AppUsersStrings.GetText(@"AppUsersPageTitle"); Master.ActiveMenu = "AppUsers"; Master.AddClientScriptInclude(@"dgDateManager.js"); }
protected void btnExportForCRM_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"CustomerId"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"FirstName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"LastName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Email"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"Phone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"Address"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"CityName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(AppUsersStrings.GetText(@"CreateDate"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"BidId"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"Products"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"Price"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(BidString.GetText(@"OrderDate"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(OrdersStrings.GetText(@"ActionType"), typeof(string))); DateTime from = new DateTime(), to = new DateTime(); DateTime.TryParse(dpSearchCreateDateFrom.Value.ToString(), out from); DateTime.TryParse(dpSearchCreateDateTo.Value.ToString(), out to); Int64 _BidId = -1; if (txtBidNumber.Text != "") { Int64.TryParse(txtBidNumber.Text, out _BidId); } List <BidUI> app_users = BidController.GetAllBids(filterSearch, from, to, txtSearchPhone.Text, txtCustomerId.Text, _BidId, txtCityName.Text); foreach (BidUI Bid in app_users) { int i = 0; System.Data.DataRow row = dt.NewRow(); var appUser = AppUser.FetchByID(Bid.CustomerId); row[i++] = Bid.CustomerId; row[i++] = Bid.CustomerType == CustomerType.Temp ? BidString.GetText("Temp") : appUser.FirstName; row[i++] = Bid.CustomerType == CustomerType.Temp ? BidString.GetText("Temp") : appUser.LastName; row[i++] = Bid.CustomerType == CustomerType.Temp ? BidString.GetText("Temp") : appUser.Email; row[i++] = Bid.CustomerType == CustomerType.Temp ? BidString.GetText("Temp") : "=\"" + appUser.Phone + "\""; row[i++] = Bid.CustomerType == CustomerType.Temp ? BidString.GetText("Temp") : appUser.Street + " " + appUser.HouseNum; row[i++] = Bid.City; row[i++] = Bid.CustomerType == CustomerType.Temp ? BidString.GetText("Temp") : appUser.CreateDate.ToString(); row[i++] = Bid.BidId; row[i++] = Bid.Products; row[i++] = Bid.Price; row[i++] = Bid.OrderDate; row[i++] = "רכישה"; dt.Rows.Add(row); } SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true); Response.Clear(); Response.AddHeader(@"content-disposition", @"attachment;filename=BidsExportForCRM_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension); Response.Charset = @"UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = ex.FileContentType; Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble()); Response.Write(ex.ToString()); Response.End(); }
protected void btnSave_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } string Email = null; bool EmailChanged = false; string AdCompanyEmail = null; AdCompany company = null; if (IsNewMode) { Membership.UserCreateResults results = Membership.CreateAdCompany(txtEmail.Text, out company); switch (results) { default: case Membership.UserCreateResults.UnknownError: Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedUnknown")); return; case Membership.UserCreateResults.AlreadyExists: Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedAlreadyExists")); return; case Membership.UserCreateResults.InvalidEmailAddress: Master.MessageCenter.DisplayErrorMessage(SuppliersStrings.GetText(@"MessageCreateFailedEmailAddressInvalid")); return; case Membership.UserCreateResults.Success: break; } CompanyId = company.CompanyId; company.CreatedDate = DateTime.Now; AdCompanyEmail = company.Email; } else { company = AdCompany.FetchByID(CompanyId); AdCompanyEmail = company.Email; } company.BusinessName = txtBusinessName.Text; company.ContactName = txtContactName.Text; company.ContactPhone = txtContactPhone.Text; company.Phone = txtPhone.Text; company.Description = txtDescription.Text; company.Save(); if (IsNewMode) { CompanyId = company.CompanyId; } if (company.Email != txtEmail.Text.Trim().NormalizeEmail()) { if (AdCompany.FetchByEmail(txtEmail.Text.Trim().NormalizeEmail()) != null) { Master.MessageCenter.DisplayWarningMessage(AppUsersStrings.GetText(@"MessageEmailChangeFailed")); } else { company.Email = txtEmail.Text.Trim().NormalizeEmail(); EmailChanged = true; } } AdCompanyEmail = company.Email; company.Save(); if (IsNewMode) { string successMessage = AdvertisementsStrings.GetText(@"MessageCompanyCreated"); string url = @"EditAdCompany.aspx?Email=" + AdCompanyEmail + "&CompanyId=" + company.CompanyId; url += @"&message-success=" + Server.UrlEncode(successMessage); Response.Redirect(url, true); } else { string successMessage = SuppliersStrings.GetText(@"MessageSupplierSaved"); if (EmailChanged) { string url = @"EditAdCompany.aspx?message-success=" + Server.UrlEncode(successMessage) + "&CompanyId=" + company.CompanyId; if (CompanyId != company.CompanyId) { url += @"&Email=" + AdCompanyEmail; } Response.Redirect(url, true); } else { Master.MessageCenter.DisplaySuccessMessage(successMessage); LoadView(); } } }
protected void Page_Init(object sender, EventArgs e) { Master.AddButtonNew(AppUsersStrings.GetText(@"NewAppUserButton"), @"EditAppUser.aspx?New=yes", new string[] { Permissions.PermissionKeys.sys_perm }); }
protected void btnSave_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } string AppUserEmail = null; bool EmailChanged = false; AppUser app_user = null; if (IsNewMode) { AppMembership.AppUserCreateResults results = AppMembership.CreateAppUser(txtEmail.Text, txtPassword.Text.Trim(), @"", out app_user); switch (results) { default: case AppMembership.AppUserCreateResults.UnknownError: Master.MessageCenter.DisplayErrorMessage(AppUsersStrings.GetText(@"MessageCreateFailedUnknown")); return; case AppMembership.AppUserCreateResults.AlreadyExists: Master.MessageCenter.DisplayErrorMessage(AppUsersStrings.GetText(@"MessageCreateFailedAlreadyExists")); return; case AppMembership.AppUserCreateResults.InvalidEmailAddress: Master.MessageCenter.DisplayErrorMessage(AppUsersStrings.GetText(@"MessageCreateFailedEmailAddressInvalid")); return; case AppMembership.AppUserCreateResults.Success: break; } AppUserId = app_user.AppUserId; AppUserEmail = app_user.Email; //app_user.OrderDisplay = OrderDisplay.GetLastOrder() + 1; } else { app_user = core.DAL.AppUser.FetchByID(AppUserId); AppUserEmail = app_user.Email; } app_user.CityId = Convert.ToInt64(ddlCity.SelectedValue); app_user.IsLocked = chkIsLocked.Checked; app_user.FirstName = txtFirstName.Text; app_user.LastName = txtlastName.Text; app_user.Phone = txtPhone.Text; app_user.Street = txtStreet.Text; app_user.CityId = Int64.Parse(ddlCity.SelectedValue); app_user.ApartmentNumber = txtAptNum.Text; app_user.HouseNum = txtHouseNum.Text; app_user.Floor = txtFloor.Text; try { string city = ddlCity.SelectedItem.Text; //var address = (city != "" ? city + " " : "") + " " + (txtStreet.Text != "" ? txtStreet.Text + " " : "") + (txtHouseNum.Text != "" ? txtHouseNum.Text : ""); var locationService = new GoogleLocationService(); var point = (city.Trim() != "" ? locationService.GetLatLongFromAddress(city) : new MapPoint()); app_user.AddressLocation = new Geometry.Point(point.Latitude, point.Longitude); } catch { Master.MessageCenter.DisplayErrorMessage(AppUsersStrings.GetText(@"MessageAddressInvalid")); return; } app_user.Save(); if (IsNewMode) { AppUserId = app_user.AppUserId; } if (app_user.Email != txtEmail.Text.Trim().NormalizeEmail()) { if (AppUser.FetchByEmail(txtEmail.Text.Trim().NormalizeEmail()) != null) { Master.MessageCenter.DisplayWarningMessage(AppUsersStrings.GetText(@"MessageEmailChangeFailed")); } else { app_user.Email = txtEmail.Text.Trim().NormalizeEmail(); app_user.UniqueIdString = app_user.Email; AppUserEmail = app_user.Email; EmailChanged = true; } } AppUserEmail = app_user.Email; app_user.Save(); if (txtPassword.Text.Length > 0) { AppMembership.AppUserPasswordChangeResults results; //if (AppUserId == SessionHelper.UserId()) //{ // results = AppMembership.ChangeAppUserPassword(app_user.Email, txtCurrentPassword.Text, txtPassword.Text); //} //else //{ results = AppMembership.ChangeAppUserPassword(app_user.Email, txtPassword.Text); //} switch (results) { default: Master.MessageCenter.DisplayWarningMessage(AppUsersStrings.GetText(@"MessagePasswordChangeFailedUnknown")); break; case AppMembership.AppUserPasswordChangeResults.PasswordDoNotMatch: Master.MessageCenter.DisplayWarningMessage(AppUsersStrings.GetText(@"MessagePasswordChangeBadOldPassword")); break; case AppMembership.AppUserPasswordChangeResults.Success: break; } } if (IsNewMode) { string successMessage = AppUsersStrings.GetText(@"MessageAppUserCreated"); string url = @"EditAppUser.aspx?Email=" + AppUserEmail; url += @"&message-success=" + Server.UrlEncode(successMessage); Response.Redirect(url, true); } else { string successMessage = AppUsersStrings.GetText(@"MessageAppUserSaved"); if (EmailChanged) { string url = @"EditAppUser.aspx?message-success=" + Server.UrlEncode(successMessage); if (AppUserId != SessionHelper.UserId()) { url += @"&Email=" + AppUserEmail; } Response.Redirect(url, true); } else { Master.MessageCenter.DisplaySuccessMessage(successMessage); LoadView(); } } }