/// <summary> /// Delete selected user (delete button) in controls /// </summary> /// <param name="source"></param> /// <param name="e"></param> protected void RadGrid1_DeleteCommand(object source, GridCommandEventArgs e) { string PotentialUserId = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["PotentialUserId"].ToString(); potentialUserComponent = new PotentialUserComponent(new Guid(PotentialUserId)); potentialUserComponent.PotentialUser.Deleted = true; potentialUserComponent.Save(); DataBind(); }
/// <summary> /// Upload Excel file /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void aUploadFile_FileUploaded(object sender, Telerik.Web.UI.FileUploadedEventArgs e) { try { int counter = 0; int counterSuccess = 0; int counterRepeat = 0; if (aUploadFile.UploadedFiles.Count > 0) { string FileName = Path.GetFileName(aUploadFile.UploadedFiles[0].FileName); string extensionName = Path.GetExtension(aUploadFile.UploadedFiles[0].FileName); FileName = Guid.NewGuid().ToString(); aUploadFile.UploadedFiles[0].SaveAs( Server.MapPath(PortalSettings.HomeDirectory + "tmpfiles/" + FileName + extensionName)); string connString = ""; string strFileType = extensionName.ToLower(); string path = Server.MapPath(PortalSettings.HomeDirectory + "tmpfiles/" + FileName + extensionName); //Connection String to Excel Workbook if (strFileType.Trim() == ".xls") { connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (strFileType.Trim() == ".xlsx") { connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; } string query = "SELECT * FROM [Sheet1$]"; OleDbConnection conn = new OleDbConnection(connString); if (conn.State == ConnectionState.Closed) { conn.Open(); } OleDbCommand cmd = new OleDbCommand(query, conn); OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); // List<PotentialUser> potentialUsers=new List<PotentialUser>(); PotentialUserComponent tmpPotentialUser; long batch = DateTime.Now.Ticks; foreach (DataRow dr in ds.Tables[0].Rows) { counter++; if (ds.Tables[0].Columns.Contains("Email")) { if (!string.IsNullOrEmpty(dr["Email"].ToString().Replace(" ", ""))) { tmpPotentialUser = new PotentialUserComponent(dr["Email"].ToString().Replace(" ", "")); if (tmpPotentialUser.PotentialUser.PotentialUserId == Guid.Empty) { tmpPotentialUser.PotentialUser.Created = DateTime.Now; tmpPotentialUser.PotentialUser.Updated = tmpPotentialUser.PotentialUser.Created; tmpPotentialUser.PotentialUser.Deleted = false; } tmpPotentialUser.PotentialUser.Updated = DateTime.Now; tmpPotentialUser.PotentialUser.Batch = batch.ToString(); if (ds.Tables[0].Columns.Contains("FirstName")) { tmpPotentialUser.PotentialUser.FirstName = dr["FirstName"].ToString(); } if (ds.Tables[0].Columns.Contains("LastName")) { tmpPotentialUser.PotentialUser.LastName = dr["LastName"].ToString(); } if (ds.Tables[0].Columns.Contains("MiddleName")) { tmpPotentialUser.PotentialUser.MiddleName = dr["MiddleName"].ToString(); } if (ds.Tables[0].Columns.Contains("Phone")) { tmpPotentialUser.PotentialUser.Phone = dr["Phone"].ToString(); } if (ds.Tables[0].Columns.Contains("Address")) { tmpPotentialUser.PotentialUser.Address = dr["Address"].ToString(); } if (ds.Tables[0].Columns.Contains("Country")) { tmpPotentialUser.PotentialUser.Country = dr["Country"].ToString(); } if (ds.Tables[0].Columns.Contains("Region")) { tmpPotentialUser.PotentialUser.Region = dr["Region"].ToString(); } if (ds.Tables[0].Columns.Contains("City")) { tmpPotentialUser.PotentialUser.City = dr["City"].ToString(); } if (ds.Tables[0].Columns.Contains("Language")) { tmpPotentialUser.PotentialUser.Language = dr["Language"].ToString(); } if (ds.Tables[0].Columns.Contains("OrganizationName")) { tmpPotentialUser.PotentialUser.OrganizationName = dr["OrganizationName"].ToString(); } if (ds.Tables[0].Columns.Contains("OrganizationType")) { tmpPotentialUser.PotentialUser.OrganizationType = dr["OrganizationType"].ToString(); } if (ds.Tables[0].Columns.Contains("Qualification")) { tmpPotentialUser.PotentialUser.Qualification = dr["Qualification"].ToString(); } if (ds.Tables[0].Columns.Contains("Source")) { tmpPotentialUser.PotentialUser.Source = dr["Source"].ToString(); } if (ds.Tables[0].Columns.Contains("Source")) { tmpPotentialUser.PotentialUser.Source = dr["Source"].ToString(); } try { if (ds.Tables[0].Columns.Contains("Latitude")) { tmpPotentialUser.PotentialUser.Latitude = Convert.ToDecimal(dr["Latitude"]); } if (ds.Tables[0].Columns.Contains("Longitude")) { tmpPotentialUser.PotentialUser.Longitude = Convert.ToDecimal(dr["Longitude"]); } } catch (Exception) { } if (ds.Tables[0].Columns.Contains("CustomField1")) { tmpPotentialUser.PotentialUser.CustomField1 = dr["CustomField1"].ToString(); } if (ds.Tables[0].Columns.Contains("CustomField2")) { tmpPotentialUser.PotentialUser.CustomField2 = dr["CustomField2"].ToString(); } if (ds.Tables[0].Columns.Contains("Title")) { tmpPotentialUser.PotentialUser.Title = dr["Title"].ToString(); } if (ds.Tables[0].Columns.Contains("ZipCode")) { tmpPotentialUser.PotentialUser.ZipCode = dr["ZipCode"].ToString(); } if (ds.Tables[0].Columns.Contains("WebSite")) { tmpPotentialUser.PotentialUser.WebSite = dr["WebSite"].ToString(); } if (ds.Tables[0].Columns.Contains("LinkedIn")) { tmpPotentialUser.PotentialUser.LinkedIn = dr["LinkedIn"].ToString(); } if (ds.Tables[0].Columns.Contains("GooglePlus")) { tmpPotentialUser.PotentialUser.GooglePlus = dr["GooglePlus"].ToString(); } if (ds.Tables[0].Columns.Contains("Twitter")) { tmpPotentialUser.PotentialUser.Twitter = dr["Twitter"].ToString(); } if (ds.Tables[0].Columns.Contains("Facebook")) { tmpPotentialUser.PotentialUser.Facebook = dr["Facebook"].ToString(); } if (ds.Tables[0].Columns.Contains("Skype")) { tmpPotentialUser.PotentialUser.Skype = dr["Skype"].ToString(); } if (ds.Tables[0].Columns.Contains("Sector")) { tmpPotentialUser.PotentialUser.Sector = dr["Sector"].ToString(); } if (tmpPotentialUser.PotentialUser.PotentialUserId != Guid.Empty) { counterRepeat++; if (chkUpdate.Checked) { counterSuccess += tmpPotentialUser.Save(); } } else { counterSuccess += tmpPotentialUser.Save(); } } } } MIFNEXSOEntities nx = new MIFNEXSOEntities(); grdPreUsers.DataSource = nx.PotentialUsers; grdPreUsers.DataBind(); da.Dispose(); conn.Close(); conn.Dispose(); } lblResult.Text = String.Format("Uploading contact done Succesfutl ({0}), Repeats ({1}) Errors ({2})", counterSuccess, counterRepeat, counter); } catch (Exception ee) { lblResult.Text = "Exception: " + ee.ToString(); } }
/// <summary> /// Update information of the Potential user /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == RadGrid.UpdateCommandName) { if (e.Item is GridEditableItem) { GridEditableItem editItem = (GridEditableItem)e.Item; RadTextBox txtEmail = (RadTextBox)editItem.FindControl("txtEmail"); if (txtEmail.Text != string.Empty) { //get information from the controls TextBox txtPotentialUserId = (TextBox)editItem.FindControl("txtPotentialUserId"); RadTextBox txtFirstName = (RadTextBox)editItem.FindControl("txtFirstName"); RadTextBox txtLastName = (RadTextBox)editItem.FindControl("txtLastName"); RadTextBox txtOrganizationName = (RadTextBox)editItem.FindControl("txtOrganizationName"); RadTextBox txtPhone = (RadTextBox)editItem.FindControl("txtPhone"); RadTextBox txtAddress = (RadTextBox)editItem.FindControl("txtAddress"); RadTextBox txtMiddleName = (RadTextBox)editItem.FindControl("txtMiddleName"); RadTextBox txtQualification = (RadTextBox)editItem.FindControl("txtQualification"); RadTextBox txtSource = (RadTextBox)editItem.FindControl("txtSource"); RadTextBox txtSector = (RadTextBox)editItem.FindControl("txtSector"); RadTextBox txtBatch = (RadTextBox)editItem.FindControl("txtBatch"); RadTextBox txtTitle = (RadTextBox)editItem.FindControl("txtTitle"); RadTextBox txtZipCode = (RadTextBox)editItem.FindControl("txtZipCode"); RadTextBox txtWebSite = (RadTextBox)editItem.FindControl("txtWebSite"); RadTextBox txtLinkedIn = (RadTextBox)editItem.FindControl("txtLinkedIn"); RadTextBox txtGooglePlus = (RadTextBox)editItem.FindControl("txtGooglePlus"); RadTextBox txtTwitter = (RadTextBox)editItem.FindControl("txtTwitter"); RadTextBox txtFacebook = (RadTextBox)editItem.FindControl("txtFacebook"); RadTextBox txtSkype = (RadTextBox)editItem.FindControl("txtSkype"); RadComboBox ddLanguage = (RadComboBox)editItem.FindControl("ddLanguage"); RadComboBox ddOrganizationType = (RadComboBox)editItem.FindControl("ddOrganizationType"); RadTextBox txtNewOrganizationType = (RadTextBox)editItem.FindControl("txtNewOrganizationType"); RadComboBox ddCountry = (RadComboBox)editItem.FindControl("ddCountry"); bool sw = false; potentialUserComponent = new PotentialUserComponent(txtEmail.Text); //If is new potential user if (potentialUserComponent.PotentialUser.PotentialUserId == Guid.Empty) { potentialUserComponent.PotentialUser.Created = DateTime.Now; potentialUserComponent.PotentialUser.Updated = potentialUserComponent.PotentialUser.Created; sw = true; ExistEmail = false; } else { if (txtPotentialUserId.Text != string.Empty) { if (potentialUserComponent.PotentialUser.PotentialUserId == (new Guid(txtPotentialUserId.Text))) { //update Date potentialUserComponent.PotentialUser.Updated = DateTime.Now; sw = true; ExistEmail = false; } else { ExistEmail = true; } } else { ExistEmail = true; } } //Update information for the existing user if (sw == true) { potentialUserComponent.PotentialUser.Email = txtEmail.Text; potentialUserComponent.PotentialUser.FirstName = txtFirstName.Text; potentialUserComponent.PotentialUser.LastName = txtLastName.Text; potentialUserComponent.PotentialUser.OrganizationName = txtOrganizationName.Text; potentialUserComponent.PotentialUser.Phone = txtPhone.Text; potentialUserComponent.PotentialUser.Address = txtAddress.Text; potentialUserComponent.PotentialUser.MiddleName = txtMiddleName.Text; potentialUserComponent.PotentialUser.Qualification = txtQualification.Text; potentialUserComponent.PotentialUser.Source = txtSource.Text; potentialUserComponent.PotentialUser.Sector = txtSector.Text; potentialUserComponent.PotentialUser.Batch = txtBatch.Text; potentialUserComponent.PotentialUser.Title = txtTitle.Text; potentialUserComponent.PotentialUser.ZipCode = txtZipCode.Text; potentialUserComponent.PotentialUser.WebSite = txtWebSite.Text; potentialUserComponent.PotentialUser.LinkedIn = txtLinkedIn.Text; potentialUserComponent.PotentialUser.GooglePlus = txtGooglePlus.Text; potentialUserComponent.PotentialUser.Twitter = txtTwitter.Text; potentialUserComponent.PotentialUser.Facebook = txtFacebook.Text; potentialUserComponent.PotentialUser.Skype = txtSkype.Text; potentialUserComponent.PotentialUser.Language = ddLanguage.SelectedValue; potentialUserComponent.PotentialUser.Country = ddCountry.SelectedValue; string newOrgType = Localization.GetString("NewOrganizationType", this.LocalResourceFile).ToString(); if (ddOrganizationType.SelectedValue == newOrgType) { if (txtNewOrganizationType.Text != string.Empty) { potentialUserComponent.PotentialUser.OrganizationType = txtNewOrganizationType.Text; } } else { potentialUserComponent.PotentialUser.OrganizationType = ddOrganizationType.SelectedValue; } potentialUserComponent.Save(); if (editItem.ItemIndex != -1) { this.grdPreUsers.MasterTableView.Items[editItem.ItemIndex].Edit = false; } else { this.grdPreUsers.MasterTableView.Rebind(); } e.Item.OwnerTableView.IsItemInserted = false; } } } } }
protected void btnSubmit_Click(object sender, EventArgs e) { int ExistUser = 0; potentialUserComponent = new PotentialUserComponent(txtEmail.Text); if (potentialUserComponent.PotentialUser.PotentialUserId == Guid.Empty) { ExistUser = 1; potentialUserComponent.PotentialUser.Deleted = false; potentialUserComponent.PotentialUser.Created = DateTime.Now; potentialUserComponent.PotentialUser.Updated = potentialUserComponent.PotentialUser.Created; } else { potentialUserComponent.PotentialUser.Updated = DateTime.Now; ExistUser = 2; } potentialUserComponent.PotentialUser.Email = txtEmail.Text; potentialUserComponent.PotentialUser.FirstName = txtFirstName.Text; potentialUserComponent.PotentialUser.LastName = txtLastName.Text; potentialUserComponent.PotentialUser.Address = txtAddress.Text; potentialUserComponent.PotentialUser.Phone = txtPhone.Text; potentialUserComponent.PotentialUser.OrganizationName = txtOrganizationName.Text; potentialUserComponent.PotentialUser.Country = ddCountry.SelectedValue; potentialUserComponent.PotentialUser.Region = ddRegion.SelectedValue; potentialUserComponent.PotentialUser.City = ddCities.SelectedValue; var lan = "EN"; if (Language == "pt-BR") { lan = "PT"; } if (Language == "es-ES") { lan = "ES"; } potentialUserComponent.PotentialUser.Source = "VPC2015FORM_" + lan; potentialUserComponent.PotentialUser.Title = txtTitle.Text; potentialUserComponent.PotentialUser.WebSite = txtWebSite.Text; potentialUserComponent.PotentialUser.LinkedIn = txtLinkedIn.Text; potentialUserComponent.PotentialUser.GooglePlus = txtGooglePlus.Text; potentialUserComponent.PotentialUser.Twitter = txtTwitter.Text; potentialUserComponent.PotentialUser.Facebook = txtFacebook.Text; potentialUserComponent.PotentialUser.Skype = txtSkype.Text; if (txtOther.Text != string.Empty) { potentialUserComponent.PotentialUser.Sector = txtOther.Text; } else { if (!string.IsNullOrEmpty(ddSectorItems.SelectedValue)) { potentialUserComponent.PotentialUser.Sector = ddSectorItems.SelectedValue; } else { potentialUserComponent.PotentialUser.Sector = ddSectorJPO.SelectedValue; } } if (potentialUserComponent.Save() > 0) { pnlSubscription.Visible = false; pnlMessage.Visible = true; } //SendEmail(ExistUser, txtEmail.Text); }