//================ ON FORM LOAD EVENT ======================================================= private void frmAddContact_Load(object sender, EventArgs e) { try { //Loads contact types into the form when the form first opens DataTable dataTable = ContactDb.GetAllContactTypes(); System.Diagnostics.Debug.WriteLine(dataTable.Columns); //allows user input to list states that begin wtih the input cboContactType.AutoCompleteSource = AutoCompleteSource.ListItems; cboContactType.AutoCompleteMode = AutoCompleteMode.SuggestAppend; // fill state combo box with state names from database var lst = new List <String>(); foreach (DataRow row in dataTable.Rows) { lst.Add(row["ContactType"].ToString()); } cboContactType.Items.Clear(); cboContactType.DataSource = lst; //sets intial values of state combo box and state SP pararamter to "" so defalut // value is null if no state is selected by the user. cboContactType.Text = ""; } catch { MessageBox.Show("Database Error, contact types are not available. " + "Contact administrator"); } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (IsValidData()) { //If the data is valid, then initialize fields to string or int and instanciate Customer object contactType = (txtContactType.Text.ToUpper()); try { DataTable dataTable = ContactDb.GetAllContactTypes(); // get list of all contact types var lst = new List <String>(); foreach (DataRow row in dataTable.Rows) // Check to see if the contact type entered already exists { if (row["ContactType"].ToString() == contactType) { MessageBox.Show("Contact Type " + contactType + " already exists, please re-enter."); txtContactType.Text = ""; txtContactType.Focus(); return; } } } catch { MessageBox.Show("Database Error, contact types are not available. " + "Contact administrator"); txtContactType.Text = ""; txtContactType.Focus(); } //Attempt to add new contact type to database dbUpdateSuccessful = ContactDb.AddContactType(contactType); if (dbUpdateSuccessful == 0) { txtContactType.Text = ""; txtContactType.Focus(); MessageBox.Show("Database exception, contact type has " + "not been added. Contact administrator."); } else { txtContactType.Text = ""; txtContactType.Focus(); MessageBox.Show("Contact Type Added."); } } } catch (Exception ex) { MessageBox.Show(ex.Message + "\n\n" + ex.GetType().ToString() + "/n" + ex.StackTrace, "Exception"); } }
public ContactRepo(ContactDb context, IPropertyMappingService propertyMappingService) { _context = context ?? throw new ArgumentNullException(nameof(context)); _propertyMappingService = propertyMappingService ?? throw new ArgumentNullException(nameof(propertyMappingService)); }
private void btnDelete_Click(object sender, EventArgs e) { //capture selected item of contact type highlighted to be deleted string selectedContactType = ""; selectedContactType = lstContactType.GetItemText(lstContactType.SelectedItem); if (selectedContactType == "") { MessageBox.Show("No Contact Type selected."); return; } //check to see if contact type is currently being used and, therefore, cannot be delelted try { CkContactTypeExits = ContactDb.GetContactTypes(selectedContactType); if (CkContactTypeExits != 0) { MessageBox.Show("Cannot delete '" + selectedContactType + "' contact type because " + "it is currently assigned to a contact."); return; } } catch { MessageBox.Show("Database Error, contact types are not available. " + "Contact administrator"); return; } //Attempt to delete contact type from database try { dbDeleteSuccessful = ContactDb.DeleteContactType(selectedContactType); if (dbDeleteSuccessful == 0) { MessageBox.Show("Database exception, contact type has " + "not been deleted. Contact administrator."); return; } else { MessageBox.Show("Contact Type Deleted."); loadFormData(); } } catch { MessageBox.Show("Database Error, contact types are not available. " + "Contact administrator"); return; } }
public void ProcessRequest(HttpContext context) { bool result = false; string action = context.Request["action"] ?? ""; try { if (action == "select") { string con = ContactDb.GetSingle("2"); context.Response.Write(con); return; } string title = context.Request["title"] ?? ""; string id = context.Request["id"] ?? ""; string content = context.Request["content"] ?? ""; Contact contact = new Contact() { Title = title, Id = id, Content = content, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }; if (action == "update") { result = ContactDb.Update(contact); } else { result = ContactDb.Add(contact); } } catch (Exception ex) { context.Response.ContentType = "text/plain"; context.Response.Write(ex.Message); } String message = result == true ? "操作成功" : "操作失败"; context.Response.ContentType = "text/plain"; context.Response.Write(message); }
private void loadFormData() { try { var dataTable = ContactDb.GetAllContactTypes(); // GET ALL CONTACTS var lst = new List <String>(); foreach (DataRow row in dataTable.Rows) { lst.Add(row["ContactType"].ToString()); } lstContactType.DataSource = lst; } catch { MessageBox.Show("Database Error, contact types are not available. " + "Contact administrator"); } }
//===================================================================================== //=========== ON SUBMIT BUTTON CLICKED ===================================================== private void btnSubmit_Click(object sender, EventArgs e) { try { if (IsValidData()) { //If the data is valid, then initialize fields to string or int and instanciate Customer object contactFirstName = (txtContactFirstName.Text); contactLastName = (txtContactLastName.Text); contactType = (cboContactType.Text); contactNote = (txtContactNote.Text); contactStreet = (txtStreet.Text); contactCity = (txtCity.Text); contactState = (txtState.Text); //Instantiate Contact Object Contact contact = new Contact(contactFirstName, contactLastName, contactType, contactNote, contactStreet, contactCity, contactState); //Invoke AddContact Db stored procedure and pass in contact object dbUpdateSuccessful = ContactDb.AddContact(contact); if (dbUpdateSuccessful == 0) { ClearAllFields(); MessageBox.Show("Database exception, contact administrator."); } else { ClearAllFields(); MessageBox.Show("Contact Added."); } } } catch (Exception ex) { MessageBox.Show(ex.Message + "\n\n" + ex.GetType().ToString() + "/n" + ex.StackTrace, "Exception"); } } // end btn click
public async Task CreateContact([FromBody] CreateEntityRequest request) { if (request == null) { throw new ArgumentNullException(nameof(request)); } var userId = User.Claims.GetUserId(); var contactDb = new ContactDb { Name = request.Name, UserId = userId, Notes = "[]", Gender = Gender.Undefined, AddressCategories = DefaultAddressCategories(), PhoneCategories = DefaultPhoneCategories() }; await _dbService.Insert(contactDb); }
public ActionResult CreateContact() { //DateTime myDateTime = DateTime.Now; //string sqlformattedDate = myDateTime.ToString("yyyy-MM-dd hh:mm:ss.fff"); var batchName = getBatchName(); ContactBatch batch = new ContactBatch { BatchName = batchName, CreatedBy = "System", DateCreated = DateTime.Now //DateCreated = Convert.ToDateTime(sqlformattedDate) }; int batchId = ContactBatchDB.GetBatchID(batch); List <ContactVM> contacts = new List <ContactVM>(); contacts = (List <ContactVM>)Session["Upload"]; ContactDb.PostToDatabase(contacts, batchId); return(View(contacts)); }
private void btnFind_Click(object sender, EventArgs e) { srchLastName = txtSrchLastName.Text; try { var dataTable = ContactDb.GetContactXLastName(srchLastName); // GET ALL CONTACTS var lst = new List <String>(); foreach (DataRow row in dataTable.Rows) { lst.Add(row["ContactFirstName"].ToString() + ", " + row["ContactLastName"].ToString() + row["ContactCoName"].ToString() + ", " + row["ContactJobTitle"].ToString() + ", " + row["ContactType"].ToString()); } lstSrchResults.DataSource = lst; } catch { MessageBox.Show("Database Error, contact types are not available. " + "Contact administrator"); } }
/// <summary> /// By submitting ID of the user in the body of the request, you can attempt to "Friend" them /// </summary> /// <param name="contactID">returns 200 if successfull, or will reply if unsuccessfull</param> public async Task <dynamic> Post([FromBody] long contactID) { var UserId = long.Parse(User.Identity.GetUserId()); bool exists = await db.Contacts.AnyAsync( p => (p.Person1Id == UserId && p.Person2Id == contactID) || (p.Person1Id == contactID && p.Person2Id == UserId)); if (exists) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ErrorResponse.CantOverrite)); } if (!await db.Users.AnyAsync(u => u.Id == contactID)) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ErrorResponse.DoesntExist)); } ContactDb newContact = new ContactDb { State = ContactDb.StatePendingP2, Person1Id = UserId, Person2Id = contactID }; db.Contacts.Add(newContact); await db.SaveChangesAsync(); var parties = await db.Users.Where(p => p.Id == contactID || p.Id == UserId).ToArrayAsync(); long phone = parties.First(p => p.Id == contactID).PhoneNumber; string actorName = parties.First(p => p.Id == UserId).FirstName + " " + parties.First(p => p.Id == UserId).LastName; string message = "Hive: " + String.Format("{0} has sent you a friend request!", actorName); SMSService.SendMessage(phone.ToString(), message); //We don;t want to await an SMS, really return(Ok(newContact.ToContact(UserId))); }
public TestSaveContact() { var contacts = new[] { new Contact { Id = 1, FirstName = "First", LastName = "Last", Email = "*****@*****.**", PhoneNumber = "555-1212" }, }.ToDbSet(); _db = A.Fake <ContactDb>(); A.CallTo(() => _db.Contacts).Returns(contacts); _appContext = A.Fake <AppContext>(); _queue = A.Fake <IQueueService>(); _mediator = A.Fake <IMediator>(); _handler = new SaveContact.Handler(_db, _appContext, _queue, _mediator); }
public ActionResult GetFileById(int id) { return(View(ContactDb.GetContactsByBatchId(id))); }