public List <Person> ChargerContacts()
{
using (ContactsEntities context = new ContactsEntities())
{
return((from C in context.Persons select C).ToList());
}
}
async Task <ContactModel> IContactRepo.AddorUpdateContact(ContactModel contactModel)
{
var model = new ContactInfo
{
ContactId = contactModel.ContactId,
Email = contactModel.Email,
FirstName = contactModel.FirstName,
LastName = contactModel.LastName,
Phone = contactModel.Phone,
Status = contactModel.Status
};
using (var ctx = new ContactsEntities())
{
var contact = ctx.ContactInfoes.FirstOrDefault(x => x.Email == model.Email);
if (contact == null)
{
// Add new contact to list
ctx.ContactInfoes.Add(model);
await ctx.SaveChangesAsync();
return(contactModel);
}
contact.Phone = contactModel.Phone;
contact.FirstName = contactModel.FirstName;
contact.LastName = contactModel.LastName;
contact.Status = contactModel.Status;
await ctx.SaveChangesAsync();
return(contactModel);
}
}
static void Main(string[] args)
{
using (ContactsEntities entities = new ContactsEntities())
{
Address doeaddress = new Address()
{
Street = "1 Broadway", ZipCode = "01234"
};
Address doeaddress2 = new Address()
{
Street = "2 Broadway", ZipCode = "01234"
};
entities.Addresses.Add(doeaddress);
entities.Persons.Add(new Person()
{
FirstName = "Jane", LastName = "Doe", Address = doeaddress
});
entities.Persons.Add(new Person()
{
FirstName = "John", LastName = "Doe", Address = doeaddress
});
entities.Persons.Add(new Person()
{
FirstName = "Jim", LastName = "Doe", Address = doeaddress2
});
entities.SaveChanges();
}
Console.WriteLine("Press Enter to exit...");
Console.ReadLine();
}
public IHttpActionResult PostContact(ContactViewModel contact)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid Data"));
}
try
{
using (var ctx = new ContactsEntities())
{
ctx.Contacts.Add(new Contact()
{
ContactId = Guid.NewGuid(),
FirstName = contact.FirstName,
LastName = contact.LastName,
Email = contact.Email,
PhoneNumber = contact.PhoneNumber,
Status = contact.IsActive,
CreateDate = DateTime.Now,
});
ctx.SaveChanges();
}
}
catch (HttpResponseException ex)
{
BadRequest(ex.Message);
}
return(Ok());
}
public IHttpActionResult GetContact(Guid id)
{
ContactViewModel contacts = null;
try
{
using (var cts = new ContactsEntities())
{
contacts = cts.Contacts
.Where(s => s.ContactId == id)
.Select(s => new ContactViewModel()
{
ContactId = s.ContactId,
FirstName = s.FirstName,
LastName = s.LastName,
Email = s.Email,
PhoneNumber = s.PhoneNumber,
IsActive = s.Status,
CreateDate = s.CreateDate
}).FirstOrDefault <ContactViewModel>();
}
if (contacts == null)
{
return(NotFound());
}
}
catch (HttpResponseException ex)
{
BadRequest(ex.Message);
}
return(Ok(contacts));
}
public IHttpActionResult GetAllContact()
{
IList <ContactViewModel> contacts = null;
try
{
using (var cts = new ContactsEntities())
{
contacts = cts.Contacts.Select(s => new ContactViewModel()
{
ContactId = s.ContactId,
FirstName = s.FirstName,
LastName = s.LastName,
Email = s.Email,
PhoneNumber = s.PhoneNumber,
IsActive = s.Status,
Status = s.Status ? "Active" : "Inactive",
CreateDate = s.CreateDate
}).ToList <ContactViewModel>();
}
if (contacts.Count == 0)
{
return(NotFound());
}
}
catch (HttpResponseException ex)
{
return(BadRequest(ex.Message));
}
return(Ok(contacts));
}
private void btn_ChangePass_Click(object sender, EventArgs e)
{
if (tb_newpass.Text.Length < 5)
{
MessageBox.Show(@"رمز عبور باید حداقل 4 حرف باشد");
}
if (tb_newpass.Text != tb_newpass2.Text)
{
MessageBox.Show(@"رمز عبور جدید با تکرار آن مطابقت ندارد");
}
else
{
ContactsEntities db = new ContactsEntities();
var pcon = db.Configs.FirstOrDefault(p => p.ConfigKey == "Password");
if (pcon != null)
{
pcon.ConfigValue = tb_newpass.Text;
}
else
{
db.Configs.Add(new Configs
{
ConfigKey = "Password",
ConfigValue = tb_newpass.Text
});
}
db.SaveChanges();
}
}
public IHttpActionResult PutContact(ContactViewModel contact)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
try
{
using (var ctx = new ContactsEntities())
{
var existingContact = ctx.Contacts.Where(s => s.ContactId == contact.ContactId).FirstOrDefault <Contact>();
if (existingContact != null)
{
existingContact.FirstName = contact.FirstName;
existingContact.LastName = contact.LastName;
existingContact.Email = contact.Email;
existingContact.PhoneNumber = contact.PhoneNumber;
existingContact.Status = contact.IsActive;
existingContact.CreateDate = contact.CreateDate;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
}
catch (HttpResponseException ex) { BadRequest(ex.Message); }
return(Ok());
}
public int SaveContact(int?ID, string contact)
{
JObject jContact = JObject.Parse(contact);
string Fname = (string)jContact["Fname"];
string Lname = (string)jContact["Lname"];
Contact contactModel = new Contact();
contactModel.Id = (int)ID;
contactModel.Fname = Fname;
contactModel.Lname = Lname;
using (ContactsEntities db = new ContactsEntities()) {
if (ID == 0)
{
db.Contacts.Add(contactModel);
db.SaveChanges();
}
else
{
db.Entry(contactModel).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return((int)ID);
}
}
public ActionResult LoadContactsData()
{
using (ContactsEntities db = new ContactsEntities())
{
List <Contact> Contacts = db.Contacts.ToList <Contact>();
return(Json(Contacts, JsonRequestBehavior.AllowGet));
}
}
////////////Address Section
public ActionResult LoadAddressData(int ContactId)
{
using (ContactsEntities db = new ContactsEntities())
{
List <Address> Address = db.Addresses.Where(w => w.Contact_id == ContactId).ToList();
return(Json(Address, JsonRequestBehavior.AllowGet));
}
}
public int DeleteContact(int?ID, string contact)
{
Contact contactModel = new Contact();
using (ContactsEntities db = new ContactsEntities())
{
contactModel = db.Contacts.Where(x => x.Id == ID).FirstOrDefault <Contact>();
db.Contacts.Remove(contactModel);
db.SaveChanges();
return((int)ID);
}
}
private void SearchContacts_Load(object sender, EventArgs e)
{
ContactsEntities db = new ContactsEntities();
var g = db.ContactGroupDef.ToList();
foreach (ContactGroupDef contactGroupDef in g)
{
clb_Groups.Items.Add(contactGroupDef);
}
clb_Groups.DisplayMember = "GroupName";
_allperson = db.ContactPerson.ToList();
}
public void LoadGroup()
{
dataGV_group.Rows.Clear();
ContactsEntities db = new ContactsEntities();
foreach (ContactGroupDef contactGroupDef in db.ContactGroupDef.ToList())
{
dataGV_group.Rows.Add(new object[]
{
contactGroupDef.Id,
contactGroupDef.GroupName
});
}
}
public void Setup()
{
_contacts = SetUpContacts();
_dbEntities = new Mock <ContactsEntities>().Object;
_contactRepository = SetUpContactRepository();
var dbOperation = new Mock <DbOperation>();
dbOperation.SetupGet(s => s.ContactRepository).Returns(_contactRepository);
_dbOperation = dbOperation.Object;
_contactService = new ContactServices(_dbOperation);
_client = new HttpClient {
BaseAddress = new Uri(ServiceBaseURL)
};
}
private void btn_addGroup_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(tb_groupName.Text))
{
ContactsEntities db = new ContactsEntities();
db.ContactGroupDef.Add(new ContactGroupDef()
{
GroupName = tb_groupName.Text
});
db.SaveChanges();
LoadGroup();
MessageBox.Show("با موفقیت اضافه شد");
}
}
public bool DeleteContact(Person contact)
{
if (contact.Id > 0)
{
using (ContactsEntities context = new ContactsEntities())
{
context.Persons.Attach(contact);
context.Entry(contact).State = EntityState.Deleted;
context.SaveChanges();
}
return(true);
}
return(false);
}
private void AddContact_Load(object sender, EventArgs e)
{
ContactsEntities db = new ContactsEntities();
var g = db.ContactGroupDef.ToList();
foreach (ContactGroupDef contactGroupDef in g)
{
clb_Groups.Items.Add(contactGroupDef);
}
clb_Groups.DisplayMember = "GroupName";
if (_contactid > 0)
{
LoadContact(_contactid);
}
}
private void btn_removeGroup_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow selectedRow in dataGV_group.SelectedRows)
{
int groupid;
if (int.TryParse(selectedRow.Cells[0].Value.ToString(), out groupid))
{
ContactsEntities db = new ContactsEntities();
db.Database.ExecuteSqlCommand("DELETE FROM ContactGroupDef WHERE Id=" + groupid);
db.Database.ExecuteSqlCommand("DELETE FROM ContactGroup WHERE GroupId=" + groupid);
db.SaveChanges();
LoadGroup();
MessageBox.Show("با موفقیت حذف شد");
}
}
}
private void dataGV_person_MouseDoubleClick(object sender, MouseEventArgs e)
{
if (dataGV_person.SelectedRows.Count == 1)
{
this.Hide();
int cotacatid;
int.TryParse(dataGV_person.SelectedRows[0].Cells[0].Value.ToString(), out cotacatid);
var form = new AddContact(cotacatid);
form.ShowDialog();
this.Show();
this.Focus();
ContactsEntities db = new ContactsEntities();
_allperson = db.ContactPerson.ToList();
Search();
}
}
private void Import_Load(object sender, EventArgs e)
{
var col = (DataGridViewComboBoxColumn)dataGV_group.Columns[1];
col.DataSource = MyConfigs.DataModels;
col.ValueMember = "Modelkey";
col.DisplayMember = "ModelName";
btn_import.Enabled = false;
ContactsEntities db = new ContactsEntities();
var g = db.ContactGroupDef.ToList();
foreach (ContactGroupDef contactGroupDef in g)
{
clb_Groups.Items.Add(contactGroupDef);
}
clb_Groups.DisplayMember = "GroupName";
}
private void LoadContact(int contactid)
{
ContactsEntities db = new ContactsEntities();
var per = db.ContactPerson.FirstOrDefault(p => p.Id == contactid);
if (per != null)
{
tb_firstname.Text = per.FirstName;
tb_LastName.Text = per.LastName;
tb_Birthdate.Text = per.DateOfBirth.ToString();
tb_postname.Text = per.PostName;
this.Text = "ویرایش مخاطب";
btn_add.Text = "ویرایش مخاطب";
btn_delete.Visible = true;
foreach (ContactPhone contactPhone in per.ContactPhone)
{
AddCallBox((int)contactPhone.PhoneType, contactPhone.PhoneNumber);
}
foreach (ContactAddress contactaddress in per.ContactAddress)
{
AddAddressBox((int)contactaddress.AddressType, contactaddress.Address);
}
foreach (ContactEmail contactemail in per.ContactEmail)
{
AddEmailBox((int)contactemail.EmailType, contactemail.Email);
}
foreach (ContactGroup contactGroup in per.ContactGroup)
{
int index = 0;
foreach (ContactGroupDef cGroup in db.ContactGroupDef.ToList())
{
if (cGroup.Id == contactGroup.GroupId)
{
clb_Groups.SetItemChecked(index, true);
}
index++;
}
}
}
else
{
MessageBox.Show("مخاطبی یافت نشد");
this.Close();
}
}
public int SaveContact(Person contact)
{
using (ContactsEntities context = new ContactsEntities())
{
if (contact.Id > 0)
{
context.Persons.Attach(contact);
context.Entry(contact).State = EntityState.Modified;
context.SaveChanges();
}
else
{
context.Persons.Add(contact);
context.SaveChanges();
}
}
return(contact.Id);
}
private void btn_ClearAll_Click(object sender, EventArgs e)
{
if (MessageBox.Show(@"آیااز این کار مطمعن هستید؟", @"هشدار", MessageBoxButtons.YesNo
, MessageBoxIcon.Warning) == DialogResult.Yes)
{
ContactsEntities db = new ContactsEntities();
db.Database.ExecuteSqlCommand("delete from ContactAddress;");
db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactAddress';");
db.Database.ExecuteSqlCommand("delete from ContactEmail; ");
db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactEmail';");
db.Database.ExecuteSqlCommand("delete from ContactGroup; ");
db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactGroup';");
db.Database.ExecuteSqlCommand("delete from ContactPerson; ");
db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactPerson';");
db.Database.ExecuteSqlCommand("delete from ContactPhone; ");
db.Database.ExecuteSqlCommand("delete from sqlite_sequence where name='ContactPhone';");
MessageBox.Show(@"پاک سازی با موفقیت انجام شد");
}
}
public IHttpActionResult DeleteContact(Guid id)
{
if (id == null)
{
return(BadRequest("Not a valid contact id"));
}
try
{
using (var ctx = new ContactsEntities())
{
var contact = ctx.Contacts.Where(s => s.ContactId == id).FirstOrDefault();
ctx.Contacts.Remove(contact);
ctx.SaveChanges();
}
}
catch (HttpResponseException ex)
{ BadRequest(ex.Message); }
return(Ok());
}
private void btn_delete_Click(object sender, EventArgs e)
{
ContactsEntities db = new ContactsEntities();
if (_contactid > 0)
{
var con = db.ContactPerson.FirstOrDefault(p => p.Id == _contactid);
if (con != null)
{
db.ContactPerson.Remove(con);
db.SaveChanges();
db.Database.ExecuteSqlCommand("DELETE FROM ContactPhone WHERE ContactPersonID=" + _contactid);
db.Database.ExecuteSqlCommand("DELETE FROM ContactAddress WHERE ContactPersonID=" + _contactid);
db.Database.ExecuteSqlCommand("DELETE FROM ContactEmail WHERE ContactPersonID=" + _contactid);
db.Database.ExecuteSqlCommand("DELETE FROM ContactGroup WHERE ContactPersonID=" + _contactid);
}
}
MessageBox.Show("تغییرات خواسته شده اعمال شد");
this.Close();
}
async Task <ContactModel> IContactRepo.DeleteContact(int id)
{
using (var ctx = new ContactsEntities())
{
var contact = ctx.ContactInfoes.Find(id);
if (contact == null)
{
throw new ContactException("No Data Found for given id");
}
if (contact.Status == "Inactive")
{
contact.Status = "Active";
// save contact object back to data base.
await ctx.SaveChangesAsync();
return(new ContactModel
{
ContactId = contact.ContactId,
Email = contact.Email,
FirstName = contact.FirstName,
LastName = contact.LastName,
Phone = contact.Phone,
Status = contact.Status
});
}
contact.Status = "Inactive";
// save contact object back to data base.
await ctx.SaveChangesAsync();
return(new ContactModel
{
ContactId = contact.ContactId,
Email = contact.Email,
FirstName = contact.FirstName,
LastName = contact.LastName,
Phone = contact.Phone,
Status = contact.Status
});
}
}
async Task <List <ContactModel> > IContactRepo.GetContact()
{
using (var ctx = new ContactsEntities())
{
var contacts = await ctx.ContactInfoes.ToListAsync();
if (!contacts.Any())
{
throw new ContactException("No Data Found for given id");
}
return(contacts.ConvertAll(x => new ContactModel
{
ContactId = x.ContactId,
Email = x.Email,
FirstName = x.FirstName,
LastName = x.LastName,
Phone = x.Phone,
Status = x.Status
}));
}
}
protected override void ProcessRecord()
{
if (String.IsNullOrWhiteSpace(LastName))
{
throw new ArgumentNullException(nameof(LastName));
}
// Auswertung der Parameter
var contact = new Contact
{
FirstName = this.FirstName,
LastName = this.LastName
};
try
{
WriteDebug("Datenbankverbindung wird geöffnet");
using (ContactsEntities model = new ContactsEntities())
{
WriteDebug("Datenbankverbindung geöffnet");
model.Contacts.Add(contact);
model.SaveChanges();
WriteDebug("Schließe Datenbankverbindung");
}
WriteObject(contact);
}
catch (Exception e)
{
// Auswertung des Fehlers...
WriteError(new ErrorRecord(e, "1", ErrorCategory.WriteError, null));
}
}
public void GetContactByIdAndPipeline()
{
// Testvorbereitung
var contactone = new Contact()
{
FirstName = "Hans", LastName = "Mustermann"
};
var contacttwo = new Contact()
{
FirstName = "Franz", LastName = "Heinrich"
};
using (ContactsEntities model = new ContactsEntities())
{
model.Contacts.Add(contactone);
model.Contacts.Add(contacttwo);
model.SaveChanges();
}
var script = $@"Import-Module '{_assemblyname}'
{contactone.Id}, {contacttwo.Id} | Get-Contact | Export-Csv -Path 'D:\personen.txt'
";
var result = RunScript(script);
Write(result);
var contactresult = result.Output.OfType <Contact>();
//Assert.NotNull(contactresult);
//Assert.True(contactresult.Count() == 2);
//Assert.Contains(contactresult, c => c.Id == contactone.Id);
//Assert.Contains(contactresult, c => c.Id == contacttwo.Id);
}
