public bool DeleteContact(VinaGerman.Entity.BusinessEntity.ContactEntity entityObject) { string sqlStatement = "UPDATE Contact SET Deleted=1 WHERE ContactId=@ContactId " + Environment.NewLine; //execute Connection.Execute(sqlStatement, new { ContactId = entityObject.ContactId }, Transaction); return(true); }
public bool DeleteContact(VinaGerman.Entity.BusinessEntity.ContactEntity entityObject) { //execute using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance()) { try { db.OpenConnection(); return(db.Resolve <IContactDB>().DeleteContact(entityObject)); } finally { db.CloseConnection(); } } }
public VinaGerman.Entity.BusinessEntity.ContactEntity AddOrUpdateContact(VinaGerman.Entity.BusinessEntity.ContactEntity entityObject) { string sqlStatement = ""; //if insert if (entityObject.ContactId > 0) { sqlStatement += "UPDATE Contact SET " + Environment.NewLine + "FullName=@FullName," + Environment.NewLine + "Email=@Email," + Environment.NewLine + "Phone=@Phone," + Environment.NewLine + "Address=@Address," + Environment.NewLine + "CompanyId=@CompanyId," + Environment.NewLine + "UserAccountId=@UserAccountId," + Environment.NewLine + "Position=@Position," + Environment.NewLine + "DepartmentId=@DepartmentId," + Environment.NewLine + "Deleted=@Deleted" + Environment.NewLine + "WHERE ContactId=@ContactId " + Environment.NewLine + "SELECT @ContactId AS ContactId " + Environment.NewLine; } else { sqlStatement += "INSERT INTO Contact( " + Environment.NewLine + "FullName," + Environment.NewLine + "Email," + Environment.NewLine + "Phone," + Environment.NewLine + "Address," + Environment.NewLine + "CompanyId," + Environment.NewLine + "UserAccountId," + Environment.NewLine + "Position," + Environment.NewLine + "DepartmentId," + Environment.NewLine + "Deleted)" + Environment.NewLine + "VALUES (" + Environment.NewLine + "@FullName," + Environment.NewLine + "@Email," + Environment.NewLine + "@Phone," + Environment.NewLine + "@Address," + Environment.NewLine + "@CompanyId," + Environment.NewLine + "@UserAccountId," + Environment.NewLine + "@Position," + Environment.NewLine + "@DepartmentId," + Environment.NewLine + "@Deleted)" + Environment.NewLine + "SELECT SCOPE_IDENTITY() AS ContactId" + Environment.NewLine; } //execute entityObject.ContactId = Connection.ExecuteScalar <int>(sqlStatement, new { ContactId = entityObject.ContactId, FullName = entityObject.FullName, Email = entityObject.Email, Phone = entityObject.Phone, Address = entityObject.Address, CompanyId = entityObject.CompanyId, UserAccountId = entityObject.UserAccountId, Position = entityObject.Position, DepartmentId = entityObject.DepartmentId, Deleted = (entityObject.Deleted ? 1 : 0) }, Transaction); return(entityObject); }