public void Insert(string firstName, string surname, string tell, string mobileNumber, string address, string userName, string password)
{
using (var context = new Model.DomainModel.DTO.EF.KubissEntities2())
{
try
{
Model.DomainModel.DTO.EF.Person ref_person = new DTO.EF.Person();
ref_person.FirstName = firstName;
ref_person.Surname = surname;
ref_person.Tell = tell;
ref_person.MobileNumber = mobileNumber;
ref_person.Address = address;
ref_person.UserName = userName;
ref_person.Password = password;
context.Person.Add(ref_person);
context.SaveChanges();
}
catch (Exception)
{
throw;
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
}
public void Inser(string fName, string lName, string identityCode, string telNumber, string phoneNumber)
{
using (var context = new Model.DomainModel.DTO.EF.ContactEntities1())
{
try
{
var person = new DTO.EF.Person();
person.FirstName = fName;
person.LastName = lName;
person.IdentityCode = identityCode;
person.TelephoneNumber = telNumber;
person.PhoneNumber = phoneNumber;
if (true)
{
}
context.Person.Add(person);
context.SaveChanges();
}
catch (Exception ex)
{
ErrorMessage = ex.Message + " " + ex.TargetSite;
throw;
}
finally
{
context.Dispose();
}
}
}
public void Insert(string name, string surname, int username, int password)
{
using (var Context = new DomainModel.DTO.EF.OnlineShoppingEntities())
{
try
{
DTO.EF.Person Ref_Person = new DTO.EF.Person();
Ref_Person.FirstName = name;
Ref_Person.Surname = surname;
Ref_Person.UserName = (username);
Ref_Person.Password = (password);
Context.Person.Add(Ref_Person);
Context.SaveChanges();
}
catch (Exception)
{
throw;
}
finally
{
if (Context != null)
{
Context.Dispose();
}
}
}
}
public void Delete(DTO.EF.Person person)
{
using (var context = new Model.DomainModel.DTO.EF.ContactEntities1())
{
try
{
context.Entry(person).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
catch (Exception ex)
{
ErrorMessage = ex.Message + " " + ex.TargetSite;
throw;
}
finally
{
context.Dispose();
}
}
}
public void Update(string id, string title, string nationalCode, string firstName, string surname, string country,
DateTime dateOfBirth, string contactEmail, string mobilNumber,
string username, string password, string address)
{
using (var context = new Model.DomainModel.DTO.EF.OnlineShoppingEntities())
{
try
{
Model.DomainModel.DTO.EF.Person ref_Person = new DTO.EF.Person();
ref_Person = context.Person.Find(System.Convert.ToInt32(id));
ref_Person.Title = title;
ref_Person.NationalCode = nationalCode;
ref_Person.FirstName = firstName;
ref_Person.Surname = surname;
ref_Person.Country = country;
ref_Person.DateofBirth = dateOfBirth;
ref_Person.ContactEmail = contactEmail;
ref_Person.MobileNumber = mobilNumber;
ref_Person.Username = username;
ref_Person.Password = password;
ref_Person.Address = address;
context.Entry(ref_Person).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
catch (Exception)
{
throw;
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
}
public void Delete(int rowid)
{
using (var context = new Model.DomainModel.DTO.EF.OnlineShoppingEntities())
{
try
{
Model.DomainModel.DTO.EF.Person ref_Person = new DTO.EF.Person();
ref_Person = context.Person.Find(rowid);
context.Person.Remove(ref_Person);
context.SaveChanges();
}
catch (Exception)
{
throw;
}
finally
{
if (context != null)
{
context.Dispose();
}
}
}
}
/// <summary>
/// Insert:ParameterBinding
/// </summary>
/// <param name="fName"></param>
/// <param name="lName"></param>
/// <param name="phoneNumber"></param>
/// <param name="telNumber1"></param>
/// <param name="telNumber2"></param>
/// <param name="homeAddress"></param>
public void Insert(string fName, string lName, string phoneNumber, string telNumber1, string telNumber2, string homeAddress)
{
using (var context = new DTO.EF.Test1Entities1())
{
try
{
var people = new DTO.EF.Person();
people.LName = lName;
people.FName = fName;
people.PhoneNumber = phoneNumber;
people.TelNumber1 = telNumber1;
people.TelNumber2 = telNumber2;
people.HomeAddress = homeAddress;
context.People.Add(people);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
Console.WriteLine(string.Format("DbEntityValidationException:{0}", ex.Message));
}
catch (Exception ex)
{
ErrorMessage = ex.Message + "==>" + ex.TargetSite;
throw;
// ErrorMessage = ex.Message + "==>" + ex.TargetSite;
// return ErrorMessage;
}
finally
{
context.Dispose();
}
}
}
