public string AddEntry(Entry newPbEntry)
{
try
{
using (var ctxModel = new PhoneBookModel())
{
var existingEntry =
ctxModel.Entries.FirstOrDefault(
x => x.UserId == newPbEntry.UserId && x.Person == newPbEntry.Person);
if (existingEntry == null)
{
ctxModel.Entries.Add(newPbEntry);
}
else
{
existingEntry.Number = newPbEntry.Number;
}
ctxModel.SaveChanges();
}
return("Success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string AddUser(PbUser newPbUser)
{
try
{
using (var ctxModel = new PhoneBookModel())
{
var existingUser = ctxModel.Users.FirstOrDefault(x => x.UserInternalId == newPbUser.UserInternalId);
if (existingUser == null)
{
ctxModel.Users.Add(newPbUser);
}
else
{
if (existingUser.User != newPbUser.User)
{
existingUser.User = newPbUser.User;
}
}
ctxModel.SaveChanges();
}
return("Success");
}
catch (Exception ex)
{
return(ex.Message);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var model = new PhoneBookModel();
var contact = model.Contacts.FirstOrDefault(m => m.ContactId == Id);
var num = Number1.Text;
model.PhoneNumbers.Add(new PhoneNumber {
ContactId = Id, Number = num.ToString(), Contact = contact
});
model.SaveChanges();
Response.Redirect("Default.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
Id = int.Parse(id);
var model = new PhoneBookModel();
var c = model.Contacts.FirstOrDefault(m => m.ContactId == Id);
c.Name = Name1.Text;
c.NationalId = NationalId1.Text;
model.SaveChanges();
Response.Redirect("Default.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request.QueryString["PhoneId"]))
{
string id = Request.QueryString["PhoneId"];
var Id = int.Parse(id);
var model = new PhoneBookModel();
var _phoneNumber = model.PhoneNumbers.FirstOrDefault(m => m.PhoneNumberID == Id);
_phoneNumber.Number = Number1.Text;
model.SaveChanges();
Response.Redirect("~/edit?id=" + _phoneNumber.ContactId);
}
}
//public string DeleteUser(string id)
//{
// try
// {
// using (var ctxModel = new PhoneBookModel())
// {
// ctxModel.Entries.RemoveRange(ctxModel.Entries.Where(e => e.Entry.UserId == id).ToList());
// ctxModel.Users.Remove(ctxModel.Users.Single(x=> x.PbUser.Id ==id));
// ctxModel.SaveChanges();
// return "Success";
// }
// }
// catch (Exception ex)
// {
// return ex.Message;
// }
//}
public string DeleteEntry(int id)
{
try
{
using (var ctxModel = new PhoneBookModel())
{
ctxModel.Entries.Remove(ctxModel.Entries.Single(e => e.Id == id));
ctxModel.SaveChanges();
return("Success");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var model = new PhoneBookModel();
// var id= model.Contacts.Count() + 1;
var num = Number1.Text;
var contact = new Contact();
// contact.ContactId = id;
contact.Name = Name1.Text;
contact.NationalId = NationalId1.Text;
var m = model.Contacts.Add(contact);
model.PhoneNumbers.Add(new PhoneNumber {
ContactId = m.ContactId, Number = num.ToString(), Contact = m
});
model.SaveChanges();
Response.Redirect("Default.aspx");
}
